failed restore sql database

  • koncling

    (@koncling)


    13 years, 3 months ago

    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:
    Error

    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)
  • Thread Starter koncling

    (@koncling)

    13 years, 3 months ago

    hello nobady know about it?

    hey2you

    (@hey2you)

    13 years, 3 months 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.

    Thread Starter koncling

    (@koncling)

    13 years, 3 months 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

    hey2you

    (@hey2you)

    13 years, 3 months ago

    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.