How to Export a Database using phpMyAdminWritten by Brad Markle
When you export a database, you are creating a backup file of the database. This backup file is usually a .sql file, and can be used to copy the database to another server. In this article we'll show you how to export your database. Generally when you export a database, one day you'll need to restore it (import). You can find more information on how to restore the export you're creating in this article here: How to Import a MySQL Database using phpMyAdmin.
To export your database, the first thing you'll need to do is log into phpMyAdmin.
If you are an InMotion Hosting customer:
- Log into your cPanel
- Click the phpMyAdmin icon under the "Databases" heading
If you are not an InMotion Hosting customer:
The steps to access phpMyAdmin vary depending on which hosting provider you are using. If your host uses cPanel, then you should log into cPanel and click the phpMyAdmin icon. If your host does not use cPanel, please contact their support department and ask them how you can access phpMyAdmin.
After you have logged into 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"
- Under the "Save as file" heading, ensure "Save as file". 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).
Congratulations, you have just exported a copy of your database!