Hello All, I am trying to upgrade MySQL on CentOS 4.5 but having a hard time. I need to go from MySQL 4.1 to 5. I downloaded the following two files: mysql-server-5.0.58-1.el4.centos.i386.rpm mysql-5.0.48-2.el4.centos.i386.rpm I tried to do: yum install mysql-server-5.0.58-1.el4.centos.i386.rpm And get: Setting up Install Process Setting up repositories Reading repository metadata in from local files Parsing package install arguments Examining mysql-server-5.0.58-1.el4.centos.i386.rpm: mysql-server - 5.0.58-1.el4.centos.i386 Marking mysql-server-5.0.58-1.el4.centos.i386.rpm as an update to mysql-server - 4.1.20-3.RHEL4.1.el4_6.1.i386 Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Package mysql-server.i386 0:5.0.58-1.el4.centos set to be updated --> Running transaction check --> Processing Dependency: libmysqlclient.so.15 for package: mysql-server --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: mysql-server --> Processing Dependency: libmysqlclient_r.so.15 for package: mysql-server --> Processing Dependency: libmysqlclient_r.so.15(libmysqlclient_15) for package: mysql-server --> Processing Dependency: mysql = 5.0.58-1.el4.centos for package: mysql-server --> Finished Dependency Resolution Error: Missing Dependency: libmysqlclient.so.15 is needed by package mysql-server Error: Missing Dependency: libmysqlclient.so.15(libmysqlclient_15) is needed by package mysql-server Error: Missing Dependency: libmysqlclient_r.so.15 is needed by package mysql-server Error: Missing Dependency: libmysqlclient_r.so.15(libmysqlclient_15) is needed by package mysql-server Error: Missing Dependency: mysql = 5.0.58-1.el4.centos is needed by package mysql-server I then did yum update mysql and it update the current MySQL files but on the same version and not to 5. How do I get libmysqlclient.so.15 installed if I have libmysqlclient.so.10 installed because it looks like that is what it needs to be able to complete or at least go through my upgrade. Thanks, T -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos/attachments/20080415/b1ffb42c/attachment-0001.html>
Tito Valentin wrote:> I am trying to upgrade MySQL on CentOS 4.5 but having a hard time. I > need to go from MySQL 4.1 to 5. I downloaded the following two files: > > mysql-server-5.0.58-1.el4.centos.i386.rpm > mysql-5.0.48-2.el4.centos.i386.rpm > > I tried to do: > > yum install mysql-server-5.0.58-1.el4.centos.i386.rpmThe command to use here would be rpm -Uvh, as these packages are not in the yum system. You would need to uninstall the current mysql first, however - and to migrate any data, you need to use mysqldump --all --opt before that, and then import it back after 5.x is installed. Last time I checked, you could not use the same database files for different major versions of MySQL - I could be wrong on this point, however. -- Cheers, Morten
Tito Valentin wrote:> Hello All, > > I am trying to upgrade MySQL on CentOS 4.5 but having a hard time. I > need to go from MySQL 4.1 to 5. I downloaded the following two files: > > mysql-server-5.0.58-1.el4.centos.i386.rpm > mysql-5.0.48-2.el4.centos.i386.rpmYou do notice, those are two different versions? one is 5.0.58-1 and the other 5.0.48-2, you can't mix these. and, as others have said, you need more RPMs than just that.
On Tue, Apr 15, 2008 at 3:19 PM, Tito Valentin <daemonracing at gmail.com> wrote:> > I am trying to upgrade MySQL on CentOS 4.5 but having a hard time. I need > to go from MySQL 4.1 to 5.Having gone through this process about 7 months ago: It's not recommended to do a "binary upgrade", that is, to simply install the newer mysql server and attempt to continue using the same database files. Depending on which storage engines you're using, it can fail rather spectacularly. Instead you should: - stop all clients accessing the mysql 4 server - flush tables and run a full mysqldump - shut down the mysql 4 server - make a backup of /var/lib/mysql - completely remove /var/lib/mysql - remove mysql 4 and install 5 (you can do this in one operation with "rpm -Uvh ...") - start up the mysql 5 server and configure root password etc. - reload the dump from the first step - follow the instructions in the online mysql documentation to update grants etc. Also pay careful attention to the changes in timestamp column behavior, default characters sets and collations, etc. There's extensive documentation on the mysql website, but it's not really all in one place and may take some digging.