>> Peta Laman >> News
AUTO-BACKUP YOUR NUKE DATABASE
#69 - 0--zulkiply--AUTO-BACKUP YOUR NUKE DATABASE--2007-03-03 22:22:19
Making backups is essential because problems inevitably occur and you need to be in a position to take action when disaster strikes. Are you maintaining your databases properly? Do you participate in a backup and recovery routine that checks on the health of the data? Spending a few minutes to make an easy, convenient backup of your database will allow you to spend even more time being creative and productive with your website.
For whatever reason, online remote backup services are popping up all over the technology landscape and it is inevitable. - What are the common or disastrous / catastrophic event for making backup?
There are four main ones that recur enough to be worth incorporating into your backup and recovery plan.
1) Migrate to another web-hosting
2) Website attacked by terrorist/hackers
3) Tables and data got corrupted by various reasons
4) Server failure
HOW TO AUTO-BACKUP YOUR DATABASE
There are several ways to backup your database. However, i would like to suggest you use phpmySQLAutoBacup which you can download it at http://www.dwalker.co.uk/phpmysqlautobackup/
You can also get it here at my my download page
So far I found it this is the easiest way of making backups. Thanks to Dave of www.dwalker.co.uk for the excellent script. phpMySQLAutoBackup automates the backup of MySQL databases. The PHP scripts export your database (data and structures), compresses it into gzip format and emails it to you or you can store it in a specified location at your server. You can schedule it to run every day/week by adding it to a cron job via your CPANEL, or use the phpJobScheduler
After you download your copy of phpMySQLAutoBackup, unzip the files. Fire up the the run.php file by using your notepad/wordpad and configure your installation, add your details to the following variables within file /phpMySQLAutoBackup/run.php:
$db
set to your MySQL database name
$mysql_username
set to your MySQL username
$mysql_password
set to your MySQL password
$emailaddress
set to your email address to send backup files to
a word form the author:
//best to specify an email address on a different server than the MySQL db
$save_backup_zip_file_to_server
If you set the variable $save_backup_zip_file_to_server to 1 then the backup files will be saved in the folder: /phpMySQLAutoBackup/backups/
(you must also chmod this folder for write access to allow for file create)
And finally upload to your server. You should upload the files and folders retaining the original names
When you run the script, your mysql database will automatically backed-up and the zipped file will be emailed to you or saved in the backup folder (whatever your choice is).
HOW TO TO DO THE CRON JOB?
This script should be run occassionally and thanks to cPanel for having a CRON JOB feature in it. cPanel has two easy to use interfaces for dealing with cron jobs: a user friendly one, and a more traditional Unix style one. Use whichever you feel comfortable with, but the user friendly one has slightly fewer options. To access the cron job manager, click "Cron Jobs", and then click on the appropriate button: There many good tutorials on how to use the cpanel's cron job such as an excellent one here:
http://www.upstartblogger.com/how-to-create-a-cron-job-in-cpanel
Do it now folks! Anything can happen tonight and be prepared for the unforseen circamtances which might fall on you.
--comments-->4--4464--2
