Help - Search - Members - Calendar
Full Version: Upgrading Mysql
Linuxhelp > Support > Technical Support
tuthjaa
Hi,

I have FC2 and mysql 3.23.58 and want to upgrade it to 4.1.X. I have backed up my data so - should I uninstall mysql 3.23.58 first and then install 4.1.x or is an upgrade option using rpms?

Thanks,

James
chrisw
if you are using the rpm versions of mysql, just make sure you have a backup of your
data and the just issue the following command rpm -Uvh mysql-<new-version>.rpm

of course replacing <new-version> with the numbers in the rpm you are upgrading to.
tuthjaa
Hi,

Okay I have checked what mysql files are installed using rpm -qa | grep "mysql" and got the following:

mysql-3.23.58-9.1
mysql-server-3.23.58-9.1
php-mysql-4.3.10-2.4

The server isn't in the same room as me and I don't know how to download files using command line. The files are available from http://dev.mysql.com/downloads/mysql/4.0.html but how can I transfer the appropriate files to my home folder? I can't even work out where the file actually are...

Thanks inadvance,

James

p.s. Sorry if this quite newbie - but I am still on a vertical learning curve. smile.gif
Termina
Find the actual link (not the page where you choose the mirror), and try:

wget http://url.com/path/to/binary.tar.gz (or rpm)

If you don't have wget, then you can use 'ftp domain.com', and cd /to/path, and 'get filename.rpm'

If, for some reason, you don't have wget OR ftp, you can use lynx (text browser), which can download things.
tuthjaa
Thanks that just the ticket!
tuthjaa
Hi,

I have sucessfully downloaded the file to my home directory. However, i am having problems with the installations.

I have download the following files:
MySql-client-4.0.23-x.xx.rpm
MySql-devel-4.x.x.x.x.rpm
MySql-server-4.0.23.0.x.x.rpm

However, when trying the command.

rpm -Uvh MySQL-server-4.0.23-0.i386.rpm

I got the this error:

error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.9003-4
libmysqlclient.so.10 is needed by (installed) php-mysql-4.3.10-2.4

Sorry to ask a dump question - but should i download and install these files or what?
Thanks,

james
Termina
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.9003-4
libmysqlclient.so.10 is needed by (installed) php-mysql-4.3.10-2.4

It says that they are installed. o_O

Have you tried installing these RPMs in a diffrent order? That *might* help.

Also, IIRC, you might want to try rpm -ivh filename.rpm

Might be wrong though, I don't use RPM based distros. (Mostly because this is what happens xD)
tuthjaa
Hi Termina,

thanks for helping me!

I tried the other commands... and all fell over. Should I remove the old version of mysql first? Or will the rpm remove the old version of the software? Infact what happens to old software in general?

# rpm -Uvh MySQL-devel-4.0.23-0.i386.rpm
Preparing... ########################################### [100%]
file /usr/bin/comp_err from install of MySQL-devel-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysql_config from install of MySQL-devel-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1

# rpm -Uvh MySQL-client-4.0.23-0.i386.rpm
Preparing... ########################################### [100%]
file /usr/bin/mysql from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysqlaccess from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysqlbinlog from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysqlcheck from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysqldump from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysqlimport from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysqlshow from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/share/man/man1/mysql.1.gz from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/share/man/man1/mysqlaccess.1.gz from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/share/man/man1/mysqladmin.1.gz from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/share/man/man1/mysqldump.1.gz from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/share/man/man1/mysqlshow.1.gz from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-3.23.58-9.1
file /usr/bin/mysqladmin from install of MySQL-client-4.0.23-0 conflicts with file from package mysql-server-3.23.58-9.1
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2017 Invision Power Services, Inc.