How safe is it to upgrade MySQL to 4.1+ from 4.0.25?

electron33

Well-Known Member
Feb 24, 2004
90
0
166
I've read other threads about upgradeing MySQL 4.0.25 to 4.1+, but they are not very informative.

I'm running 4.0.25 on CentOS 4 (WHM 10.8.0 cPanel 10.8.1-R113 , and I'd appreciate if anyone can share their experience with me:

1. Is is safe to upgrade upgrade to 4.1+? Would it cause any problems with existing databases?

2. What is the latest version supported

3. Is there a way to do it via WHM or /scripts?

Thanks for your help.
 

celliott

Well-Known Member
Jan 2, 2006
459
0
166
United Kingdom
I was in the same situation as you, and after reading a lot of posts I gave it a go. Installation went fine, however it completely messed up passwords on our billing system, even with the "use old password" feature enabled.

Because of this I just went back to 4.0.25.

On the Release tree you will get MySQL 4.1.14
 

electron33

Well-Known Member
Feb 24, 2004
90
0
166
Thanks Celliott. So, I could end up screwing up my server :-(
 
Last edited:

celliott

Well-Known Member
Jan 2, 2006
459
0
166
United Kingdom
You could always give it a go, make a backup of all your databases first.

Do this by making a copy or archiving /var/lib/mysql

Then its just a case of changing the version in cpanel tweak settings, wait 30 sec, click update and then recompile apache. Should anything go wrong, change version to 4.0 and update again. Then delete /var/lib/mysql and replace it with the copy you backed up earlier.

I have been looking into the password issue and it seems a line can just be added into the server my.cnf. I will have another attempt later on tonight as there will be less visitors, or in theory at least.

If you want to give it a go and need any help, just send me a PM and I will be happy to help.
 
Last edited:

trhosting.net

Well-Known Member
Mar 7, 2006
152
1
168
Turkey
Mysql 4.1.x is very different from 4.0.x.
It stores all databases in utf8 format and you have to make characterset settings after you connect to mysql.

I transfered to 4.1 but i want to go back to 4.0.
It seems not possible now because i have a lot of databases.

Conclusion:
If you like 4.0 and you have no problem with it, don't upgrade to 4.1 :)
 

abubin

Well-Known Member
Dec 7, 2004
401
3
168
the main problem you will face with 4.0 to 4.1 is the new password system. But this problem is well documented in a lot of websites. You can just google for the solution and even on mysql site, there are well written solutions.

Other than that...not much other problems. Shouldn't be too big a problem for a normal server admin to work it out. If someone as noob as me can solve them, I am sure most other admins can do it.
 

cygnuzz

Member
Jan 25, 2006
5
0
151
I'm using Centos also for my CPanel server. If I tick options for CPanel updates in Main - Server Configuration - Update Config, and choose Automatic updates for all, will mysql also updated automatically? Is it wise to automatically all updates?
 

celliott

Well-Known Member
Jan 2, 2006
459
0
166
United Kingdom
No. You need to specify the MySQL version in "Tweak Settings" if you want the 4.1 tree. For the moment cPanel updates will only give you MySQL 4.0.25

From my experience I would also advise to turn off automatic updates. Since if anything is broken in a update, you can always wait for a fix or solution before updating your server.