Upgrade MySQL 4.0 to MySQL 4.1

snet

Active Member
May 16, 2004
25
0
151
UK
I am currently running MySQL 4.0 and for a while now I've been thinking about upgrading to MySQL 4.1. If I upgrade to MySQL 4.1, will it break any of the scripts/databases that I currently have on my server? Any issues that I should be aware of? What are the benefits of MySQL 4.1 over 4.0? Is it even worth upgrading?


Thanks,

Steve
 

webignition

Well-Known Member
Jan 22, 2005
1,880
0
166
You should take a backup of all existing databases before upgrading in case you need to downgrade to 4.0.

The databases are stored in /var/lib/mysql - just copy the entire directory and it's contents to somewhere safe.

It is also advisable to dump the data to .sql files so that all tables and their contents can be imported into the new 4.1 databases in case the 4.1 databases have problems.

You should also check "Use old style (4.0) passwords with mySQL 4.1 (required if you have problems with php apps authenticating)" in WHM > Tweak Settings after you have upgraded just to be on the safe side.

4.0 -> 4.1 is not automatically reversible. As long as you have good backups before you start you can at least revert to how things were if any major problems are encountered.

To be honest, I haven't risked it yet myself!
 

tweakservers

Well-Known Member
Mar 30, 2006
379
0
166
we see bad things happen for scripts / application on some client servers which does not have the backup made. There are major changes on the MySQL 4.0 to MySQL 4.1 and if some of your application sql query is written that is incompatible to run in MySQL 4.1, you will see lots of problems. Follow snet suggestion to backup a copy of your MySQL database before proceed for any upgrade.
 

kistler

Well-Known Member
Jan 27, 2005
136
0
166
I did the upgrade, everything is working fine and no complaints or issues –

BUT now I get a warning about having 4.0.x although I have 4.1.19 ??
 

cooldude7273

Well-Known Member
Jan 11, 2004
359
0
166
Roswell, GA
kistler said:
BUT now I get a warning about having 4.0.x although I have 4.1.19 ??
It's not saying that YOU are using 4.0.x, it's just a general warning that is being displayed throughout everybody's WHM, no need to worry. :)
 

kistler

Well-Known Member
Jan 27, 2005
136
0
166
i am kinda guessing that, just takes up so much room ;) and i dont need to read it lol
 

RKF

Member
Jul 25, 2003
8
0
151
Some older scripts would need updating for compatibility, if for example the authors used MYSQL reserved words for their aliases that worked on 4.0 but not 4.1.

If people have home-baked scripts on their systems or old versions of publically available ones, you'd either have to audit the accounts and wait months for everyone to catch up, or just do it and see who screams.