LinuxQuestions.org
Visit Jeremy's Blog.
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 07-31-2005, 01:47 PM   #1
Raggit
Member
 
Registered: Oct 2003
Location: N.C USA
Distribution: Fedora Core 4
Posts: 65

Rep: Reputation: 15
Question Upgrade MySQL 3.23 to 4.1


How do I upgrade the standard version of mysql on FC3, 3.23, to 4.1 ?
I already looked up some info on the internet, but it isn't quite clear to
me.

Thanks in advance
 
Old 07-31-2005, 01:55 PM   #2
punt
Member
 
Registered: Jun 2001
Distribution: Fedora 22
Posts: 371

Rep: Reputation: 30
using rpm, it's quite easy. i didn't run into any problems.

get the latest RPM and just run rpm -Uvh mysql-4.1etc.etcetc.rpm

then

/sbin/service mysqld restart

should work!
 
Old 07-31-2005, 02:01 PM   #3
punt
Member
 
Registered: Jun 2001
Distribution: Fedora 22
Posts: 371

Rep: Reputation: 30
by the way, you can probably also do this with yum

# yum upgrade mysql

should also work.

if not, try the aforementioned rpm method. or, you can compile from source.
 
Old 07-31-2005, 05:04 PM   #4
Raggit
Member
 
Registered: Oct 2003
Location: N.C USA
Distribution: Fedora Core 4
Posts: 65

Original Poster
Rep: Reputation: 15
I trid the rpm -Uvh and I got

Code:
rpm -Uvh MySQL-server-4.1.13-0.i386.rpm
warning: MySQL-server-4.1.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
        libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.9003-5.i386
        libmysqlclient.so.10 is needed by (installed) dovecot-0.99.11-1.FC3.4.i386
        libmysqlclient.so.10 is needed by (installed) libdbi-dbd-mysql-0.6.5-9.i386
        libmysqlclient.so.10 is needed by (installed) MyODBC-2.50.39-19.i386
        libmysqlclient_r.so.10 is needed by (installed) MySQL-python-0.9.2-4.i386
Have i forgotten to get something?
 
Old 07-31-2005, 09:24 PM   #5
punt
Member
 
Registered: Jun 2001
Distribution: Fedora 22
Posts: 371

Rep: Reputation: 30
if that's the case, you're going to need to upgrade to resolve a number of other failed dependencies...

go to www.rpmfind.net and find the required rpms... for example, search on rpmfind.net for libmysqlclient.so.10 and upgrade mysqlclientd as well, etc.

it may be more trouble than it's worth, so maybe this is a path you shouldn't take unless you're absolutely sure you can do so without having problems. however, i've never had any problems when i resolved all failed dependencies.
 
Old 08-01-2005, 11:24 AM   #6
Raggit
Member
 
Registered: Oct 2003
Location: N.C USA
Distribution: Fedora Core 4
Posts: 65

Original Poster
Rep: Reputation: 15
So I tried to install MySQL-client-4.1.13-0.i386.rpm

Code:
 rpm -Uvh MySQL-client-4.1.13-0.i386.rpm
warning: MySQL-client-4.1.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
        file /usr/bin/mysql from install of MySQL-client-4.1.13-0 conflicts with file from package mysql-3.23.58-16.FC3.1
        file /usr/bin/mysql_find_rows from install of MySQL-client-4.1.13-0 conflicts with file from package mysql-3.23.58-16.FC3.1
        file /usr/bin/mysqlaccess from install of MySQL-client-4.1.13-0 conflicts with file from package mysql-3.23.58-16.FC3.1
        file /usr/bin/mysqlbinlog from install of MySQL-client-4.1.13-0 conflicts with file from package mysql-3.23.58-16.FC3.1
        file /usr/bin/mysqlcheck from install of MySQL-client-4.1.13-0 conflicts with file from package mysql-3.23.58-16.FC3.1
        file /usr/bin/mysqldump from install of MySQL-client-4.1.13-0 conflicts with file from package mysql-3.23.58-16.FC3.1
        file /usr/bin/mysqldumpslow from install of MySQL-client-4.1.13-0 conflicts with file from package mysql-3.23.58-16.FC3.1
        file /usr/bin/mysqlimport from install of MySQL-client-4.1.13-0 conflicts with file from package mysql-3.23.58-16.FC3.1
        file /usr/bin/mysqlshow from install of MySQL-client-4.1.13-0 conflicts with file from package mysql-3.23.58-16.FC3.1
        file /usr/share/man/man1/mysql.1.gz from install of MySQL-client-4.1.13-0 conflicts with file from package mysql-3.23.58-16.FC3.1
        file /usr/share/man/man1/mysqlaccess.1.gz from install of MySQL-client-4.1.13-0 conflicts with file from package mysql-3.23.58-16.FC3.1
        file /usr/share/man/man1/mysqladmin.1.gz from install of MySQL-client-4.1.13-0 conflicts with file from package mysql-3.23.58-16.FC3.1
        file /usr/share/man/man1/mysqldump.1.gz from install of MySQL-client-4.1.13-0 conflicts with file from package mysql-3.23.58-16.FC3.1
        file /usr/share/man/man1/mysqlshow.1.gz from install of MySQL-client-4.1.13-0 conflicts with file from package mysql-3.23.58-16.FC3.1
Also not quite sure what this guy meant by the following statement

Quote:
it may be more trouble than it's worth, so maybe this is a path you shouldn't take unless you're absolutely sure you can do so without having problems.
I just want to upgrade the mysql 3.23 to 4.1 so that I can test sugarcrm....Is it not possible to upgrade to 4.1? I'm sure others have been rather succesful, what seems to be the problem with my upgrade? Is it the hardware, is it the software, why do I need to get those other files, shouldn't the install have them in it? Man im confused...
 
Old 08-01-2005, 01:14 PM   #7
punt
Member
 
Registered: Jun 2001
Distribution: Fedora 22
Posts: 371

Rep: Reputation: 30
well, then you'll have to uninstall mysql

rpm -e mysql-3.23.58-16.FC3.1

keep in mind that once you do this (until mysql4 is installed), you're not going to have any working mysql server!

it's very possible to upgrade to mysql4, but you're going to have to make sure you resolve all the dependencies.
 
Old 08-01-2005, 01:41 PM   #8
Raggit
Member
 
Registered: Oct 2003
Location: N.C USA
Distribution: Fedora Core 4
Posts: 65

Original Poster
Rep: Reputation: 15
Ok I'm a little farther than I was last time you guys saw me..
Please take a read of the code below and tell me why mysql fails to start??
How might I fix that problem??

Code:
rpm -ivh MySQL-server-4.1.13-0.i386.rpm
warning: MySQL-server-4.1.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
   1:MySQL-server           ########################################### [100%]
chown: `mysql:mysql': invalid user
chown: `mysql': invalid user
050801 13:38:04 [Warning] Asked for 196608 thread stack, but got 126976
050801 13:38:04 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

050801 13:38:04 [ERROR] Aborting

050801 13:38:04 [Note] /usr/sbin/mysqld: Shutdown complete

Installation of system tables failed!

Examine the logs in /var/lib/mysql for more information.
You can also try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
You can use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
chown: `mysql:mysql': invalid user
Starting MySQL...................................[FAILED]
[root@localhost mark]# rpm -ivh MySQL-client-4.1.13-0.i386.rpm
warning: MySQL-client-4.1.13-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
   1:MySQL-client           ########################################### [100%]
[root@localhost mark]# service mysql start
Starting MySQL...................................          [FAILED]
Thanks in advance guys...Back to work for me i'll chech replies later this eveing...
 
  


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
How to Upgrade MySQL cli_man Linux - Software 1 10-23-2003 07:04 AM
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

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 06:42 AM.

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