MySQL: going from 4.1 to 5.0..

Thread view:

Frances - 01 Nov 2005 16:38 GMT

I have MySQL 4.1 installed in my machine (W2000), would like to upgrade
to 5.0.. before I do that I need to know two things:

1) do I need to un-intall 4.1 first, and

2) what will happen to my DB's? if I un-install 4.1 will that also
delete DB's? (I suppose I can back them up.. will they still work if I
just copy them back into 5.0?)

thank you..

Reply to this Message

Bill Karwin - 04 Nov 2005 07:41 GMT

> I have MySQL 4.1 installed in my machine (W2000), would like to upgrade
> to 5.0.. before I do that I need to know two things:

Have you read this page:
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html

> 1) do I need to un-intall 4.1 first, and

It is safest to do so. For instance, if you are using Windows as your
database server host, and you do not unregister the MySQL service, the
installation of MySQL 5.0 may fail. See
http://dev.mysql.com/doc/refman/5.0/en/windows-upgrading.html

> 2) what will happen to my DB's? if I un-install 4.1 will that also
> delete DB's?

In general, uninstalling any product should not remove any files other
than those that were created when the product was installed. For
instance, configuration files that you edited, log files, databases,
etc. should be retained after the product is uninstalled.

On the other hand, I seldom trust that this will work as intended.
Always back up important data before making changes to the software, or
else eventually, you _will_ get caught by a bug and lose your data.

> (I suppose I can back them up..

You don't normally back up your databases as a matter of course?!?

Regards,
Bill K.

Reply to this Message

MySQL: going from 4.1 to 5.0..

Free Magazines