Regular backups are vital for safeguarding your MySQL data. This guide explains how to automate daily MySQL database backups using cron and how to clean up old backup files older than 10 days to manage disk space efficiently.<\/p>\n
Let us follow the steps:<\/strong><\/p>\n Replace username and your-server-ip with your actual credentials.<\/li>\n Let us understand the above command,<\/p>\n Save and exit the editor. Replace \/home\/mysql_backup\/<\/strong> with your actual backup directory path.<\/li>\n<\/ol>\n<\/li>\n This command will eliminate \u201c.sql\u201d files in the backup directory that are older than 10 days.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n This way, with these cron jobs in place, your MySQL database will be backed up daily, and old backups will be automatically removed to conserve disk space. Always check your backup and cleanup scripts before depending on them in the production arena. However, if you need any help, feel free to contact our support team.<\/p>\n New to setting up cron tasks? Learn How to Create a Cron Job in Linux<\/a><\/strong><\/em><\/p>\n","protected":false},"excerpt":{"rendered":" Regular backups are vital for safeguarding your MySQL data. This guide explains how to automate daily MySQL database backups using cron and how to clean up old backup files older…<\/p>\n\n
ssh username@your-server-ip<\/pre>\n
[client]\r\nuser=root\r\npassword=yourpassword<\/pre>\n<\/li>\n
chmod 600 \/root\/.my.cnf<\/pre>\n<\/li>\n
crontab -e<\/pre>\n<\/li>\n
0 0 * * * \/usr\/bin\/mysqldump --single-transaction --quick --routines --triggers accu_4 | gzip > \/home\/mysql_backup\/accu_4-$(date +\\%Y_\\%m_\\%d).sql.gz 2>> \/home\/mysql_backup\/backup.log<\/pre>\n
\n
\nImportant:<\/strong> Make sure the target backup directory exists and is writable by the cron user.<\/li>\n<\/ol>\n<\/li>\n\n
\n
vi \/opt\/remove.sh<\/pre>\n<\/li>\n
find \/home\/mysql_backup\/*.sql -mtime +10 -exec rm -f {} \\;<\/pre>\n
\n<\/strong>Add the below code to your crontab to run the cleanup daily at 2:00 PM<\/strong>:<\/p>\n00 14 * * * sh \/opt\/remove.sh<\/pre>\n