I had problems with importing .sql file created via DBC backup 2 wordress plugin. The plugin is great and simple but after my host upgraded to mysql 5.5 it gaves me an error (#1064-suspecting now) with encoding.
After several hours, lost in the issue, i finally call the service at my hosting company for solution. The engineer was kind and after few minutes he found the source of problem in
TYPE=MyISAM and etc part of code inside .sql file. So he recomended to delete that parameter and import was working fine.
After that I also found some opinion, that the TYPE attributte in mySQL is obsolete and we should use ENGINE instead. Have done revisiting source files in DBC backup 2 plugin and I found in function.php file row that says: “
$create_table = preg_replace("/ENGINE\s?=/", "TYPE=", $create_table) “ so I commented it out and everything works now with importing dumped sql file at mySQL 5.5 without editing dumped sql file before import to server.