Support » Fixing WordPress » failed restore sql database

  • hi
    as my hosting account canceled i try move my blog to another hosting company,
    but i have a problem when restoring my sql database to my new database. because my database size is about 50Mb, i try to restore it table by table everything fine until i restore wp_post table i keep getting this error message:

    SQL query:

    /*!40000 ALTER TABLE wp_posts DISABLE KEYS */;

    MySQL said: Documentation
    #2006 – MySQL server has gone away

    any suggestion how to fix it..?
    i do it all day long and no result.

Viewing 4 replies - 1 through 4 (of 4 total)
  • hello nobady know about it?

    is your file in SQL or CSV?? if it is in SQL try with phpmyadmin and copy and paste the SQL into the console to run the SQL directly there.

    my file is in SQL, i copy and paste my files table by table into the console. and that error showing, and sometimes the error code show like this

    #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 ” at line 1

    try uncheck the box

    “Enclose table and field names with backquotes”

    when you export the SQL file from phpmyadmin

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘failed restore sql database’ is closed to new replies.