Title: Error when restoring tables
Last modified: August 18, 2016

---

# Error when restoring tables

 *  Resolved [amadeus](https://wordpress.org/support/users/amadeus/)
 * (@amadeus)
 * [19 years, 4 months ago](https://wordpress.org/support/topic/error-when-restoring-tables/)
 * Hello all
 * i am removing my site to a new server. i did a backup of the WP files, and then
   from the control panel a backup of the tables.
 * When i went to the new servers MySQL CP, and uploaded the file WP has produced,
   i got this error-
 * “Unable to restore database blogish_gunav : ERROR 1064 (42000) at line 2847: 
   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 ’08:37:35, ‘2006-07-01 
   08:33:37′)’ at line 1 gunzip: stdout: Broken pipe “
 * I have no idea what that means.
    Any Help very much appreciated!

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

 *  [Michael Bishop](https://wordpress.org/support/users/miklb/)
 * (@miklb)
 * [19 years, 4 months ago](https://wordpress.org/support/topic/error-when-restoring-tables/#post-498995)
 * What control panel did you use to produce the database?
 *  Thread Starter [amadeus](https://wordpress.org/support/users/amadeus/)
 * (@amadeus)
 * [19 years, 4 months ago](https://wordpress.org/support/topic/error-when-restoring-tables/#post-499121)
 * Hello Miklb
 * The WP control panel.
 *  [Michael Bishop](https://wordpress.org/support/users/miklb/)
 * (@miklb)
 * [19 years, 4 months ago](https://wordpress.org/support/topic/error-when-restoring-tables/#post-499128)
 * Looks like you need to extract the gzipped file created by the database backup
   plugin, then import that into your database control panel.
 *  Thread Starter [amadeus](https://wordpress.org/support/users/amadeus/)
 * (@amadeus)
 * [19 years, 4 months ago](https://wordpress.org/support/topic/error-when-restoring-tables/#post-499197)
 * I used this great sctipt (in hebrew, sorry) that lets you split backup into parts
   smaller then 5 Mega.
    [http://www.mirshet.net/?p=64](http://www.mirshet.net/?p=64)
 * Yhanks 4 ur help mike.

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

The topic ‘Error when restoring tables’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [amadeus](https://wordpress.org/support/users/amadeus/)
 * Last activity: [19 years, 4 months ago](https://wordpress.org/support/topic/error-when-restoring-tables/#post-499197)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics