Results 1 to 10 of 10
Thread: how do i upgrade MYSQL?
-
05-14-2005, 11:33 PM #1Newbie
- Join Date
- Mar 2005
- Posts
- 14
how do i upgrade MYSQL?
hi,
How do i upgrade MYSQL to 4.1.X?
what is the easiest wat to do it?
i have RH 9 operating system and WHM
-
05-14-2005, 11:59 PM #2Retired Moderator
- Join Date
- Sep 2004
- Location
- Flint, Michigan
- Posts
- 5,766
I don't believe it's officially supprted under Cpanel, but here's a good start for you: http://forums.cpanel.net/showthread....=mysql+upgrade
█ Mike from Zoodia.com
█ Professional web design and development services.
█ In need of a fresh hosting design? See what premade designs we have in stock!
█ Web design tips, tricks, and more at MichaelPruitt.com
-
05-15-2005, 08:54 AM #3Web Hosting Evangelist
- Join Date
- Dec 2004
- Location
- Fort Lauderdale, Florida
- Posts
- 481
You can even run "yum update mysql" if you have RH9 and yum installed.
█ Voxxit - Accessible Web Design & Secure, Affordable Web Hosting
█ Now offering 501(c)3 non-profit discounts!
█ Ruby on Rails included with every hosting account! - Save up to 80% bandwidth on all plans with mod_deflate!
█ Visit our services page to see how Voxxit can help you today!
-
05-15-2005, 10:26 AM #4Junior Guru
- Join Date
- Feb 2005
- Location
- I am air u breathe
- Posts
- 230
It is quick to install it via YUM but make sure you do not have much of customizations and additional compilation options enabled.
I will be with getting a manual install that will help you much more than the automated process
Al
It is reliability that counts...
-
05-15-2005, 09:31 PM #5Disabled
- Join Date
- Jan 2005
- Location
- USA
- Posts
- 1,379
Sure it is supported.
Go under twique settings, down to where it lists the MySQL versions. You will have the choice between 4.0 and 4.1. Choose 4.1 and click save. It'll then give you a link to to a script you also need to run.
I am running MySQL4.1.11 successfully with CPanel/WHM. You have to be under the release tree though, not stable.
Edit: Now that I think of it, I think there is a new stable version which supports it.
-
05-16-2005, 01:08 AM #6Newbie
- Join Date
- May 2005
- Location
- Kansas City
- Posts
- 9
I would reccomend you run a 'mysql-dump --opt -A > mysql-backup.sql' before you do any upgrade.
It's always best to have a good backup before you attempt ANY type of upgrade.
Unless you don't care about your MySQL data...
But after you get a good backup, go grab the RPM's, do a 'rpm -Uvh <rpm file name>' then a 'mysql_fix_<script name>' to fix various upgrade diff's between versions.
-
05-16-2005, 08:57 AM #7Newbie
- Join Date
- Mar 2005
- Posts
- 14
Originally posted by ZapX Technologies
Sure it is supported.
Go under twique settings, down to where it lists the MySQL versions. You will have the choice between 4.0 and 4.1. Choose 4.1 and click save. It'll then give you a link to to a script you also need to run.
I am running MySQL4.1.11 successfully with CPanel/WHM. You have to be under the release tree though, not stable.
Edit: Now that I think of it, I think there is a new stable version which supports it.
-
05-16-2005, 09:01 AM #8Newbie
- Join Date
- Mar 2005
- Posts
- 14
Originally posted by VoxxitDesigns
You can even run "yum update mysql" if you have RH9 and yum installed.
also does this effect on WHM , i mean do the mysql settings in whm will work probabliy?
-
05-16-2005, 09:25 AM #9Retired Moderator
- Join Date
- Sep 2004
- Location
- Flint, Michigan
- Posts
- 5,766
Well looking over your error file this line brings interest
Resolving diff.cpanel.net... failed: Host not found█ Mike from Zoodia.com
█ Professional web design and development services.
█ In need of a fresh hosting design? See what premade designs we have in stock!
█ Web design tips, tricks, and more at MichaelPruitt.com
-
05-16-2005, 01:50 PM #10Newbie
- Join Date
- Mar 2005
- Posts
- 14
Solved!
the problem was in file resolv.conf,it did not configured correctly.
thanx to all of guys