HostOnNet Blog

How to Back Up and Restore a MySQL Database using PHPMyAdmin

1, Open phpMyAdmin.

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

mysql_export

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.

exporting_tables

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