• View
• Edit
• History
• Print

CreatingMySqlBackupUsingCron

• Backup mysql db using Cron.

    date=`date -I` ; mysqldump -uusername -pthepass .all-databases | gzip >
    /home/linux/mysql_$date.sql.gz 

• Replace username and thepass with the correct username and the pass.
• The user need to have access to the database being taken for backup.