WordPress.org

Ready to get started?Download WordPress

Forums

SQL Database - Error when restoring from backup (1 post)

  1. nsg1000
    Member
    Posted 7 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Topic