Re: Problems dump 4 to 5.5
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.
Subject
Views
Written By
Posted
2618
August 23, 2013 02:01PM
Re: Problems dump 4 to 5.5
1298
August 24, 2013 04:15PM
1337
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.