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
cPanel Auto Backup via FTPS (Explicit)
So, you’ve got cPanel Shared Hosting and your host doesn’t provide backups, the data has some value to you, do you trust them not to lose it? Manually logging in to cPanel and backing up every day is not viable, especially if you have several accounts, FTP or WebDAV is also no good as it…
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