1

Centos backup mysql using cron job

view story
linux-howto

http://serverfault.com – According to this tutorial http://www.a2hosting.com/kb/getting-started-guide/backing-up-your-data/b... trying to backup mysql database I did: 1) created folders in home directory. /home/USERNAME/backup/ 2) in folder backup created file, named backup-cron-mysql.sh 3) created content of backup-cron-mysql.sh #!/bin/bash db_name=dabase_name db_user=user db_password=password backup_filename=$db_name-`date +%F` mysqldump -h localhost -u $db_user -p$db_password $db_name | gzip > /home/USERNAME/dbbackup/$backup_filename.sql.gz Made backup-cron-mysql.sh execut (HowTos)