Databases

Copying the SciMatch database to the server

1. Dump the database (it will require your user and password):

mysqldump -u user -p db > dump.sql

Note: change user and db with the appropriate names.

2. Enter into MySQL on the server, in the same directory where you copied dump.sql. The username is scimatch and the password, password:

mysql -u scimatch -p

3. The database is already created. Select it and fill it with the data from dump.sql:

use scimatch;
source dump.sql;

After use scimatch and source dump.sql, show tables can be used so we can check that the database is empty (at first) and then correctly copied.