MySQL Server source Codes for GMS Setup

From ICISWiki

UPLOADING LOCAL GMS TO CENTRAL GMS

1. Transfer MS Access Central and Local Database to MySQL.    

2. Download scripts and restore scripts on MySQL Local database.
         Script to check local database integrity. chkLocalGMS.sql
         Script to prepare local update environment. prepareLocalUpdate.sql
         Script to update locations table. updateLocations.sql
         Script to update listnms table. updateListNms.sql
         Script to extract all local germplasm without local references. extractLocalGermplsm.sql
         Script to update all remaining local germplasm references. updateLocalGMS.sql
         Script to check local update. checkLocalUpdate.sql
         Script to execute central changes and transfer local data to central. appendLocalGMS.sql
         * results from the queries inside this script must be checked for integrity.

3. Call procedures accordingly. 

CALL chkLocalGMS('localdb', 'centraldb');
CALL prepareLocalUpdate('localdb', 'centraldb');
CALL updateLocations('localdb', 'centraldb');
CALL updateListNms('localdb', 'centraldb', 'localdb');
CALL extractLocalGermplsm('localdb', 'centraldb');     * Procedure extractLocalGermplsm *must* be run again until GID turned no result.
CALL updateLocalGMS('localdb', 'centraldb');
CALL chkLocalUpdate('localdb', 'centraldb');
CALL appendLocalGMS('localdb', 'centraldb');