Follow

How to import and dump databases in MySQL (phpmyadmin)

Note: This page is intended for those who have more advanced requirements and knowledge of how to manage a database. If you are unsure of how this works, please contact support instead.

By clicking the edit button for a database, you can get additional information and also access a web-based tool called phpMyAdmin:

Start by logging into phpMyAdmin

 

Here you enter the username and password database when you created it.

After logging in you are met by the following view, which you can get more information about your database:

 

 

Import:

1. To import the data into your database, click on the "Import" in the menu bar at the top. You will see this screen:

 

 

2 . Select the file you want to import. This can be in plain text or compressed with gzip, bzip2, or zip.

3 . Select the format of the file you're importing. Is it a normal MySQL dump so the format is SQL. Other formats such as comma-separated values ​​(CSV), Excel 97-2003 or Excel 2007 and XML can also be managed.

Once you have made your selections, click "Go" in the lower right corner. Clear!

 

Export:

1. To create a dump of your MySQL database, go instead to the Export tab in the menu bar at the top. Then come together when the following view:

 

 

 

2. If you want to export the entire database, then just press the Go, but you can also choose to export only certain tables, change the character set and compression by checking the "Custom" in the "Export Method". You can also choose to export the database in a format other than the default SQL, such as CSV or JSON.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.