I recently had to move my wordpress site to a different server. I followed the instructions on http://codex.wordpress.org/WordPress_Backups to export the database using phpmyadmin.
When I tried to restore it on my new hosting plan there was not import option in the phpmyadmin. So I followed the instruction to restore using the command line interface, however when I try to do it, i get the following error:
ERROR 1064 (00000) at line 20: 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 CHARSET=latin1 AUTO_INCREMENT=20' at line 11
I have been stuck on this for a few days, so if someone knows what I am doing wrong I would greatly appreciate guidance. Thanks