Upgrade MySQL to V3.23.54

[TartanTrader]

Hi All

 

I am about to upgrade my version of MySQL to Version 3.23.54. Does anybody know of a good reason not to and stay with the Version 3.23.37 that I have and works well.

 

Also, when I do upgrade how can I make sure that no one is using the shop and updating the db while I upgrade, can I take it off line some how?

 

Thanks

Phil

:)

[mattice]

Hi All

 

I am about to upgrade my version of MySQL to Version 3.23.54. Does anybody know of a good reason not to and stay with the Version 3.23.37 that I have and works well.

 

if it ain't broke don't try to fix it comes to mind... but check what will be the (security / bugs etc) benefits at www.mysql.com. They'll tell you ;)

 

Also, when I do upgrade how can I make sure that no one is using the shop and updating the db while I upgrade, can I take it off line some how?

 

Thanks

Phil

:)

 

You will need to stop the mysql deamon anyway won't you? If so people will get an error message. Just to make it look a bit cleaner you can put

die('Your html message here. Don't forget to escape the ' commas ! ');

in application_top.php

Test it on a bogus php file first.

 

that will kill any further output and make your shop UNREACHABLE beyond that point

so don't leave it hanging about for a couple of weeks ;)

[TartanTrader]

if it ain't broke don't try to fix it comes to mind...

 

Well its not broke but it has got a prog missing, I don't have the mysqlcheck utility and I belive it will be in the latest package. Do you know if this is correct ?

 

You will need to stop the mysql deamon anyway won't you?

 

How do I do this, never needed to so far, so I am not sure how to end the job ?

 

Thanks for your help

Phil

:)

[mattice]

on average linux system shell (being root or superuser) type:

 

/usr/local/mysql/bin/mysqladmin -uyourusername] -pyourpass shutdown

 

Windows? ctrl-alt-delete ;)

 

Since MySQL version 3.23.38 you will be able to use a new checking and repairing tool for MyISAM tables

 

 

HTH

Mattice

[TartanTrader]

but check what will be the (security / bugs etc) benefits at www.mysql.com. They'll tell you

 

I have always and still do find this site a wilderness of words, seeing as I don't know what I am looking for, I suppose it is unfair to criticise, but it does not jump out at you, that is for sure.

 

Can you point me in the right direction regarding the MySQL site.

 

Thanks

Phil

[mattice]

http://www.mysql.com/information/crash-me.php

allows you to compare 3.23.29 to 3.23.39...and commercial db's.

 

and in every distro there will be a CHANGES file that

has the revision history.

 

And the mysql site has a real handy search function:

 

http://www.mysql.com/search/index.php?q=ch...on%2Findex.html

[Harald Ponce de Leon]

I am about to upgrade my version of MySQL to Version 3.23.54. Does anybody know of a good reason not to and stay with the Version 3.23.37 that I have and works well.

 

Here is a very good reason why you should upgrade to 3.23.54:

 

http://security.e-matters.de/advisories/042002.html

[Guest]

but check what will be the (security / bugs etc) benefits at www.mysql.com. They'll tell you

 

I have always and still do find this site a wilderness of words, seeing as I don't know what I am looking for, I suppose it is unfair to criticise, but it does not jump out at you, that is for sure.

 

Can you point me in the right direction regarding the MySQL site.

 

Thanks

Phil

 

It will help if you give us a bit more information, like what type of server you are running. Then answers can be tailored to what you actually need and not just generalized.... as it is, people are giving answers for both unix and windows, which can be running IIS or apache, etc etc

 

:)

[TartanTrader]

I consider myself told off :(

 

It will help if you give us a bit more information, like what type of server you are running. Then answers can be tailored to what you actually need and not just generalized.... as it is, people are giving answers for both unix and windows, which can be running IIS or apache, etc etc  

 

I am running (or trying to anyway) a Cobalt RaQ 4 which has PHP Release 4.1.2-3 and Cobalt MySQL Release 3.23.37-1 on it.

 

It also has Relational Database Server and Client tools by InterBase. Release V6.0, what ever these are ?

 

I hope this helps more

 

Thanks

Phil