Backup and Restore your MySQL Database using phpMyAdmin

[ About This Author :: Request Reprint :: Print Article :: Tell A Friend ]

Backup and Restore your MySQL Database using phpMyAdmin

By Ben Sinclair
http://www.webmaster-resources101.com

Do you need to backup your MySQL Database information? Why not use phpMyAdmin!

First of all, you need to get into phpMyAdmin. If you have a website control panel(Ex: CPanel), you should be able to find it under <i>MySQL Databases</i> or <i>phpMyAdmin</i>.

If you don't have a website control panel, you should ask your web host where you can find phpMyAdmin. They may not have phpMyAdmin at all...

Once you're in, this is what to do:

<b>Getting Started:</b>

You should see some frames. Here is what it should look like:

<image src="images/phpmyadmin1.gif" border="0" height="250">

Now, select a database name you wish to backup:

<image src="images/phpmyadmin2.gif" border="0" height="260">

<b>How To Backup: </b>

Scroll down the page and find this:

<image src="images/phpmyadmin3.gif" border="0" height="260">

Select everything in the selection box or just the tables you wish to backup.

Then select:

Structure and data
Add 'drop table'
Complete inserts
Save as file

Then click go. It should open a notepad document which you need to save on your computer. Remember where you saved it.

<b>How To Restore:</b>

Scroll down the page and find this:

<image src="images/phpmyadmin4.gif" border="0" height="240">

You don't need to worry about the textarea box unless you are writing your sql by hand. Click browse and find your .sql file that you downloaded when backing up.

Then click go.

If you get a message saying your query was successful, you are now finished.

Good luck!

Discuss this in our Webmaster Forums

[ About This Author :: Request Reprint :: Print Article :: Tell A Friend ]