?
Solved

Upgrade Mysql to 5.1.59 or .58 on Ubuntu Server Natty

Posted on 2011-09-28
4
Medium Priority
?
355 Views
Last Modified: 2012-05-12
I really need some help getting mysql upgraded on my ubuntu 11.04 server.

I have a practice server to test this on because when I do the live i need it to work flawlessly.

I have tired myself to upgrade but cannot get it to work. Numerous problems arise. Can anyone give me a walkthrough that they know works perfectly.

I have php 5.3.5 and Mysql Server 5.1.54 currently installed.

Ultimate solution would allow 5.3.8 and 5.1.59 installed

I would settle for getting php 5.3.6 and Mysql 5.1.58 if's possible to drop in the Oneiric packages somehow and just get them working.
0
Comment
Question by:NorthReptile
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 24

Accepted Solution

by:
johanntagle earned 1000 total points
ID: 36715812
I don't know about PHP, but when I upgrade MySQL I normally do:

1.  Shut down mysql
2.  Backup the whole data directory (check your my.cnf for this)
3.  Uninstall the old MySQL
4.  Install new version
5.  Shutdown the newly installed version
6.  Copy back the data directory
7.  Start MySQL
0
 

Author Comment

by:NorthReptile
ID: 36715910
I really need a very specific Ubuntu 11.04 installation/upgrade guide. I have spent the last 3 hours trying to get the test server up and running again which included manually removing every trace and purging the packages and reinstalling and still it fails to start. Even with the default packages in apt still installed and the my.cnf and /var/lib/mysql folder restored it still won't start.

I really don't understand why upgrading a database application in Linux is so damn hard.
0
 
LVL 24

Expert Comment

by:johanntagle
ID: 36716456
Look for the error log location in your my.cnf and take a look at it.  That should contain the error message related to why MySQL won't start.  Also check the permissions of /var/lib/mysql directory and its contents.

It shouldn't be that hard - you are likely just missing something.
0
 

Author Comment

by:NorthReptile
ID: 36716517
I managed to get it started again after a lot of playing around.

I have added the Oneirc repos and upgraded the packages which gets me as far as 5.3.6 and Mysql 5.1.58 which is a good start.

Still looking for a good 5.3.8 / 5.1.59 solution though.
0

Featured Post

Building an interactive eFuture classroom

Watch and learn how ATEN provided a total control system solution including seamless switching matrix switch, HDBaseT extenders, PDU, lighting control to build an interactive eFuture classroom.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question