failed restore sql database (5 posts)

  1. koncling
    Posted 5 years ago #

    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.

  2. koncling
    Posted 5 years ago #

    hello nobady know about it?

  3. hey2you
    Posted 5 years ago #

    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.

  4. koncling
    Posted 5 years ago #

    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

  5. hey2you
    Posted 5 years ago #

    try uncheck the box

    "Enclose table and field names with backquotes"

    when you export the SQL file from phpmyadmin

Topic Closed

This topic has been closed to new replies.

About this Topic