Upgrade MySQL 3.23 to 4.1

Raggit · 07-31-2005, 12:47 PM

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

punt · 07-31-2005, 12:55 PM

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!

punt · 07-31-2005, 01:01 PM

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.

Raggit · 07-31-2005, 04:04 PM

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?

punt · 07-31-2005, 08:24 PM

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.

Raggit · 08-01-2005, 10:24 AM

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...

punt · 08-01-2005, 12:14 PM

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.

Raggit · 08-01-2005, 12:41 PM

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...