![how to create mysql database workbench how to create mysql database workbench](https://dataedo.com/asset/img/kb/db-tools/mysql_workbench/reverse_engineering.png)
Select the “Default Target Schema” from the drop-down. Select “Import from Self-Contained File,” and locate the backup file that will be used for restoration.
![how to create mysql database workbench how to create mysql database workbench](https://peter-whyte.com/wp-content/uploads/2019/10/mysql_workbench_create_table_and_insert_data.png)
See “ Making a MySQL Database Backup With MySQL Workbench,” for an explanation of the difference between a self-contained file and a dump project folder. Now click the “OK” button in “Manage Server Connections” to close the connection test window.Ĭonfiguring MySQL Workbench to Restore (Import) Your DatabaseĬlick the box for the database connection that you just set up.įor this tutorial, we’re assuming you are restoring a “Self-Contained File” backup. Click the “OK” button and move on from there. If everything is correct, you’ll see the successful connection box. If you get a “Cannot Connect to Database Server” error, check your entries in the connection fields.