HostOnNet Blog

How to Back Up and Restore a MySQL Database using PHPMyAdmin

Looking for Linux Server Admin or WordPress Expert? We can help.

1, Open phpMyAdmin.


2, Select your database by clicking the database name in the list on the left of the screen.

3, Click the “Export” link. This should bring up a new screen that says View dump of database


4, Click on the “Save as” file option and the corresponding compression option and then click the ‘Go’ button. A dialog box should appear prompting you to save the file locally.


Restoring your database is easy as well as backing it up. Make the following:

1, Open phpMyAdmin.

2, To restore a database, click on the SQL tab.

3, On the “SQL”-page , unclick the show query here again.

4, Browse to your backup of the database.

4, Click Go.

About Annie

I've been working in Technical Section for over 10 years in a wide range of tech jobs from Tech Support to Software Testing. I started writing blog for my future reference and useful for all.
Posted in MySQL

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.