Export a database via phpMyAdmin


How to export a database using phpMyAdmin?

Add Comment
1 Answer(s)
Best answer

Sometimes when you want to make some changes to the database associated with your website it is advisable to create a backup. To do so you need to export the database and save a copy on your local computer so in case that something goes wrong you can restore the application to its working condition.

To do so you first need to go to your cPanel.

Next go to the phpMyAdmin tool which is available under the Databases section:

RE: Export a database via phpMyAdmin

Find your database in the list on the left side of your screen and click on it. This will display all tables of the database:

RE: Export a database via phpMyAdmin

Now go to the Export section, select Quick export method, set the export format to SQL and click Go:

RE: Export a database via phpMyAdmin

The SQL file will be downloaded on your local computer.

Joe Benson Answered on December 19, 2016.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.