Restoring or Creating a New MySQL Database

This page shows how to restore a saved database, or create a new, empty database. This assumes you have MySQL installed, and that yu have an .sql file with a backup of the database.

1) Start with a saved *.sql file.

If you want to restore from a backup, use the *.sql file from that backup.

If you want to create a new, empty database, get the *.sql file in the spm12\toolbox\CSPM\Database subfolder.

Restore a backup from a differently-named database (unusual case)

If you want to restore this into a differently-named database, you will need to edit the file using Notepad. Look for the commands that create a database, and delete them. For example, the following *.sql file will create a database named "sidata14", so just delete the two lines highlighted in yellow.

Note: The above snapshot is in Notepad2, a replacement for Notepad which works much better; goodgle Notepad2, and choose the Windows x64 installer; it will replace Windows Notepad.

2) Open MySQL Workbench, Connect to Server (see earlier)

3) If there is a sidata14" schema (i.e., an existing database), right-click and select "Drop schema", "Drop now". This removes the old database.

4) To create a new, empty database: find the "sidata14" schema, right-click and select "Drop schema", "Drop now". This removes any old database.

Click "Data Import/Restore,", select "Import from Self-Contained File," choose the sql file (see 1 above).

Note for CSPM backups, the schema name is in the sql file. If you want to restore into a different schema, see note above. Click "Start Import." You will see a log window, which will indicate whether the import was successful. 

Now test the connection in CSPM Options, Local settings