I'm trying to deploy my D7 site from my local dev server to an online host.
I export my database using the export function in phpMyAdmin and then import the file on the host end also using phpMyAdmin. PhpMyAdmin versions are the same on both ends, and I have tried both the quick export and many settings, matching settings on the import, and I get the same #1064 syntax error every time. However I don't see any issues with the SQL, it looks fine to me. I have also taken the exported SQL and pasted it into phpMyAdmin as a SQL statement and get the exact same error.