Backup of mysql database using cron job.
October 6th, 2009 | Author: Gunjan
To generate the backup of mysql database using cron job refer following three format as per your requirement.
1) Cron job to generate database backup in .sql format
* * * * * /usr/bin/mysqldump -u databaseusername databasename -ppassword > /path of database database.sql
2) Cronjob to compress database backup in .bz2 format
* * * * * /usr/bin/mysqldump -u datbaseusername databasename -pdatbasepassword|bzip2 -c > /path of database database.bz2
3) Cronjob to compress database backup in .gz format
* * * * * /usr/bin/mysqldump -u databaseusername databasename -ppassword|gzip > /path of databasedatabase.gz
If you have any problem or idea about this thread than contact me at linux7802@gmail.com
| 
| 
| 
| 
| 
| 
Posted in Basic Linux, Cron jobs issue, Mysql + phpmyadmin | 
Tags: backup for mysql database, Backup of mysql database using cron job., configure cron for the mysql, configure the cron for mysql databases backup, Cron job to generate database backup, cron to secure mysql database, Cronjob to compress database, mysql backup viz cron, mysql database backup in .bz2 format, mysql database backup in .gz format, mysql database backup in .sql format, secure the mysql databases viz cron, set cron for mysql, set mysql database backups