How to Backup mySQL Database With phpMyAdmin

Have you ever lost all your computer files because you didn’t back them up?

It’s a sickening feeling when you can’t restore thousands of files collected over several years of work. The same thing can happen to your forum, blog or CMS web site that uses a mySQL database to store information. One of the easiest and most full proof backup methods is to use phpMyAdmin.

How to use phpMyAdmin

Go to cPanel->mySQL databases->phpMyAdmin and choose your database.
Click on the Export link.
Choose Select All to select all the tables.
Select “SQL”->for output format.
Check “save as file”
Select gzipped and hit Go to download the backup file.
Save it to a folder labeled “backupFeb08″ so you know when you created the last backup.

Create a backup the first of every month.

How to restore a backup of a mySQL database

Click the SQL tab
On the “SQL” page, unclick “show this query here again”
Browse to the backup of the database on your computer
Click Go.

*****************************************
Herman Drost is the Certified Internet Webmaster (CIW)
owner and author of Web Site Design, Web Hosting, Search Engine Optimization

Receive fresh, in-depth articles articles on how to design, optimize and promote your web site by subscribing to his “Marketing Tips” newsletter at: http://www.isitebuild.com/

This entry was posted on Saturday, February 23rd, 2008 at 9:54 am and is filed under Web Hosting . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

«
»

6 Responses to “How to Backup mySQL Database With phpMyAdmin”

  1. Web Design Discussion » Blog Archive » How to Backup SQL Database - 4 Top Methods Says:
    February 23rd, 2008 at 9:57 am

    [...] read my next post [...]

  2. How to Migrate Joomla 1.0 to 1.5 Says:
    April 29th, 2010 at 7:05 pm

    [...] If you wish to do the backup yourself download all the files from the server to your desktop first then create a backup of your database [...]

  3. Moving Wordpress to a New Server Says:
    March 6th, 2011 at 9:33 am

    [...] Alternatively you can backup the database using phpMYAdmin (cpanel — databases — phpMYAdmin) Read How to Backup mySQL Database With phpMyAdmin [...]

  4. Excel to mySQL: How to Use Excel to Import/Export Tables to/from a MySQL Database Says:
    April 16th, 2011 at 1:17 am

    [...] How to Backup mySQL Database With phpMyAdmin How to Save Form Data to a Database – Create MYSQL database Moving WordPress to a New Server Step by Step [...]

  5. Creating a database driven website Says:
    April 23rd, 2011 at 6:57 am

    [...] to Build a Database Driven Web Site How to Backup mySQL Database With phpMyAdmin Moving WordPress to a New Server Step by Step How to Use Excel to Import/Export Tables to/from a [...]

  6. How to Add a Database to a Website Says:
    May 23rd, 2011 at 7:48 am

    [...] 7 Benefits of creating a database driven website How to Build a Database Driven Web Site How to Backup mySQL Database With phpMyAdmin Moving WordPress to a New Server Step by Step How to Use Excel to Import/Export Tables to/from a [...]

Leave a Reply