Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

...

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. 

Image RemovedImage Added  

Now test the connection in CSPM Options, Local settings

...