LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 05-03-2003, 04:00 PM   #1
SForsgren
Member
 
Registered: Apr 2003
Location: San Jose
Distribution: Red Hat 9
Posts: 68

Rep: Reputation: 15
mySQL Upgrade from 3.23 to 4.0


I am bit confused. I thought that I should go to Package Manager and remove the mySQL 3.23 which I did. However, if I then search for all files mysql*, it looks like there are still dozens of mysql files even after it said it was removed. Why?

Is it safe now to install the new version? Is there anything I will need to do beyond installing the new RPMs to get it working with PHP?

Thanks
 
Old 05-04-2003, 02:42 AM   #2
markus1982
Senior Member
 
Registered: Aug 2002
Location: Stuttgart (Germany)
Distribution: Debian/GNU Linux
Posts: 1,467

Rep: Reputation: 46
Not really, you could install the MySQL 4.0 binaries. Just be sure you have BACKUPED your databases before. If I remember correctly the MySQL user table, etc got modified so be sure that you do NOT overwrite this with your old MySQL 3.23 mysql database or you might run into problems ...
 
Old 05-04-2003, 12:53 PM   #3
SForsgren
Member
 
Registered: Apr 2003
Location: San Jose
Distribution: Red Hat 9
Posts: 68

Original Poster
Rep: Reputation: 15
This is what I was concerned about when I was looking at the 4.0 upgrade. BTW, I have never used mySQL before and thus don't have any databases that I am concerned about at this time in terms of backing up.

"Ensure that you don't have any MySQL clients that uses shared libraries (like the Perl DBD-mysql). If you have, you should recompile them as structures used in `libmysqlclient.so' have changed. The same applies for Python MySQLdb."

When I tried

[root@sforsgren-linux-01 mySQL 4.1]# rpm -e mysql-3.23.56-1.9
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) libdbi-dbd-mysql-0.6.5-5
libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-1.11-12
libmysqlclient.so.10 is needed by (installed) MySQL-python-0.9.1-6
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3

So, this seemed to imply that if I install 4.0, I have to revisit all of these other products that will no longer work due to the change in libmysqlclient.so.10, right?

How do I get upgraded to 4.0 and still ensure that all of these other packages still work?

Thanks!
 
Old 07-02-2003, 12:40 PM   #4
boxers
LQ Newbie
 
Registered: Jul 2003
Posts: 1

Rep: Reputation: 0
I have exactly the same problem - watching for your success with anticipation !
 
Old 07-19-2003, 12:47 AM   #5
baggins2001
LQ Newbie
 
Registered: Jul 2003
Posts: 1

Rep: Reputation: 0
You might try the latest version 4.0.13 installing the
MySQL-compat-4.0.13 rpm. instead of using the share rpm.
The compat rpm is to resolve this issue.
www.mysql.com/doc/en/Linux-RPM.html
 
Old 12-29-2003, 04:42 AM   #6
avirup dasgupta
Member
 
Registered: Aug 2003
Distribution: Redhat , Fedora Core4, DSL,Solaris
Posts: 49

Rep: Reputation: 15
1. /etc/rc.d/init.d/mysqld stop

2. rpm -e perl-DBD-Mysql mysql-3.23 mysql-devel mysql-server qt-Mysql Mysql-python
php-mysql perl-DBI.rpm

( We remove modules with which we have dependency problem in libmysqlclient..so.10 )

3. rpm -ivh Mysql-4.0.17.rpm Mysql-server-4.0.17.rpm Mysql-client.rpm Mysql-devel.rpm


4. /etc/rc.d/init.d/mysql start

5. mysql -v
(shows that version 4.0.17 is installed)

Avirup Dasgupta
 
Old 12-29-2003, 05:11 AM   #7
avirup dasgupta
Member
 
Registered: Aug 2003
Distribution: Redhat , Fedora Core4, DSL,Solaris
Posts: 49

Rep: Reputation: 15
I forgot to mention that u must also install Mysql-shared-compat-4.0.17.i386.rpm at step 3.

#rpm -ivh Mysql-4.0.17.rpm Mysql-server-4.0.17.rpm Mysql-client-4.0.17.rpm Mysql-devel-4.0.17.rpm Mysql-shared-compat-4.0.17.i386.rpm



Avirup Dasgupta
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql 4.0.24 to mysql 4.1.12 upgrade problem tuxrules Slackware 7 08-13-2005 07:43 PM
mysql upgrade no_names_left Linux - Software 1 03-04-2005 10:30 AM
Upgrade to MySQL 4? VxJasonxV Red Hat 1 02-06-2004 04:15 PM
MySQL Upgrade SForsgren Linux - Software 8 05-09-2003 03:11 AM
How do I upgrade MySQL... correro Linux - General 1 04-16-2003 12:43 PM


All times are GMT -5. The time now is 12:43 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration