Posted by
Adminz
at
01.59
Read our
previous post
[HOW TO] Upgrade MySQL 5.5 to 5.6
In this case I using PLESK, UBUNTU 12.04 LTS
Create a full server backup and server snapshot.
Create a backup of /etc/mysql/my.cnf:
cp /etc/mysql/my.cnf{,_original}
COPY MYSQL DATA
service mysqld stop
(You must have /mnt/data/ folder in this case I mount my second HDD to /mnt/data)
mkdir /mnt/data/mysqlcopy
cp -aR /var/lib/mysql/* /mnt/data/mysqlcopy
Add the MySQL APT Repository:
Go to the download page for the MySQL APT repository at http://dev.mysql.com/downloads/repo/apt/.
Select and download the release package for your platform:
wget http://dev.mysql.com/get/mysql-apt-config_0.6.0-1_all.deb
Install the downloaded release package:
dpkg -i mysql-apt-config_0.6.0-1_all.deb
During the installation of the package, you will be asked to choose the versions of the MySQL server and other components that you want to install. If you are not sure which version to choose, do not change the default options selected for you. You can also choose none if you do not want a particular component to be installed. After making the choices for all components, choose Apply to finish the configuration and installation of the release package.
Update package information from the MySQL APT repository:
apt-get update
Upgrade MySQL:
apt-get -y install mysql-server
Agree when prompted to update /etc/mysql/my.cnf
if error try:
RENAME /etc/mysql/my.cnf to /etc/mysql/my.cnf_BAD
mv /etc/mysql/my.cnf{,_BAD}
sudo apt-get -y update
sudo apt-get -y install mysql-community-server
sudo apt-get -y build-dep mysql-server-5.6
sudo apt-get -y install mysql-server-5.6
In Plesk go to Tools & Settings > Server Components and click Refresh
service mysqld restart