MySQL: Importing/Exporting a database
To export & import MySQL databases we recommend using the MySQL Workbench tool, which will connnect to the database using an external connection.
Importing a database from a file
To import a file, open Workbench and click on + next to the MySQL connections option. Fill in the fields with the connection information.
Once connected to the database go to Data Import/Restore. Choose the option Import from Self-Contained File and select the file.
Choose the destination database in Default Schema to be Imported To and then click on Start Import.
Once the import is completed, you should see all the available tables:
Exporting into a File
To export into a file, fire up Workbench and click on + next to the MySQL connections option. Fill in the fields with the connection information..
Once connected to the database, under Management, choose Data Export. Select the files to be exported and the configuration:
Dump data and Structure: this means that the data as well as the structure of the database will be recorded.
Export to Self-Contained File: the database will be exported into a new file.
Now click on Start Export.
A .sql file will be created in your local computer with all the data, its content should be something similar to this:
In order for the connection to be successful, the Allow external connections option should be enabled.