The mysql database

Within the DCSS project the /usr/local/dcs/dcss/examples/ directory contains two files related to the mysql database.

• databaseTables.txt

  This file can be used to create a database that DHS and DCSS expects to see during run time.

• exampleFullDatabase.txt

  This file is the same as databaseTables.txt except that the file also contains a snapshot of the state of SSRL's database on a particular date.

The following directions for using these files are intended to be a guideline only - knowledge of mysql database management is still necessary.

1. From the mysql prompt type:

   CREATE DATABASE beamline_configuration;

2. From the shell prompt type:

   mysql -u root -p beamline_configuration < databaseTables.txt

3. The "SELECT" privileges for DHS and DCSS must be added to the built-in mysql database.

   From the mysql prompt type:

   	
   GRANT SELECT ON beamline_configuration TO dhs@yourhostname;
   GRANT SELECT ON beamline_configuration TO dcss@yourhostname;
   FLUSH PRIVILEGES;