Create MariaDB backup

I recently ran across a table that was not able to be read and it occurred to me that I should be archiving my database on a regular basis, rather than relying on just the Linode backups that are done nightly.

This command will do it for you:

mysqldump -u root --all-databases | gzip > backup.sql.gz

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.