Title: Restoring Database
Last modified: August 18, 2016

---

# Restoring Database

 *  Resolved [jessinsd](https://wordpress.org/support/users/jessinsd/)
 * (@jessinsd)
 * [20 years, 3 months ago](https://wordpress.org/support/topic/restoring-database-2/)
 * I’m switching hosts and I’m uploading my backup of my sql db to my new one and
   i keep getting this error:
 * #1064 – You have an error in your SQL syntax near ‘ENGINE=MyISAM DEFAULT CHARSET
   =latin1 ‘ at line 14
 * I really have no idea how to do this. Does anyone know how to handle this?
 * Thanks in advance.

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

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 3 months ago](https://wordpress.org/support/topic/restoring-database-2/#post-343475)
 * yep – easily sorted 🙂
 * Open the .sql file in a plain text-editor (not a wordprocessor)
 * Do a search/replace, replacing
    `DEFAULT CHARSET=latin1 ` with nothing at all.
 * Save, import 🙂
 *  Thread Starter [jessinsd](https://wordpress.org/support/users/jessinsd/)
 * (@jessinsd)
 * [20 years, 3 months ago](https://wordpress.org/support/topic/restoring-database-2/#post-343478)
 * Thank you so much podz, I made it past line 14!
 * I have a new error though and I’m not sure if I should delete this or not:
 * #1064 – You have an error in your SQL syntax near ‘INSERT INTO `wp_categories`
   VALUES (1, ‘Uncategorized’, ‘uncategorized’, ”, 0, ‘ at line 20
 * Thanks.

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

The topic ‘Restoring Database’ is closed to new replies.

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 2 replies
 * 2 participants
 * Last reply from: [jessinsd](https://wordpress.org/support/users/jessinsd/)
 * Last activity: [20 years, 3 months ago](https://wordpress.org/support/topic/restoring-database-2/#post-343478)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics