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]

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]

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.

[R1Lover]

Also, users will need to run mysql_fix_privilege_tables after the upgrade from 4.0 to 4.1.21

Here is the correct syntax

mysql_fix_privilege_tables --password=root_password

[Jeremy]

I think the problem you faced was the all part but im not sure why really.

But hey you got it working :D

good stuff in my book.

[proweb]

rpm -Uvh MySQL*
Preparing... ########################################### [100%]
package MySQL-shared-compat-4.1.21-1 is already installed
file /usr/bin/mysqldumpslow from install of MySQL-server-4.1.21-0.glibc23 conflicts with file from package MySQL-client-4.1.10-0
file /usr/lib/libmysqlclient.so.14.0.0 conflicts between attempted installs of MySQL-shared-4.1.22-0.glibc23 and MySQL-shared-compat-4.1.21-1
file /usr/lib/libmysqlclient_r.so.14.0.0 conflicts between attempted installs of MySQL-shared-4.1.22-0.glibc23 and MySQL-shared-compat-4.1.21-1

can someone help with this, trying to upgrade to 4.1 being all my DB backups wont import due to compatability issues on what was there
now SQL wont start

[proweb]

--------------------------------------------------------------------------------

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

It is listed under "Shared compatibility libraries".

Where do you find this, I can tfind a download anywhere and Im stuck at same place

[proweb]

[root@cpe-24-29-216-242 ~]# rpm -Uvh MySQL*
Preparing... ########################################### [100%]
package MySQL-shared-compat-4.1.21-1 (which is newer than MySQL-shared-compat-4.1.10-0) is already installed
file /usr/bin/mysqldumpslow from install of MySQL-server-4.1.21-0.glibc23 conflicts with file from package MySQL-client-4.1.10-0
file /usr/lib/libmysqlclient.so.14.0.0 conflicts between attempted installs of MySQL-shared-4.1.22-0.glibc23 and MySQL-shared-compat-4.1.10-0
file /usr/lib/libmysqlclient_r.so.14.0.0 conflicts between attempted installs of MySQL-shared-4.1.22-0.glibc23 and MySQL-shared-compat-4.1.10-0

This is what I get, cant get anything to work now

[Jeremy]

try installing the shared RPM first. if it installs remove/rename it.

then the rpm -Uvh

[proweb]

It did install, the wrong one, lol now wont install the one it needs
how do I remove the other package?

[Jeremy]

See what is installed.

rpm -qa|grep MySQL

rpm -e --nodeps package


removing the package will dump your database and prolly mess up DSM....

GL!

[erothoff]

Hi,
I followed the directions also, and I am still getting the same error. I have installed, MySQL-shared-compat-4.1.21-1.glibc23.i386.rpm but I still get this error message when I try:
yum localinstall MySQL*

Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package MySQL-shared.i386 0:4.1.21-0.glibc23 set to be updated
---> Package MySQL-client.i386 0:4.1.21-0.glibc23 set to be updated
---> Package MySQL-devel.i386 0:4.1.21-0.glibc23 set to be updated
---> Package MySQL-server.i386 0:4.1.21-0.glibc23 set to be updated
---> Package MySQL-embedded.i386 0:4.1.21-0.glibc23 set to be updated
---> Package MySQL-bench.i386 0:4.1.21-0.glibc23 set to be updated
--> Running transaction check
--> Processing Dependency: MySQL-shared-compat >= 4.0.23 for package: dsm-system
--> Finished Dependency Resolution
Error: Missing Dependency: MySQL-shared-compat >= 4.0.23 is needed by package dsm-system

I try just the MySQL-shared
yum localinstall MySQL-shared-4.1.21-0.glibc23.i386.rpm
and I got the error message:

Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package MySQL-shared.i386 0:4.1.21-0.glibc23 set to be updated
--> Running transaction check
--> Processing Dependency: MySQL-shared-compat >= 4.0.23 for package: dsm-system
--> Finished Dependency Resolution
Error: Missing Dependency: MySQL-shared-compat >= 4.0.23 is needed by package dsm-system

Any suggestions? Why is dsm not letting up update MySQL? Is it the language issue with the tables? (The whole reason I need to upgrade to at least 4.1) And is there any idea when DSM will allow us to use Apache 2.0 and MySQL 5?

Thanks in advance

[Jeremy]

/etc/init.d/mysql stop
rpm --nodeps -Uvh MySQL-*.rpm
/etc/init.d/mysql start

If the shared rpm installed remove it from the dir.

Why do you need mysql5? Ive used mysql5 im personally not impressed.

[erothoff]

Hi,
I got my MySQL updted to 4.1 and I wanted to share a few things that I picked up along the way. I am not sure if it is because I updated yum like on the Unofficial Fedora FAQ site, www _ fedorafaq _ org/fc5/ but after I installed the new MySQL-shared-compat-4.1.22-0.i386.rpm using "yum upgrade localsource MySQL-shared-compat-4.1.22-0.i386.rpm" all I needed to do was a "yum upgrade MySQL*" and it found everything else.
Also, watch which version of MySQL-shared-compat-4.1.22-0 you download, as there are three versions for i386 alone. I originally installed a .glibc23.i386.rpm but I had just the .i386 installed. (You can do a "yum search MySQL-shared-compat" to find out what is installed.)
Finally, the code:
mysql_fix_privilege_tables --password=root_password
does not seem to be needed when upgrading from upgrading from 4.0 to 4.1. It states when you run it:

This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1

Maybe I am wrong, (And please correct me if I am. I DID run the script, BTW, just in case.) but it looks like it is for upgrading for <4 to mysql 4.

That is all I learned. Hopefully that will help anyone else that has this problem, and thankyou for everyone that help me on this quest. Once final note, I have no idea on the preformance issues of MySQL 4.1 compared to MySQL 5. I would have liked to upgrade to MySQL 5 simply because I will probably not work on this server for another 3-4 years if possible, and having the current version would mean that I would have more of a chance of not having to change the server again.

Thanks again.

[Jeremy]

Yea fedora... I don't use it so i don't keep up with the packages they have.

The glibc is compiled a little different then the plain old i386, with C!

I normally dump a backup, remove all MySQL rpm's and go from source, rpm's are easy to work.