SQL Error on very first db restore

  • Have this error when restoring db via phpmyadmin

    Error
    SQL query:

    /*!40101 SET @saved_cs_client = @@character_set_client */;

    MySQL said: Documentation

    #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 ‘CREATE TABLE wp_comments (
    comment_ID bigint(20) unsigned NOT NULL AUTO_IN’ at line 2

Viewing 1 replies (of 1 total)
  • Plugin Contributor Katrina “Kat” Moody

    (@katmoody)

    Check with your host on this one – usually they can do a direct database import that will work around differences between character sets, how databases are saved, etc. Usually something like this would indicate that the character set (like UTF8) isn’t encoded the same way as the receiving database. But it can include more than that depending on how much information the database you’re restoring contains versus how much the database admin (phpmyadmin) can read.

    Check with your and let me know what they have to say?
    Thanks,
    Kat

Viewing 1 replies (of 1 total)
  • The topic ‘SQL Error on very first db restore’ is closed to new replies.