Title: failed restore sql database
Last modified: August 19, 2016

---

# failed restore sql database

 *  [koncling](https://wordpress.org/support/users/koncling/)
 * (@koncling)
 * [15 years, 4 months ago](https://wordpress.org/support/topic/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: 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](https://wordpress.org/support/users/koncling/)
 * (@koncling)
 * [15 years, 4 months ago](https://wordpress.org/support/topic/failed-restore-sql-database/#post-1880789)
 * hello nobady know about it?
 *  [hey2you](https://wordpress.org/support/users/hey2you/)
 * (@hey2you)
 * [15 years, 4 months ago](https://wordpress.org/support/topic/failed-restore-sql-database/#post-1880791)
 * 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](https://wordpress.org/support/users/koncling/)
 * (@koncling)
 * [15 years, 4 months ago](https://wordpress.org/support/topic/failed-restore-sql-database/#post-1880801)
 * 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](https://wordpress.org/support/users/hey2you/)
 * (@hey2you)
 * [15 years, 4 months ago](https://wordpress.org/support/topic/failed-restore-sql-database/#post-1880802)
 * 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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [hey2you](https://wordpress.org/support/users/hey2you/)
 * Last activity: [15 years, 4 months ago](https://wordpress.org/support/topic/failed-restore-sql-database/#post-1880802)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics