JackM wrote:

> I finally decided I was going to get around to updating my PHP and MySQL
> versions on my development machine. Downloaded PHP 5.2.5 and installed
> it with only minor problems that were easy to Google the answers for.
> But I'm finding that's not the case with upgrading MySQL.
>
> I have 3.23.xx currently installed. It was installed as a stand alone
> application, not part of any wamp package. In reading the instructions
> on the MySQL site, MySQL says I should upgrade from 3.xx to 4.xx before
> upgrading to 5.xx. But they don't put any version of 4.xx on their
> download site which makes it impossible for me to do it the way they say.
>
> My question is does that mean that my only option now is to do a
> complete new install of 5.0.51 from scratch or is there another way to
> upgrade from 3.23 to 5.0.51 without losing/wrecking any data that
> currently exists?

I did this upgrade. I had a few problems until I upgraded the tables
themselves. Deletes would crash the table and require a repair. The upgrade
of the tables fixed this ('alter table xxx Engine=MyISAM;' is all that was
needed).


_______________________________
Pete Mullins