Title: MySQL Error
Last modified: August 19, 2016

---

# MySQL Error

 *  [checktherhime](https://wordpress.org/support/users/checktherhime/)
 * (@checktherhime)
 * [17 years, 7 months ago](https://wordpress.org/support/topic/mysql-error-4-2/)
 * When I attempt to restore my database from a backup file using pHpMyAdmin by 
   copying the contents of the .sql file into the content editor (as suggested here:
   [http://www.tamba2.org.uk/wordpress/restore/](http://www.tamba2.org.uk/wordpress/restore/))
   I get the following error message:
 * Error
 * SQL query:
 * /*!40000 ALTER TABLE `wp_posts` DISABLE KEYS */;
 * MySQL said: Documentation
    #2006 – MySQL server has gone away

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

 *  [thisisedie](https://wordpress.org/support/users/thisisedie/)
 * (@thisisedie)
 * [17 years, 7 months ago](https://wordpress.org/support/topic/mysql-error-4-2/#post-883531)
 * Make sure it’s an empty database and then try importing it instead of copying
   and pasting.
 *  Thread Starter [checktherhime](https://wordpress.org/support/users/checktherhime/)
 * (@checktherhime)
 * [17 years, 7 months ago](https://wordpress.org/support/topic/mysql-error-4-2/#post-883533)
 * I made sure the database was empty and I’ve also tried importing but when I attempt
   to import the backup file I get another error which I’ll paste here after i attempt
   to import the file again and it (no doubt) fails. Thanks for responding back 
   so quickly though.
 *  Thread Starter [checktherhime](https://wordpress.org/support/users/checktherhime/)
 * (@checktherhime)
 * [17 years, 7 months ago](https://wordpress.org/support/topic/mysql-error-4-2/#post-883534)
 * I still get the same error when I try to import the file although after I attempt
   to import the file or copy and paste I get the error message but then database
   which was empty now always has 5 items (wp_comments, wp_links, wp_posts, wp_postmeta,
   and wp_options).
 *  Thread Starter [checktherhime](https://wordpress.org/support/users/checktherhime/)
 * (@checktherhime)
 * [17 years, 7 months ago](https://wordpress.org/support/topic/mysql-error-4-2/#post-883607)
 * anybody?

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

The topic ‘MySQL Error’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [checktherhime](https://wordpress.org/support/users/checktherhime/)
 * Last activity: [17 years, 7 months ago](https://wordpress.org/support/topic/mysql-error-4-2/#post-883607)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics