To Upgrade - or not to upgrade

[LittleSmudge]

The Hardware technical people have decided that the servers at one of my client's are to be 'upgraded'.

As a result the server that MySQL is resident on will no longer exist.

As a first off I'm assuming that we can't just copy the C:\MySQL folder from the old server to the new one and expect it to work.
I'm expecting to have to do a complete install - Is that right ? Or is there a short cut ?



Secondly, the current version of MySQL in use is 4.0.12.
If we've got to do a complete re-install then it seems like a good time to get hold of the latest production version 4.1.10a and install that.
Will all of the data in the tables still be compatible or is there a convertion thats needed ?


Any other tips from the 'experienced' that I should be aware of ?





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[dalchri]

I would recommend doing the following to avoid any possibility of breaking your clients:

1) Install using the original installer for 4.0.12.
2) At this point, you should be able to copy C:\MySQL overtop the existing folder and expect it to work.
3) You might need to look out for the MySQL ini file. If memory serves me right, it is in the windows system folder somewhere.

Be sure to open up port 3306 if you are installing a newer OS like XP SP2 or server 2003 as your older OS probably did not block the port.

 

[Bastien]

Switching to 4.1x will involve some other growing pains in relation to db access...its best to move the data over to the same db version as previously stated...

Then you can play with installing another updated version and porting the code to the new libraries

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[TonyGroves]

You could certainly do it by simply copying across files - the mysql directory and my.cnf/my.ini - and then installing the service.

However, you'd most likely be better off installing the latest version, as it gives you access to the latest features and bug-fixes. The table files are compatible between the two versions; at least MyISAM files are between 4.0.18 and 4.1.7.