[SOLVED] upgrade mysql

ggalan · 04-04-2012, 01:29 PM

can anyone lend a hand please
i am trying to upgrade mysql by

Code:

sudo mysql_upgrade -h <whatgoeshere> -u mysqlUser -p mysqlPass

is this how you do it? also what do i place in the <whatgoeshere> area?

bigrigdriver · 04-04-2012, 02:31 PM

Are you trying to upgrade your mysql installation, or trying to upgrade your mysql tables to the currently installed version of mysql?

If you want to upgrade the mysql installation, use your distros package management tools to upgrade mysql.

ggalan · 04-04-2012, 02:38 PM

im a newb : )
i have mysql 5.1.52
want to upgrade to 5.5 because of sql queries

from your question, where would that fall under?
also how would i "use your distros package management tools"

also, i am on LAMP ec2 basic linux

lithos · 04-04-2012, 02:59 PM

Quote:

Originally Posted by ggalan

im a newb : )
i have mysql 5.1.52
want to upgrade to 5.5 because of sql queries

.......
also, i am on LAMP ec2 basic linux

If you want MySQL 5.5 then you are

Quote:

Originally Posted by bigrigdriver

Are you trying to upgrade your mysql installation.
....

Your distro seems to me like Amazon EC2 cloud, which I searched on google, and it's running REDHat.

So you upgrade it from command line:

Code:

yum search-update mysql

and if succesful, then

yum update mysql

as root user.

But I believe that RedHat won't be choosing latest versions of packages, because of possible bugs etc.
so your upgrade is pointing to fail.

good luck

ggalan · 04-04-2012, 03:06 PM

thank you

Quote:

sudo yum update mysql

did it but as you said i am still on 5.1
is 5.5 beta?

lithos · 04-04-2012, 03:13 PM

No,

it's not beta, latest community release is "5.5.22"

But RedHat has not confirmed / integrated the packages into the Repositories for installing it, so until then you're out of luck I guess.
It's RedHat's policy you have to comply if you're using it.

You can, ALTHOUGH, use a not approved by RedHat method install 5.5.11
also you can take a look here - MySQL 5.5 Available on Oracle Linux 6 and RHEL 6.