Title: Problems restoring from sql
Last modified: August 19, 2016

---

# Problems restoring from sql

 *  [ilikeike](https://wordpress.org/support/users/ilikeike/)
 * (@ilikeike)
 * [16 years, 6 months ago](https://wordpress.org/support/topic/problems-restoring-from-sql/)
 * Hi. I’m having a problem restoring part of a database, and I wonder if you could
   help:
 * The sad tale: We had free hosting from a friend. The friend left her job, and
   then, eventually the host went under. We lost our blog. We restored from a six
   month old backup (all we had).
 * When we managed to get in touch with the server’s new owner, he very kindly exported
   the mysql database to a sql file and let us have it. Awesome.
 * But when I go in through phpmyadmin to upload the old database (I figured I’d
   export the new entries, replace the database with the one we’d lost, then use
   wordpresses import functionality to get the recent entries back in) I get the
   following error. Any ideas?
 * Error
 * > SQL query:
   > /*!40000 ALTER TABLE `wp_comments` DISABLE KEYS */;
   > MySQL said: Documentation
   >  #2006 – MySQL server has gone away
 * Help!?
 * Thanks

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [stvwlf](https://wordpress.org/support/users/stvwlf/)
 * (@stvwlf)
 * [16 years, 6 months ago](https://wordpress.org/support/topic/problems-restoring-from-sql/#post-1276616)
 * If your old database file is quite large, the server may be timing out.
    If that
   is the case try this [http://www.ozerov.de/bigdump.php](http://www.ozerov.de/bigdump.php)
 * By the way, if you load the database, you don’t need to do a WP import – all 
   the import does is load the database, which you will already have done.
 * If your database is from an earlier version of WP and you are running the latest
   now, WP will do a database upgrade when you finally get the database loaded in
   mySQL.
 *  [Shane G.](https://wordpress.org/support/users/shane-g-1/)
 * (@shane-g-1)
 * [16 years, 6 months ago](https://wordpress.org/support/topic/problems-restoring-from-sql/#post-1276695)
 * Hi,
 * It seems that there is an issue with the server services when you try to restore
   large database. You can provide your database backup to the hosting service provider
   to restore it.
 * Thanks,
 * Shane G.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Problems restoring from sql’ is closed to new replies.

## Tags

 * [sql-errors](https://wordpress.org/support/topic-tag/sql-errors/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 3 participants
 * Last reply from: [Shane G.](https://wordpress.org/support/users/shane-g-1/)
 * Last activity: [16 years, 6 months ago](https://wordpress.org/support/topic/problems-restoring-from-sql/#post-1276695)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics