$ sudo cp /opt/mysql/server-5.6/support-files/rver /etc/init.d/mysqlġ1. Copy the MySQL startup script to /etc/init.d and install the script into the boot sequence, so that MySQL server starts up automatically upon boot. Lc-messages-dir = /opt/mysql/server-5.6/shareġ0. Open the MySQL config file with a text editor, and update the following two entries. On Ubuntu or Linux Mint: $ sudo sh -c 'echo 'PATH=$:/opt/mysql/server-5.6/bin' > /etc/environment'ĩ. On Debian: $ sudo sh -c 'echo 'PATH=$PATH:/opt/mysql/server-5.6/bin' > /etc/profile' Add the MySQL bin directory to the PATH variable system-wide. The MySQL package will be installed under /opt/mysql directory.Ĩ. Download a MySQL Debian package from the official site.ħ. Install MySQL dependency (kernel asynchronous I/O access library) which is needed for MySQL 5.5 and higher. $ sudo apt-get remove mysql-server mysql-client mysql-commonĭo not use purge option in apt-get as that would remove MySQL config files and other MySQL related data directories as well, which we will continue to use after MySQL upgrade.ĥ. 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

Mysql server debian