How to export a database using phpMyAdmin


Exporting a database means you are creating a backup of your database. It is usually a .sql file (a text file), and can be used to copy and import the database onto another server, mainly for moving a website. In this article you will get to know how to export your database.

Step 1: Login to phpMyAdmin

Step 2: Select the database that you want to export from the left menu


Step 3:Click Export in the top.

Step 4: Under the Export heading, ensure that all of your tables are selected and that the SQL option is selected.

Step 5: Under the Options heading, ensure that you have selected, Add DROP TABLE / VIEW / PROCEDURE / FUNCTION

Step 6: 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).

Step 7: Click Go

Step 8: 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.

Congratulations, you have just exported a copy of your database!