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/

Trackbacks

  1. […] 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 […]

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

  3. […] 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 […]

  4. […] 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 […]

  5. […] 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 […]

Speak Your Mind

*