Linux Help
guides forums blogs
Home Desktops Distributions ISO Images Logos Newbies Reviews Software Support & Resources Linuxhelp Wiki

Welcome Guest ( Log In | Register )



Advanced DNS Management
New ZoneEdit. New Managment.

FREE DNS Is Back

Sign Up Now
 
Reply to this topicStart new topic
> Upgrading Mysql, How can I upgrade mysql without mess
tuthjaa
post Jan 26 2005, 11:15 AM
Post #1


Whats this Lie-nix Thing?
*

Group: Members
Posts: 7
Joined: 19-January 05
Member No.: 4,539



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
Go to the top of the page
 
+Quote Post
chrisw
post Jan 26 2005, 12:41 PM
Post #2


RMS is my Hero
******

Group: Admin
Posts: 634
Joined: 27-September 02
From: Louisiana
Member No.: 5



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.


--------------------

Chris W.
Go to the top of the page
 
+Quote Post
tuthjaa
post Jan 26 2005, 01:18 PM
Post #3


Whats this Lie-nix Thing?
*

Group: Members
Posts: 7
Joined: 19-January 05
Member No.: 4,539



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
Go to the top of the page
 
+Quote Post
Termina
post Jan 27 2005, 08:51 AM
Post #4


RMS is my Hero
******

Group: Support Specialist
Posts: 862
Joined: 18-February 04
From: Wisconsin
Member No.: 2,404



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.


--------------------
*Points finger at the author above him* They're a witch! Burn them!
---
Vist my website!
Join me in IRC! Server: st0rage.org Channel: #UnhandledExceptions
Go to the top of the page
 
+Quote Post
tuthjaa
post Jan 27 2005, 10:00 AM
Post #5


Whats this Lie-nix Thing?
*

Group: Members
Posts: 7
Joined: 19-January 05
Member No.: 4,539



Thanks that just the ticket!
Go to the top of the page
 
+Quote Post
tuthjaa
post Jan 27 2005, 06:25 PM
Post #6


Whats this Lie-nix Thing?
*

Group: Members
Posts: 7
Joined: 19-January 05
Member No.: 4,539



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
Go to the top of the page
 
+Quote Post
Termina
post Jan 27 2005, 06:31 PM
Post #7


RMS is my Hero
******

Group: Support Specialist
Posts: 862
Joined: 18-February 04
From: Wisconsin
Member No.: 2,404



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)


--------------------
*Points finger at the author above him* They're a witch! Burn them!
---
Vist my website!
Join me in IRC! Server: st0rage.org Channel: #UnhandledExceptions
Go to the top of the page
 
+Quote Post
tuthjaa
post Jan 27 2005, 06:46 PM
Post #8


Whats this Lie-nix Thing?
*

Group: Members
Posts: 7
Joined: 19-January 05
Member No.: 4,539



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
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 21st October 2017 - 03:48 AM