Now repeat step 4 to 6 to upgrade into 5. You are successfully upgrade into mysql5.6
#Mysql enterprise 5.5 update#
Step 6: Lets ready to upgrade, yum update Step 5: before upgrade stop service, sudo systemctl stop mysql Sudo yum-config-manager -disable mysql57-community Sudo yum-config-manager -disable mysql55-community Step 4: first enable to mysql 5.6 and disable mysql 5.5 and 5.7 sudo yum-config-manager -enable mysql56-community So first upgrade into mysql 5.5 into mysql5.6 Mysql57-community-source MySQL 5.7 Community Server - S disabled Mysql57-community/x86_64 MySQL 5.7 Community Server enabled: 384 Mysql56-community-source MySQL 5.6 Community Server - S disabled MySQL Enterprise Edition With Thread Pool MySQL Community Server Without Thread Pool MySQL Enterprise Edition 20x Better Scalability with Thread Pool MySQL 5.5.16 Oracle Linux 6.1, Unbreakable Kernel 2.6.32 2 sockets, 24 cores, 2 X 12-core Intel(R) Xeon(R) X5670 2. Mysql56-community/x86_64 MySQL 5.6 Community Server disabled Mysql55-community-source MySQL 5.5 Community Server - S disabled Will get something like below, mysql55-community/x86_64 MySQL 5.5 Community Server disabled We recommend that users who have installed MySQL 5.5.25 upgrade to MySQL 5.5.25a at the earliest opportunity. Because of this, MySQL 5.5.25 has been removed from the download sites. To validate and fix issues introduced from import of system tables like users ( ERROR 1805 (HY000): Column count of er is wrong.) mysql_upgrade -u root -p MySQL 5.5.25a is a replacement of MySQL 5.5.25, in that version a regression bug was detected in the optimizer (Bug 65745). As mentioned above, MySQL can run on cloud computing platforms instead of hardware. Note that MySQL Enterprise is the most popular among users. rss feed Accepted mysql-5.5 5.5.62-0+deb8u1 (source all amd64) into oldstable ( Roberto C. Step 5 : restore your data mysql -u root -p < dump.sql Standard, Enterprise, Classic, and Cloud Service are available options, with or without embedded databases. The BTS contains patches fixing 1 bug, consider including or untagging them. If you have create table and timestamp(6) column is used than default values should be changed from CURRENT_TIMESTAMP to CURRENT_TIMESTAMP(6) `event_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), Step 4 : edit your data to address differences between versions (5.5 and 5.7) Sudo dpkg -i mysql-apt-config_0.6.0-1_all.deb
#Mysql enterprise 5.5 install#
Step 3 : install new version of mysql 5.6 sudo apt-get install mysql-client-5.6 mysql-client-core-5.6
![mysql enterprise 5.5 mysql enterprise 5.5](https://image.slidesharecdn.com/mysqlenterpriseeditionensept2011v11-110921113152-phpapp02/95/mysql-enterprise-edition-17-728.jpg)
Step 2 : remove old mysql sudo apt-get remove mysql-server Step 1 : take a backup mysqldump -lock-all-tables -u root -p -all-databases > dump.sql