Creating My Sql Backup Using Cron

  • 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.