1064 You have an error in your SQL syntax … TYPE=MyISAM

When you importing database from MySQL4 version to new MySQL5, you can egt this kind of error. You can fix it:

grep -rl mysql4.sql * | xargs sed -i ” s/TYPE=MyISAM/ENGINE=MyISAM/g

Leave a Reply

Your email address will not be published. Required fields are marked *