Have you upgraded MySQL yet? 4.0 => 4.1

snide · June 20th, 2006, 12:54 PM

If so, what procedure did you use?

From cpanel.net I see this procedure.

Quote:

1. Create a backup of your current databases. I did this by backing up the /var/lib/mysql folder into a tar archive. Its advisable to stop MySQL first, to files in use can be read and databases cannot be changed whilst you upgrade.

Do this using: tar -czf archivename.tar.gz /var/lib/mysql

2. Go to WHM > Tweak Settings and tick MySQL 4.1. Click ok, wait 30sec and click the link as instructed. When thats completed open /etc/my.cnf with pico/nano and insert old-passwords under the mysqld tag. e.g.:

[mysqld]
old-passwords

Then Save, exit and restart MySQL.

3. Recompile apache either with Apache Update in WHM or Easyapache, both do practically the same thing.

4. Reinstall/update perl:

wget http://layer2.cpanel.net/perl587installer.tar.gz
tar zxf perl587installer.tar.gz
cd perl587installer
./install

Once Perl completes, also run /scripts/fixquotas to ensure that everything is set properly, and thats it!

**David** · June 21st, 2006, 3:38 PM

I just upgraded with upcp first, then upgraded with the actual Apache Update. I had no problems, but I know others have had trouble.

snide · June 21st, 2006, 3:46 PM

Quote:

Originally Posted by David

... but I know others have had trouble.

That's what I'm trying to avoid. I've been reading from the cpanel.net website and it looks like most people just went for it and then restored from backups if problems occurred.

**David** · June 21st, 2006, 3:47 PM

I would suggest doing that. Backup all of the databases so if you have a problem, you'll be able to go back.

H · June 21st, 2006, 4:33 PM

Regardless of platform, upgrading from 4.0 to 4.1 is very well known to cause problems. Heck, you should be backing up your database before you do any patching or modifications to the database engine. Quite simply put, I lost a couple weeks worth of data in January because I forgot to back-up a wiki database. Loses were minimal... a documentation wiki on a barely started project, but yeah, I can imagine if you're asking about this, you're running the risk of major losses if something goes wrong and you don't have a back-up.

snide · June 22nd, 2006, 10:04 AM

I spend probably too much time with backups. I have two different scripts running backups. One emails the files to me and the other FTP's them to a different server.

Backups are like insurance ... You never need it 'til you need it.

My main question is really whether the upgrade to 4.1.x from 4.0.27 is worth the trouble at this time? I suppose all I need to do is organize myself and walk through the process, but if it isn't needed (recommended), why should I do it?

**Bigjohn** · June 22nd, 2006, 10:51 AM

reseller servers are (at least mine are...) running 4.1.19 standard.

Not sure if/what the benefits are, however. Just saying.

H · June 22nd, 2006, 11:04 AM

One benefit, if you're running PHP5, is the use of MySQLi functions. They're pretty awesome if you're into OOP.

snide · June 22nd, 2006, 12:04 PM

Yes. That was the main reason I noticed it. I moved a customer from a reseller server to my dedicated and the version of the DB dump had to be made 4.0 compatible.

It took me longer than usual to transfer the account and site because of the version difference.

I'm into OOP. It seems everytime I make a serious change to my accounts, I say "Ooops".

June 21st, 2006, 3:38 PM	#2 (permalink)
David says GIMME SOME MORE! Resident. Joined in Mar 2004 Lives in fear of Obama. Hosted on Pass 7 13,092 posts Gave thanks: 8 Thanked 34 times	I just upgraded with upcp first, then upgraded with the actual Apache Update. I had no problems, but I know others have had trouble. __________________

June 21st, 2006, 3:47 PM	#4 (permalink)
David says GIMME SOME MORE! Resident. Joined in Mar 2004 Lives in fear of Obama. Hosted on Pass 7 13,092 posts Gave thanks: 8 Thanked 34 times	I would suggest doing that. Backup all of the databases so if you have a problem, you'll be able to go back. __________________

June 22nd, 2006, 10:04 AM	#6 (permalink)
snide Registered User Super #1 Joined in Jul 2003 Lives in So. NJ 1,557 posts Gave thanks: 0 Thanked 9 times	I spend probably too much time with backups. I have two different scripts running backups. One emails the files to me and the other FTP's them to a different server. Backups are like insurance ... You never need it 'til you need it. My main question is really whether the upgrade to 4.1.x from 4.0.27 is worth the trouble at this time? I suppose all I need to do is organize myself and walk through the process, but if it isn't needed (recommended), why should I do it? __________________ Dime13 \| Pass17

June 22nd, 2006, 10:51 AM	#7 (permalink)
Bigjohn minor deity Super #1 Joined in Apr 2004 Lives in Georgia Hosted on XEON 7,387 posts Gave thanks: 28 Thanked 94 times	reseller servers are (at least mine are...) running 4.1.19 standard. Not sure if/what the benefits are, however. Just saying. __________________ Proud to be a Surmunity Mod! XEON PASS60 PASS61 Make a fundamental difference! My Sites: Curious about Brewing Beer? Join the community! >>>>> Some Change is GOOD! Keep your paycheck! Support the Fair Tax Get into an Art museum Victorian London It's your brain -*ON WEB* - mybrainhost.com (under development) What SHOULD Government do? Much Less than it Does!

June 22nd, 2006, 12:04 PM	#9 (permalink)
snide Registered User Super #1 Joined in Jul 2003 Lives in So. NJ 1,557 posts Gave thanks: 0 Thanked 9 times	Yes. That was the main reason I noticed it. I moved a customer from a reseller server to my dedicated and the version of the DB dump had to be made 4.0 compatible. It took me longer than usual to transfer the account and site because of the version difference. I'm into OOP. It seems everytime I make a serious change to my accounts, I say "Ooops". __________________ Dime13 \| Pass17

June 21st, 2006, 4:33 PM	#5 (permalink)
H after g, before i Resident. Joined in Jul 2004 Lives in N,BC,CA 8,079 posts Gave thanks: 48 Thanked 131 times	Regardless of platform, upgrading from 4.0 to 4.1 is very well known to cause problems. Heck, you should be backing up your database before you do any patching or modifications to the database engine. Quite simply put, I lost a couple weeks worth of data in January because I forgot to back-up a wiki database. Loses were minimal... a documentation wiki on a barely started project, but yeah, I can imagine if you're asking about this, you're running the risk of major losses if something goes wrong and you don't have a back-up.

June 22nd, 2006, 11:04 AM	#8 (permalink)
H after g, before i Resident. Joined in Jul 2004 Lives in N,BC,CA 8,079 posts Gave thanks: 48 Thanked 131 times	One benefit, if you're running PHP5, is the use of MySQLi functions. They're pretty awesome if you're into OOP.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search