MySQL Update

[eoinymc]

Hi,

I'm using mysql 4.0.12 , but I saw that there is a bug on it when you try to:

select blob from table where field like '%query%';

I have a lot of tables and information in my database and was wondering if there was any way I can update to the latest version of mysql without having to drop those tables, etc...?

I hope this question is clear.

Thanks,

Eoin

[Xnuiem]

You should be able to. Always back up beforehand, but I have had no problems.

[eoinymc]

Thanks for the reply...

but just a quick question....

do I just install the new version over the old version?

or do I have to remove the old one first?

or is there an update version of mysql?

Thanks again for your help...

Eoin

[Xnuiem]

I typically use RPM's to do it, and it upgrades just fine.

If you are compiling from source and not using RPMS or simliar, I am not really sure but google for it.

[eoinymc]

thanks for the reply...

but, pardon my ignorance..

what is RPM and are you using that in windows or are you using linux?

sorry and thanks,

Eoin

Originally posted by eoinymc@Aug 10 2004, 01:38 PM
Hi,

I'm using mysql 4.0.12 , but I saw that there is a bug on it when you try to:

select blob from table where field like '%query%';

I have a lot of tables and information in my database and was wondering if there was any way I can update to the latest version of mysql without having to drop those tables, etc...?

I hope this question is clear.

Thanks,

Eoin

hh

[Xnuiem]

RPM's are on Mandrake and Red Hat based Linux systems. I have never used Win32 OS for a server.

In regards to the other question, use TEXT as your field type, not BLOB