SEM Blog: Website Marketing Blog

How To Make A Database Backup For A Blog Or Directory

Posted by Linda at April 1st, 2008

In the world of PHP and MySQL, databases have become a daily part of a webmasters and end users online experience. The database is the heart of your web site, without it most sites would not exist. Because the database is so critical it’s important to keep a fresh backup copy on hand in case something goes wrong.

Anyone with access to cPanel can easily save a backup copy of their database using the following steps.

1. Log into your cPanel (your domain.com/cpanel or domain.com:2082 or whatever your host requires).

2. Select the phpMyAdmin icon under databases OR Select MySQL Databases and then Scroll to the bottom and click phpMyAdmin (whichever your cpanel requires).

3. On the left hand side select the database you want to backup.

4. On the right hand side select the Export tab at the top .

5. On the right side towards the bottom check the box which says “Save as File”.

6. Below the “Save as File” select which type of compression you want (none, zipped, gzipped).

7. Click “Go” on the right hand side, this will begin the download of your database.