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]
