Title: SQL Database – Error when restoring from backup
Last modified: August 18, 2016

---

# SQL Database – Error when restoring from backup

 *  [nsg1000](https://wordpress.org/support/users/nsg1000/)
 * (@nsg1000)
 * [19 years, 2 months ago](https://wordpress.org/support/topic/sql-database-error-when-restoring-from-backup/)
 * I recently had to move my wordpress site to a different server. I followed the
   instructions on [http://codex.wordpress.org/WordPress_Backups](http://codex.wordpress.org/WordPress_Backups)
   to export the database using phpmyadmin.
 * When I tried to restore it on my new hosting plan there was not import option
   in the phpmyadmin. So I followed the instruction to restore using the command
   line interface, however when I try to do it, i get the following error:
 * `ERROR 1064 (00000) at line 20: 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=20' at line 11`
 * I have been stuck on this for a few days, so if someone knows what I am doing
   wrong I would greatly appreciate guidance. Thanks

The topic ‘SQL Database – Error when restoring from backup’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [nsg1000](https://wordpress.org/support/users/nsg1000/)
 * Last activity: [19 years, 2 months ago](https://wordpress.org/support/topic/sql-database-error-when-restoring-from-backup/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics