Re: Migration from MySQL 3.23.41 to 5.1.47
mysqldump, then mysql.
Test, test, test.
Will you be changing character sets?
A moderately likely problem you will encounter: new keywords. A simple workaround: Go into the source and use backticks around column/table names that are now reserved words:
WHERE `when` > blah
(WHEN is a new keyword -- you might have a column with that name).
Are you going from Windows to Windows? Then you are unlikely to stumble over Windows ignoring case, while Unix is case-sensitive.
Subject
Written By
Posted
Re: Migration from MySQL 3.23.41 to 5.1.47
June 04, 2010 08:26PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.