How to upgrade mysql 5.5 to Mysql 5.6 on 12.04?

Question

I need to install Mysql-server-5.6 in my ubuntu development server 12.04. Now it is running percona-server5.5. How can i upgrade this to mysql-5.6 ?

I tried them too. Found out that they don't work out of the box, not to mention not playing well at all with Ubuntu standards (file locations, init scripts, conflict handling etc.). See my detailed answer below. — arielf, Feb 25 '13 at 23:51

score 6 · Accepted Answer · answered Jun 24 '13 at 13:43

6

I have prepared experimental PPA with MySQL 5.6 packages based on MySQL 5.5 Debian packages. No guarantee that it will work right away, but I would be grateful if you can try it and report back success (or failure).

The PPA can be found at: https://launchpad.net/~ondrej/+archive/mysql-experimental

There's also a MySQL 5.5 PPA with latest upstream release found at: https://launchpad.net/~ondrej/+archive/mysql

answered Jun 24 '13 at 13:43

oerdnj

7,940

Please don't post the exact same answer to multiple questions. While it's certainly useful, this is not considered the nicest thing to do; "rep chasers". Instead, I think you can comment with a link to the question with useful answers. – gertvdijk Jun 24 '13 at 13:53
1

@gertvdijk Ok, will do next time. The real problem is that those questions should be marked dupes. – oerdnj Jun 24 '13 at 14:01
1

You're right. Marked as such. – gertvdijk Jun 24 '13 at 14:07
@gertvdijk I did as well (also on all the other duplicates). – oerdnj Jun 24 '13 at 14:10

score 2 · Answer 2 · answered Feb 20 '13 at 04:26

2

I have just written a blog post about upgrading mysql on ubuntu 12.04. You can find my post at http://www.peterchen.net/2013/02/20/en-how-to-install-mysql-5-6-on-ubuntu-12-04-precise/. Hope this will help you.

answered Feb 20 '13 at 04:26

empi89

77
1
2

4

Please include the essential details of the link in the answer itself. – ignite Feb 20 '13 at 05:08
@IgnitE is right, because now the link is broken, and so this answer is currently not helpful. However, I saw this article and it's quite long; I'd argue too long to post as an answer, and thus a link is warranted. – Tyler Collier Jul 29 '14 at 22:44

score 1 · Answer 3 · answered Sep 20 '12 at 11:56

1

this tutorial shows you in details how to.. But note that this is done to upgrade to 5.5 i think it's the same for 5.6

answered Sep 20 '12 at 11:56

You are welcome but if you find this answer is useful please make an upvote by clicking on the up arrow on the left side of the answer – Sep 24 '12 at 05:26
1

Whilst this may theoretically answer the question, it would be preferable to include the essential parts of the answer here, and provide the link for reference. – gertvdijk Jun 24 '13 at 13:47
You'd get more upvotes if you actually answered the question. The problem with links is they eventually expire and your answer becomes worthless. – Buttle Butkus Apr 17 '14 at 05:05

score 1 · Answer 4 · answered Feb 25 '13 at 23:46

I think you should stay with Percona. Both Percona and MariaDB are much better supported, especially on Ubuntu, than the Oracle MySQL distributions. Going the Oracle route will lead to many incompatibilities with how software is being managed, configured, started/stopped, etc. on Ubuntu (or other debian derived distros).

5.6 is very new (as of Feb 2013 the package minor is alpha-60) so the apt-get method is not yet fully supported (for server-5.6) by Percona, as far as I can tell. You can however download the 5.6 *.deb packages for Ubuntu 12.04 from percona.com/downloads/ and then use 'sudo dpkg -i' locally to install them.

I would strongly advise against installing RPM packages on Ubuntu/Debian due to many incompatibility issues that may arise.

Another alternative, and IMHO a better one, is to stay with 5.5 (latest is actually 5.5.29 so it already includes many of the goodies from 5.6) for a while longer, and switch to 5.6 (package name: percona-server-server) once it is out of alpha. It shouldn't be too long now. To do so follow the instructions here

How to upgrade mysql 5.5 to Mysql 5.6 on 12.04?

4 Answers4