Mysql database backup cronjob
Thursday, December 14, 2006
Cron is a linux utility that schedules a command (or commands) to be executed periodically at certain times
There are different format to get the backup of MySQL database using cron job:
1) Take database backup
* * * * * /usr/bin/mysqldump -u databaseusername databasename -ppassword > /path of database store.sql
2) Compress the database backup in gz format
* * * * * /usr/bin/mysqldump -u databaseusername databasename -ppassword|gzip > /path of database store.gz
3) Compress the database backup in bz2 format
* * * * * /usr/bin/mysqldump -u datbaseusername databasename -pdatbasepassword|bzip2 -c > /path of database store.bz2
posted by Admin @ 5:04 AM,
