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?

JackM wrote:

> 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.

You could dump all the content of the database to a file, clean out the
machine of MySQL and then install MySQL5 and import the dump, you will need to
reindex things and functions/procedures.

Maybe your web browser is so buggy it can't display HTML code?
http://dev.mysql.com/downloads/mysql/4.1.html

--

//Aho

On Apr 6, 8:47 am, JackM <notr...@earthlink.net> wrote:

>
> 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.
>

Contact their support email. There has to be a version 4.xx available
somewhere. If you don't get a timely response (many companies give
low priority unless you're paying $$ for support), call them on the
telephone.

If you get them on the phone, be in front of your computer. What I've
found sometimes is that the thing I'm looking for *is* on the website,
but it's not necessarily easy to find. The support person might be
able to steer you to the spot where a 4.xx download is available.

Good luck!

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

J.O. Aho wrote:
> JackM wrote:
>
>> 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.
>
> You could dump all the content of the database to a file, clean out the
> machine of MySQL and then install MySQL5 and import the dump, you will
> need to reindex things and functions/procedures.

Thanks. That's probably what I'll end up doing anyway.

> Maybe your web browser is so buggy it can't display HTML code?
> http://dev.mysql.com/downloads/mysql/4.1.html

You're right, I couldn't find that page before. My bad. I was looking
for 4.0. But this page tells me "Note: When upgrading from versions of
MySQL prior to 4.1.5, you must uninstall the existing version before
installing a new version."

So it looks to me that my initial thought which you snipped out of the
above quote is that I have to do a complete new install of 5.0.51 from
scratch was correct.

Thanks.

Pete Mullins wrote:
> JackM wrote:
>
>> 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).

Thanks, Pete. Last night I went ahead and uninstalled 3.23 completely
and put 5.0.51a on the machine. Had a few minor issues that I was able
to google an answer for and now it's working fine. Final thing for me to
tackle soon is upgrading phpMyAdmin 2.5.6 since now that the new MySQL
is running, I'm getting an error notice printed in the right window when
using phpMyAdmin to do anything in the tables:

Notice: Undefined index: Type in
C:\web\phpMyAdmin\tbl_properties_table_info.php on line 21

It still works, but that error message is annoying. So I'll have to try
to upgrade that one, too.