Some links to mysql commands
http://www.tech-geeks.org/contrib/mdrone/mysql-cheatsheet.html
http://nparikh.freeshell.org/unix/mysql.php
http://realprogrammers.com/cheat_sheet/MySQL/new_db_and_user.html
http://mysql.zaptech.org/notes.html

Logging into mysql is done with our script: 'loginsql'
(use the passwd that appears). You can also log in manually

mysql> show databases;
+-------------+
| Database    |
+-------------+
| domprodtest |
| fat         |
| test        |
+-------------+

'fat' contains simple DOM information
'domprodtest' contains the results of the tests (STF, multimon etc.)

mysql> use fat;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Database changed
mysql> show tables;
+---------------+
| Tables_in_fat |
+---------------+
| defhv         |
| doms          |
| domtune       |
| mirrors       |
| pmts          |
| positioning   |
| station_calib |
| swupdates     |
+---------------+
'doms' contains the travelers' information
'domtune' contains the calibrated HV and settings. The HV is changes in 'domtune' every time you run 'domcal'.

mysql> select * from domtune; 
Output found here  


Checking that sync and ref boards have HV set to 0:

'doms' Check that all relevant DOMs are there:

select * from doms; OR:
select * from doms where doms.serial>29;    (Output here)


Getting the domtune information for the DOMs is done like this: (output here)

select doms.name,domtune.* from domtune,doms where  doms.mbid=domtune.mbid AND (doms.serial>29 OR doms.name='SelDOM' OR doms.name='KingDOM');