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

« Previous Version 3 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. You will also need to give user permissions (see user page) for the new database (after it's created).

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. 

  

 

 

  • No labels