MYSql Update

[rhenderson]

Hi,

I have been reading another thread about updating MySQL from 4.0 to 4.1, which I really to do because of the problems I keep running into with the latin charsets.

Anyway I understand the only thing that needs updating is the MySQL server part since the rest is alread running 4.1.xx.

I got the RPM from MySQL website and when I tried to install it I had a perl-DBI dependency which I took care through yum. Now when I try to install the RPM it errors because it conflicts with the 4.0.xx version which makes sense. At this point I am a little stuck. if I uninstall the 4.0 RPM will this kill all the MySQL data on the server? I don't just want to remove 4.0 for 4.1. I want to update 4.1 leaving the data intact.

Thanks in advance,
Randy Henderson

[Jeremy]

http://xd networks . net/files/mysql/rpms/4.1/

Sorry i don't want Google caching that URL

pull the RPM's (if you like)
wget link1 link2 link3 etc

(make sure its the 32bit not 64bit...)

type rpm -Uvh MySQL*

Let me know how it goes.

[Jeremy]

sorry.

then type

/etc/init.d/mysql restart

[rhenderson]

Thanks for the post... Here is what I get after getting the rpm's
ls -l
total 27248
-rw-r--r-- 1 root root 4212831 Jul 24 2006 MySQL-bench-4.1.21-0.glibc23.i386.rpm
-rw-r--r-- 1 root root 4384873 Jul 24 2006 MySQL-client-4.1.21-0.glibc23.i386.rpm
-rw-r--r-- 1 root root 2842463 Jul 24 2006 MySQL-devel-4.1.21-0.glibc23.i386.rpm
-rw-r--r-- 1 root root 2960505 Jul 24 2006 MySQL-embedded-4.1.21-0.glibc23.i386.rpm
-rw-r--r-- 1 root root 12235121 Jul 24 2006 MySQL-server-4.1.21-0.glibc23.i386.rpm
-rw-r--r-- 1 root root 1212202 Jul 24 2006 MySQL-shared-4.1.21-0.glibc23.i386.rpm

rpm -Uvh MySQL*
error: Failed dependencies:
MySQL-shared-compat >= 4.0.23 is needed by (installed) dsm-system-3.2-11
5.centos4.zvx.i386

[Jeremy]

try installing the shared one first.

like

rpm -Uvh MySQL-shared-4.1.21-0.glibc23.i386.rpm

If it installs.

rm MySQL-shared-4.1.21-0.glibc23.i386.rpm

rpm -Uvh MySQL*

let me know.

[rhenderson]

Looks like it is still the same

#rpm -Uvh MySQL-shared-4.1.21-0.glibc23.i386.rpm
error: Failed dependencies:
MySQL-shared-compat >= 4.0.23 is needed by (installed) dsm-system-3.2-115.centos4.zvx.i386

[defunctiam]

You need to download and install the Shared-Compat rpm.

It is listed under "Shared compatibility libraries".

[rhenderson]

Thanks, that did help. I think I got it now.

[Jeremy]

Thats what i thought too, good catch!

Did you get it running?

[R1Lover]

I can't seem to find the updates for CentOS4

any ideas, I'm looking to upgrade to 4.1.21 from 4.0

[R1Lover]

Originally Posted by Jeremy

http://xd networks . net/files/mysql/rpms/4.1/

Sorry i don't want Google caching that URL

pull the RPM's (if you like)
wget link1 link2 link3 etc

(make sure its the 32bit not 64bit...)

type rpm -Uvh MySQL*

Let me know how it goes.

Thank you so much for your post... you saved the day for me.

[Jeremy]

Good to know that helped.

[R1Lover]

That upgrade seemed to go fine.... but I'm having some trouble with importing a database now.

So I need to re-compile php after the mysql update ?

Thank you

Sorry I'm new to this.

[Jeremy]

What do u mean by import?

You shouldn't export/delete anything.

What PHPv are you running? Theres no reason to compile anything.

[R1Lover]

Originally Posted by Jeremy

What do u mean by import?

You shouldn't export/delete anything.

What PHPv are you running? Theres no reason to compile anything.

I corrected the issue, I guess I should have said restoring a database.

The issue I had was in servercp the only options for user permissions when using the mysql interface are read/write, read, write. There are no options to allow all. Well I had to use phpmyadmin to set the permissions correctly and then it worked great.