#1  
Old 10th September 2007, 00:43
dunnma dunnma is offline
Junior Member
 
Join Date: Sep 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default "Upgrading" MySQL

I just recently setup a VPS III server with 1and1.com. Below are the server particulars:

OS: fedora-core-4-x86_64
Packages:
devel-fc4-x86_64 / 20060804
fc4-x86_64-custom-config / 20061205
fc4-x86_64-psa8-key / 20061205
fc4-x86_64-psa8-language / 20061205
mod_perl-fc4-x86_64 / 20060411
mod_ssl-fc4-x86_64 / 20060804
mysql-fc4-x86_64 / 20060804
php-fc4-x86_64 / 20060220
psa-bu-fc4-x86_64 / 20060614
psa-fc4-x86_64 / 20060614
psa-vault-fc4-x86_64 / 20060611

I have everything up and running and I just noticed that the version of MySQL is 4.1.20. I want to upgrade to 5.0.45 (latest stable). The problem is I have no clue how to begin. I have spent hours and hours looking and trying things, but nothing is working. There is no data that I need to keep, basically start from scratch.

The current "installation" is located in the /var/lib/mysql directory.

Does anyone have "simple" instructions on how to upgrade, or install the latest version of MySQL? I know enough to be dangerous.

Thanks in advance!
Reply With Quote
Sponsored Links
  #2  
Old 10th September 2007, 21:18
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

I found an rpm for FC 4 here: http://rpm.pbone.net/index.php3/stat....i386.rpm.html
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 11th September 2007, 22:43
dunnma dunnma is offline
Junior Member
 
Join Date: Sep 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Boy was I excited when I saw the response.

I removed the old installation and installed the 2 rpm files.

rpm -ivh ftp://ftp.pbone.net/mirror/remi.coll....remi.i386.rpm
rpm -ivh ftp://ftp.pbone.net/mirror/remi.coll....remi.i386.rpm

Now when I go to log in I am getting the following error.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Any ideas?
Reply With Quote
  #4  
Old 12th September 2007, 21:45
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

Any errors in your logs? Any errors when you restart MySQL? What's the output of
Code:
ps aux | grep -i mysql
and
Code:
netstat -tap
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 12th September 2007, 21:50
dunnma dunnma is offline
Junior Member
 
Join Date: Sep 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Actually I figured out my problem late last night. It is a 64 bit server. Here is the complete upgrade script that worked for me.

# Install yum
rpm -ivh http://update.onlinehome-server.com/...6-4.x86_64.rpm http://update.onlinehome-server.com/...6-1.x86_64.rpm http://update.onlinehome-server.com/...6-1.noarch.rpm http://update.onlinehome-server.com/...2-7.noarch.rpm

# Remove old MySQL
yum remove mysql

# CD to tmp
cd /tmp/

# Get new MySQL files
wget http://dev.mysql.com/get/Downloads/M.../mysql.he.net/
wget http://dev.mysql.com/get/Downloads/M.../mysql.he.net/
wget http://dev.mysql.com/get/Downloads/M.../mysql.he.net/
wget http://dev.mysql.com/get/Downloads/M.../mysql.he.net/
wget http://dev.mysql.com/get/Downloads/M.../mysql.he.net/

# Install new MySQL files
rpm -U MySQL-server-5.0.45-0.glibc23.x86_64.rpm MySQL-client-5.0.45-0.glibc23.x86_64.rpm MySQL-devel-5.0.45-0.glibc23.x86_64.rpm MySQL-shared-5.0.45-0.glibc23.x86_64.rpm MySQL-shared-compat-5.0.45-0.glibc23.x86_64.rpm

Thanks for the help! Hopefully this can help someone else.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 18:03
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 13:17
MySQL Cluster On FC5 : error while unpacking from engine asyadiqin HOWTO-Related Questions 7 28th October 2006 18:37
I'm dying! m u r Installation/Configuration 41 17th September 2006 14:44
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04


All times are GMT +2. The time now is 08:03.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.