469,579 Members | 1,082 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

Pitfalls for upgrading: 3.23 => 4.1

Dear newsies,

My ISP has offered to upgrade my servers from 3.23 to 4.1.

I'm excited by the potential gains in performance, and the ability to
write subqueries, but am wary of any forward incompatibilities. I have
a mass of PHP code with MySQL throughout. I don't relish peeking into
every file and making a determination of 'it should work' by eyeballs
alone.

What do I need to watch out for? Or where can I find a nice summary of
differences between the versions?

Thanks!
Jul 20 '05 #1
2 1209
wellington fan wrote:
What do I need to watch out for? Or where can I find a nice summary of
differences between the versions?


Read these upgrade guides:
http://dev.mysql.com/doc/mysql/en/Up...-from-4.0.html
http://dev.mysql.com/doc/mysql/en/Up...from-3.23.html

You can read the changes in 4.0 and 4.1 here:
http://dev.mysql.com/doc/mysql/en/News-4.1.x.html
http://dev.mysql.com/doc/mysql/en/News-4.0.x.html

I'd suggest googling through newsgroup archives for other folks' stories
about upgrading. I tried one search for simply "mysql" "upgrade" and
found a bunch of hits. Many of the issues are probably already noted in
the Upgrading web pages above.

And, though this should already be in place, create and verify backups
of your databases first!

Regards,
Bill K.
Jul 20 '05 #2
Thanks for the pointers Bill... I will check them out.
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by S. Crespel | last post: by
1 post views Thread by bartolomesintes | last post: by
2 posts views Thread by wellington fan | last post: by
5 posts views Thread by Mike Owen | last post: by
11 posts views Thread by Aidan Tobin | last post: by
1 post views Thread by spamfurnace | last post: by
1 post views Thread by progTiger | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.