Note: for a consistent backup of a live MySQL system, it is recommended to use a single transaction option or explicit locks on the database, as detailed in this tutorial.ģ. $ sudo tar cvfvz /backup/mysql_data.tgz /var/lib/mysql $ sudo sh -c 'mysqldump -u root -p -A -events > /backup/backup_db.sql' sql file, and back up MySQL data directory. $ sudo tar cvfvz /backup/mysql_conf.tgz /etc/mysqlĢ. Back up your MySQL config files $ sudo mkdir /backup Here I am going to demonstrate how to upgrade MySQL 5.5 to 5.6. In this tutorial, I assume that you have already set up MySQL with apt-get. For those of you wanting to try out the latest bleeding edge MySQL, I will describe how to upgrade MySQL server on Debian or Ubuntu.

New versions of MySQL are constantly released, targeting better performance and scalability. One of routine tasks for system admins is to update installed programs with the latest patches and hotfixes, as well as upgrade software to a more recent release with new bells and whistles. How to upgrade MySQL server on Debian or Ubuntu

Debian 10 mysql