MySQL/MariaDB Backup Cron 1-liner
Here’s a quick one-liner you can put in your crontab to dump and compress a MySQL or MariaDB database and keep the previous backup. Adjust accordingly. This will run at 5AM every day, rename the old backup filename and dump and gzip the new backup. Note there is no space between -p and your password.…
Read more
MariaDB Full Backup and Restore with mariabackup
If you have a large database you will soon discover that mysqldump takes a long time, thankfully MariaDB comes with its own backup program ‘mariabackup’. You can get more information and guides about Mariabackup on the MariaDB website. Generating a backup is quite simple and there are several different ways to do it, I like…
Read more
Recent Comments