Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This page shows how to restored a saved MySQL database, and how to load an old database into a new one.

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

2) To restore into a new database, Click the "Create new schema" icon, put in a new name for the database, click "Apply"; click "Apply" and "Finish" in the next two screens.

3) Click "Data Import/Restore,", select "Import from Self-Contained File," choose the file (see backup/save), select the "schema" (what we call database) to restore into, click "Start Import." You will see a log window, which will indicate whether the import was successful. 

4) If a new database (schema) was created, apply user permissions.  

 

 

  • No labels