Re: Migration from MySQL 3.23.41 to 5.1.47
Posted by: Rick James
Date: June 04, 2010 08:26PM

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.

Options: ReplyQuote

Written By
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.