Line 50: | Line 50: | ||
#Edit the '''\thegpm\thegpm-cgi\dbcommon.pl''' file. Define usernames and passwords for both the read-only database user and root-like user. NOTE: is is NOT recommended to use the root username and password you defined during MySQL setup in the '''dbcommon.pl''' file. | #Edit the '''\thegpm\thegpm-cgi\dbcommon.pl''' file. Define usernames and passwords for both the read-only database user and root-like user. NOTE: is is NOT recommended to use the root username and password you defined during MySQL setup in the '''dbcommon.pl''' file. | ||
#Edit the '''\thegpm\thegpm-cgi\defines.pl''' file. | #Edit the '''\thegpm\thegpm-cgi\defines.pl''' file. | ||
- | #Log | + | #Set up the MySQL table |
+ | ##Log into MySQL as the root user you defined during its installation. Then, type: <tt>source <base_path>/thegpm/scripts/create_localgpm_databases_tables.sql;</tt>. This will create the GPMDB database and table structure that will be populated after data files are submitted to the identification software. | ||
#Schedule the execution of the '''\thegpm\scripts\popGPMDB.pl''' script, which parses the XML files created by the search software and adds them to the database. | #Schedule the execution of the '''\thegpm\scripts\popGPMDB.pl''' script, which parses the XML files created by the search software and adds them to the database. |