MySQL Forums
Forum List  »  Data Recovery

Re: Problems dump 4 to 5.5
Posted by: Jonathon Coombes
Date: August 24, 2013 04:15PM

Have you considered using a stream editor? I am not sure what platform you are working on here, but on Linux you should be able to do:

shell> cat dump4.sql | sed 's/TYPE=INNODB/ENGINE=INNODB/g' > dump5.sql

Alternatively, you can pipe it directly into the mysql client.

You should also consider using an extended insert to specify column names etc so that any mismatched tables with more columns in 5.5 will not cause errors.

Options: ReplyQuote


Subject
Views
Written By
Posted
2447
August 23, 2013 02:01PM
Re: Problems dump 4 to 5.5
1212
August 24, 2013 04:15PM
1248
August 24, 2013 09:33PM


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.