SQL Database – Error when restoring from backup

  • I recently had to move my wordpress site to a different server. I followed the instructions on https://codex.www.ads-software.com/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

  • The topic ‘SQL Database – Error when restoring from backup’ is closed to new replies.