how to upgrade mysql from 3.2 to 4

[maryam421]

Hi,
I am trying to upgrade from 3.2 to 4. What do I need to upgrade? should I do the fresh installation of 4 and then do the sqldump?
I am very new to mysql please help.
Thanks

 

[QatQat]

Linux or windoz?


Cheers

QatQat

Life is what happens when you are making other plans.

 

[maryam421]

Linux

 

[guelphdad]

mysql has good information on their website about upgrades. specifically you should upgrade to version 4.0 first and then version 4.1.

is there a reason you aren't upgrading to mysql 5 which is the latest stable release?

 

[Kozusnik]

If it's an rpm-based distro like RedHat ot Mandrake, just remove the old program and install the new one. Be sure to back up the databases beforehand. I've done this before with no issues. I also went from 4.1 to 5.0.

If it was compiled, then installed, by all means, read the doc on mysql.org first.

Mark

 

[maryam421]

We are using redhat linux enterprise edition. Application requires 4.x not 5.x. Might be compatability issue.
This is what I am planing to do:
1. Install 4.x on a separate directory structure.
2. Start 4.x.
3. Let the two instance running at the same time. As I have to schedule the down time for the application.
4. Create a dump file using mysqldump utility for version 3.x.
5. shutdown the version 3.x
6. Import the dump to 4.x
7. Down the road remove the 3.x version.

The only problem I see with this case is connectivity issue. I am not sure bot the instance can run at the same time. Also how to configure the connections, since both of them will be running at the same time?
Any help would greatly be appreciated.
Thanks