Re: MySQL 3 to 5 upgrade
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]
Re: MySQL 3 to 5 upgrade
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 I will definitely do this. Meanwhile though, it seems to me that my best option is to set up a similar system on my local machine - where I do all my development - as soon as I can. So maybe this is where it gets /slightly/ off-topic... Can anyone recommend - bearing in mind that I'm no great Unix expert but can follow instructions slavishly! - the best combination of MySQL 5, PHP 5 and Apache 2 for Mac OS X 10.4? I do currently run PHP 5, but only Apache 1.3 and MySQL 4.1. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ A professor is one who talks in someone else's sleep. -- W.H. Auden -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 3 to 5 upgrade
Hi, > Yeah - I think the playground is unlikely to happen. They certainly > haven't said anything about providing such a facility. If they don't give a test machine, or don't provide a smooth migration (like installing a new server, and keeping the old one running 3.23), you should consider complaining (loudly !)... My provider upgraded from 3.23 to 4.1, and there was still few glitches (missing grants for temporary tables, lock,and still no InnoDB). > > What I'm banking on is that my own usage of MySQL so far (I'm > learning, I'm learning!) is sufficiently primitive that it won't be > upset too much by the change! 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... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL 3 to 5 upgrade
At 8:32 -0700 13/4/06, paul rivers wrote: Going from 3 to 5 can break a number of important things. For example, join syntax semantics and precedence rules have changed since 3, and it is certainly possible this could break your code in important and dramatic ways. You should plan on spending time checking out all the SQL. Just as important, your MySQL host should really provide a 5.x playground for you to check your app out in for at least several weeks prior to the upgrade. Just waking up one morning with the database "upgraded" is almost surely going to be a mess. Yeah - I think the playground is unlikely to happen. They certainly haven't said anything about providing such a facility. What I'm banking on is that my own usage of MySQL so far (I'm learning, I'm learning!) is sufficiently primitive that it won't be upset too much by the change! -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ I think I think; therefore I think I am. -- Ambrose Bierce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL 3 to 5 upgrade
Going from 3 to 5 can break a number of important things. For example, join syntax semantics and precedence rules have changed since 3, and it is certainly possible this could break your code in important and dramatic ways. You should plan on spending time checking out all the SQL. Just as important, your MySQL host should really provide a 5.x playground for you to check your app out in for at least several weeks prior to the upgrade. Just waking up one morning with the database "upgraded" is almost surely going to be a mess. Good luck, Paul -Original Message- From: Chris Sansom [mailto:[EMAIL PROTECTED] Sent: Thursday, April 13, 2006 3:54 AM To: Barry; mysql@lists.mysql.com Subject: Re: MySQL 3 to 5 upgrade At 11:56 +0200 13/4/06, Barry wrote: >Make a real downgradeable SQL Dump (without collations n stuff) and >have it saved. >Upgrade to MySQL 5.x and execute that sql dump. > >Be warned that for example CONCAT behaves in a different way than in 3.x. > >If you have PHP scripts with some functions in their sql queries you >should check them all. > >Data should be safe and beeing able to be inserted into the new SQL >environment. Thanks - sounds like good sounds advice. :-) I'll look into CONCAT. The only thing is that, judging by past experience, the host will only give us an approximate idea of when this might happen, so I may well be presented with a fait accompli! It's likely to happen in the middle of the night, so I just hope I don't wake up one day to dozens of emails saying the whole thing's broken. I'll just have to keep my fingers crossed. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ A censor is a man who knows more than he thinks you ought to. -- Laurence J. Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 3 to 5 upgrade
At 11:56 +0200 13/4/06, Barry wrote: Make a real downgradeable SQL Dump (without collations n stuff) and have it saved. Upgrade to MySQL 5.x and execute that sql dump. Be warned that for example CONCAT behaves in a different way than in 3.x. If you have PHP scripts with some functions in their sql queries you should check them all. Data should be safe and beeing able to be inserted into the new SQL environment. Thanks - sounds like good sounds advice. :-) I'll look into CONCAT. The only thing is that, judging by past experience, the host will only give us an approximate idea of when this might happen, so I may well be presented with a fait accompli! It's likely to happen in the middle of the night, so I just hope I don't wake up one day to dozens of emails saying the whole thing's broken. I'll just have to keep my fingers crossed. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ A censor is a man who knows more than he thinks you ought to. -- Laurence J. Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 3 to 5 upgrade
Chris Sansom wrote: Our web host is currently running MySQL 3.23.something, but we're shortly to be upgraded to MySQL 5. Can I be sure that this is absolutely backwards compatible? Are there any nastinesses lurking that I should know about that might cause my databases to collapse in a heap? My use of MySQL (as my previous question will attest!) is comparatively limited so far, and I tend to do everything either via phpMyAdmin or my own PHP scripts. Any warnings would be gratefully received! do it that way: Make a real downgradeable SQL Dump (without collations n stuff) and have it saved. Upgrade to MySQL 5.x and execute that sql dump. Be warned that for example CONCAT behaves in a different way than in 3.x. If you have PHP scripts with some functions in their sql queries you should check them all. Data should be safe and beeing able to be inserted into the new SQL environment. Good Luck! -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]