• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

Upgrade Mysql to 5.1.59 or .58 on Ubuntu Server Natty

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
NorthReptile
Asked:
NorthReptile
  • 2
  • 2
1 Solution
 
johanntagleCommented:
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
 
NorthReptileAuthor Commented:
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
 
johanntagleCommented:
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
 
NorthReptileAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now