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

You must be logged in to post a comment.

Well Golly


Atheism Plus

Buy from Amazon