04 Mei 2016

My Journey to WP_POSTS InnoDB Part 2

Posted by 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}


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

Select and download the release package for your platform:


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:

##apt-get install -y dpkg-dev
##apt-get remove -y dpkg-dev

sudo apt-get purge
sudo apt-get clean
sudo apt-get check

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

Supported by Android App Download! ©2012 Ramnul All Content Copyrighted and may not reproduced on other website