MySQL backup on Linux – How to easily automate it?
If you manage a Linux server that also runs MySQL databases, you might have wondered how to efficiently back up your database(s). Let’s take a look at automatic MySQL backup on Linux using commands and the CRON scheduler. This will allow us to create a schedule for automatic MySQL backups every night, saving them to SQL files, while also deleting backups older than 30 days. The result will be that a local backup of the database(s) will be created on the server, with backups available for up to one month. It’s important to note that … Read more