I have exported all my tables into a .sql file from mysql4 database. I imported into mysql5 database on different server and now it is saying syntax errors.
Does anyone know of a way to resolve this without having to go through manually and change syntax?
if you use comma join syntax (SELECT * FROM a, b WHERE a.column=b.column) and that is mixed with OUTER JOINS you will get an error in mysql 5. use explicit INNER JOIN syntax instead (SELECT * FROM a INNER JOIN b ON a.column=b.column
apart from that there are no obvious suggestions, you’d have to visit on a case by case basis.