At 19:14 +0100 14/4/06, Philippe Poelvoorde wrote:
Have a serious look at :
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
There is many things likely to break, CONCAT, display of Timestamp,
default values for timestamp, precedence for left join, and so on...
Thanks for this advice. I've now successfully upgraded my Mac to run
Apache 2.2.0, PHP 5.1.2 and MySQL 5.0.19.
I've ironed out one or two minor hiccups resulting from obvious
things like having columns named the same as new reserved words, and
everything seems to be running pretty smoothly. As I suspected, most
of the stuff detailed in those three pages goes beyond my so far
fairly primitive usage of MySQL, though I am checking out a couple of
PHP routines that refer to timestamp values. My use of joins has so
far been minimal, and I also use very few MySQL functions so far,
using PHP to do that kind of processing (though of course I
appreciate the difference and realise the huge power of MySQL that
I've yet to tap :-) ). I don't, for example, seem to have used CONCAT
(about which I had dire warnings) at all yet!
I did dump all my databases before upgrading, then run the dumps to
recreate the databases, all with no fuss at all.
I also ran mysql_upgrade and got a clean bill of health, for what that's worth.
Thanks again to all those who provided upgrading tips.
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Old professors never die; they just lose their faculties.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]