How do you update mysql?

[Red Squirrel]

I tried various lines such as:

yum update mysql
yum update mysqld
yum update mysql-server
yum update mysqld-server

I just can't seem to find the correct package name I have to put.

I have 5.0.67 according to -V but whatever I type says "no package available" or "no package marked for update".

I'm using FC10.

5.2 should be the latest mysql, at least I think....

Trying to enable the general log but it's not working, so I'm thinking I may need to update, if that feature was just recently put in. I type SET GLOBAL general_log = 'ON'; and get an error that general_log is an invalid variable, so it's probably only in the latest version. The doc I'm reading is for 5.2.3.

 

[Crusty]

Usually there are separate packages for mysql-5.0, 5.1, and 5.2.
Try something like yum install mysql-server-5.2

I don't know yum's syntax, but you should look into how to search the repository.

 

[n0cmonkey]

It looks like 5.0.67 is what's in the repo. I don't see 5.2. What are you missing that 5.2 provides?

 

[Crusty]

Originally posted by: n0cmonkey
It looks like 5.0.67 is what's in the repo. I don't see 5.2. What are you missing that 5.2 provides?

That's a good question, I haven't found a reason to upgrade past 5.0.* yet anyways 😛

 

[Red Squirrel]

I'm trying to enable the general query log, and some of the commands I"m finding that I have to type arn't working, so I figure it might be something that's in 5.2 and not in 5.0.

Not a biggie though, I just added SQL logging in my application, but I was curious to log right at the SQL level.

 

[Brazen]

Try "sudo yum list mysql*" and see what comes up.