Hi. I'm moving from a Windows server to a Linux server and I'm having a problem moving over my blog's database. I got myphpadmin installed on the Windows box (a battle itself) and exported the database into a .sql file. However, when I try to import this file using myphpadmin on the Linux box I get an error.
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line
There is a similar topic on the forum that suggested I just edit out the offending text, but when I did this a whole other crop of problems came up. Can someone help me? I've been working on this all day and am very frustrated.