Frequently asked questions

Back
How do I import my MySQL database with MySQL Workbench?

The program MySQL Workbench, available for Windows, Mac and Linux, is an easy-to-use program for administering and backing up a MySQL database. Follow these steps to import your database and/or backup with MySQL Workbench.

Note! Version 6.3.6 has a serious bug and cannot be used. 6.3.4 og 6.3.5 ought to work.

  1. Open your .sql file in e.g Textwrangler or other editor, and make sure the details for your new database is updated. These details(host and databasename) were sent to you when the database was created.
  2. Check that you have a recent version of MySQL Workbench installed, e.g. version 6.1 or newer. You will see this error message at the bottom of the window if you have an outdated version.
  3. Create a new connection profile by clicking on the plus sign next to "MySQL Connections".
  4. Enter the recieved login information for MySQL.
  5. When the connection profile is created, click on it to connect.
  6. Note: connecting MariaDB databases may result in a warning about MySQL version 10.0.xx. This is not a problem, click "Continue Anyway".
  7. Enter the program menu, select "Server", and then "Data Import".
  8. Select "Import from Self-Contained File" and choose which file you want to upload. Now you can start the import by clicking on "Start Import"
  9. If the import was successful you will see the following message.

See also:

Keyword:  

Index

© 2017 Domeneshop AS · About us · Terms & Conditions · About cookies