By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,508 Members | 1,915 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,508 IT Pros & Developers. It's quick & easy.

Pitfalls for upgrading: 3.23 => 4.1

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.