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).

...