You can import and export MySQL databases for a variety of scenarios, including:
- Transferring a database from one web hosting account or provider to another.
- Importing a third-party database.
- Backing up a database.
To import a MySQL database using phpMyAdmin, follow these steps:
- Log in to your cPanel account.
- In the Databases section of the cPanel home screen, click phpMyAdmin.
- In the left pane of the phpMyAdmin page, click the database that you want to import the data into.
- Click the Import tab.
- Under File to Import, click Browse, and then select the dbexport.sql file on your local computer.
- Click Go. The import process runs.
- The database should now contain the data that is in the dbexport.sql file.
To Export a MySQL database using phpMyAdmin, follow these steps:
- Log in to your cPanel account.
- In the Databases section of the cPanel home screen, click phpMyAdmin.
- Click the database you are working with in the left menu
- Click Export in the top menu
- Under the Export heading, ensure that all of your tables are selected and that the SQL option is selected.
- Under the Options heading, ensure that you have selected, Add DROP TABLE / VIEW / PROCEDURE / FUNCTION
- Ensure the Save as file option (towards bottom of page) is checked. If you think you database is quite large, choose either "zipped" or "gzipped" to compress the file so it will be easier to download. If you choose none, you will be save the file without compression (which is OK, you don't have to compress the file).
- Click Go
- You will be prompted to either open or save the file. Please select the option to save the file and then save the somewhere you'll remember (such as directly on your desktop).