help upgrading mysql?

[marosell]

I am currently running mysql 3.23 and i'd really like to upgrade because i haven't in about 3 years, which can't be very secure. i'm very confused because:

 

This page in the documentation says:

If you wish to upgrade from a release series previous to MySQL 4.1, you should upgrade to each successive release series in turn until you have reached MySQL 4.1, and then proceed with the upgrade to MySQL 5.0

 

and this page in the documentation says:

[to upgrade] download the latest Windows distribution of MySQL

 

The latest distribution is 5.0, so if I do that, I won't be upgrading to each successive release.

 

What am I supposed to do? I'm running apache on a windows xp.

[fenway]

Go in stages: 3.23 - > 4.1 -> 5.0.  Remember to read up on the incompatible changes between versions, and backup your data (dump and files).

[marosell]

Alright, I succesfully backed up my databases, got 5.0 installed, and it's working. Unfortunatley, on my server information, the client version of mysql hasn't changed, it still says 3.23. Perhaps this was the version number in the backup that got placed in the new one? What did I do wrong?

[PFMaBiSmAd]

The "client" is the client library that is integrated into whatever program you are using to connect to mysql. To make use of all the latest functions and features of your new mysql version, you would need to upgrade the program you are using with mysql (php, mysql adiministrator...)