Tweet
I have an existing Cloud Linux server that is running MariaDB 10.1 and I would like to install the MySQL Governor. It recommends making a full database backup (including system tables) before installing.
My question is what is the best way to backup the entire MariaDB database?
In the past I would just rsync /var/lib/mysql/ to a backup location while the database was live. Then shutdown the database and run rsync a second time to shorten the amount of time the database is down. Is this the best way to do it or is there a better way?
Best regards,
Eric
My question is what is the best way to backup the entire MariaDB database?
In the past I would just rsync /var/lib/mysql/ to a backup location while the database was live. Then shutdown the database and run rsync a second time to shorten the amount of time the database is down. Is this the best way to do it or is there a better way?
Best regards,
Eric
Comment