How do I update MySQL to 5.6 or above?


#1

I want to search an InnoDB table, but turns out InnoDB FULLTEXT support was added at MySQL 5.6.
So the question is, how can I update to 5.6 (or above)? and preferably without wiping my tables


Moving the default mysql version for new workspaces?
#2

I fixed it simply by executing:
sudo apt-get install mysql-server-5.6

And apt-get automatically removes the older version and installs the new one

BE SURE TO BACKUP YOUR TABLES FIRST, THEY ARE GOING TO BE WIPED!


#3

This is what i get -

sudo apt-get install mysql-server-5.6
Reading package lists… Done
Building dependency tree
Reading state information… Done
E: Unable to locate package mysql-server-5.6
E: Couldn’t find any package by regex ‘mysql-server-5.6’


#4

Try running sudo apt-get update and then trying again :slight_smile:


#5

sudo apt-get update
sudo apt-get install -y mysql-server-5.6
Reading package lists… Done
Building dependency tree
Reading state information… Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
mysql-server-5.6 : Depends: mysql-server-core-5.6 (= 5.6.33-0ubuntu0.14.04.1) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

then i run:
sudo apt-get install -y mysql-server-core-5.6
and again:
sudo apt-get install -y mysql-server-5.6

and go :slight_smile: