Title: SQL Syntax Error in Import
Last modified: August 19, 2016

---

# SQL Syntax Error in Import

 *  [chandlerwhite](https://wordpress.org/support/users/chandlerwhite/)
 * (@chandlerwhite)
 * [16 years, 2 months ago](https://wordpress.org/support/topic/sql-syntax-error-in-import/)
 * I’ve been trying to import an SQL backup from my old blog, which no longer exists
   in any manner except the wp backup, into my new one. As much as I’ve looked around
   for answers, I can’t come up with anything. When I originally imported the full
   backup into my new database it accepted it, but knocked my new blog out of biz.
   I got things going again and with some help from here I learned how to select
   portions of the backup because all I really care to retain are the old blog’s
   posts and comments. But when I import this file I’m getting SQL syntax errors.
   The first one follows, but I have a feeling there will be more. I’d appreciate
   knowing how to fix at least this error and any overall strategies to get the 
   whole file imported. Thank You…
 * CREATE TABLE `wp_posts` (
    `ID` bigint(20) unsign’ at line 1

Viewing 1 replies (of 1 total)

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [16 years, 2 months ago](https://wordpress.org/support/topic/sql-syntax-error-in-import/#post-1363513)
 * If you, at one time, were able to import the full backup, then might consider
   that while breaking up the file you’ve introduced a syntax error.
 * There is the option of [installing WordPress on your ‘local computer’](http://codex.wordpress.org/Installing_WordPress#Installing_WordPress_on_your_own_Computer),
   import that whole database, delete the posts and stuff you don’t need, then use
   the Tools->Export to export a file, then at the new blog use Tools->Import.

Viewing 1 replies (of 1 total)

The topic ‘SQL Syntax Error in Import’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [MichaelH](https://wordpress.org/support/users/michaelh/)
 * Last activity: [16 years, 2 months ago](https://wordpress.org/support/topic/sql-syntax-error-in-import/#post-1363513)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics