From ICISWiki

Setup of fresh/blank central

1. Create blank database:

http://cropwiki.irri.org/icis/index.php/MS_Access_to_MySQL_conversion_of_ICIS_databases#2._Create_an_empty_destination_MySQL_database_first.

2. Define ICIS table structures

http://cropwiki.irri.org/icis/index.php/MS_Access_to_MySQL_conversion_of_ICIS_databases#3._Run_the_.SQL_file_on_the_MySQL_database_to_create_tables

3: Define indices

http://cropwiki.irri.org/icis/index.php/MS_Access_to_MySQL_conversion_of_ICIS_databases#Central_database

4. Source-in sql scripts containing meta data (e.g. locations).

Scripts for GMS and DMS meta data are here:(mysqlmetadata.zip)

ftp://ftp.cgiar.org/icis/Ver5.5_Release/Databases/IRIS/