PDA

View Full Version : [ubuntu] new mysql database create structure vs older ones



sdowney717
January 10th, 2011, 06:02 PM
say I have a mysql database created with 5.05 version of mysql.
I then attempt to use that database with mysql server 5.5 or even 5.1
I get syntax errors
I have been down this before upping to newer version of the server.
I have in the past had to mysql dump the database then reload for the newer servers.
AND modify my database create statements since they no longer work, the syntax being totally wrong.

Do you run into this yourself?
Looks like if I want to play with the newer server, I will need to do a lot of work. Any ideas to minimize the pain?