Title: Importing sql getting error #1064 You Have error SQL Syntax
Last modified: August 20, 2016

---

# Importing sql getting error #1064 You Have error SQL Syntax

 *  [xctechs](https://wordpress.org/support/users/xctechs/)
 * (@xctechs)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/importing-sql-getting-error-1064-you-have-error-sql-syntax/)
 * Error
    SQL query:
 * —
    — Database: `bision_vlogs` — — ——————————————————– — — Table structure for
   table `wp_commentmeta` — — Creation: Oct 19, 2011 at 04:18 AM — Last update: 
   Jan 19, 2012 at 03:54 PM — Last check: Jan 18, 2012 at 03:02 AM – – db399572017
   DROP TABLE IF EXISTS `wp_commentmeta`
 * MySQL said:
 * #1064 – 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 ‘–db399572017
 * DROP TABLE IF EXISTS `wp_commentmeta`‘ at line 13
 * I have contacted our new host 1and1 and they have indicated to me that i am using
   old sql but talking to my old provider which is psychz they showed me they are
   using “Server version: 5.1.56”
 * I have checked with old host and they have checked my sql file and nothing is
   wrong, i hope someone has a resolution I can’t think of a way to fix this,

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

 *  [netcs.vg](https://wordpress.org/support/users/netcsvg/)
 * (@netcsvg)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/importing-sql-getting-error-1064-you-have-error-sql-syntax/#post-2516448)
 * Im not sure which file this is coming from but the error is because of the extra
   space in : ‘- – db399572017 DROP TABLE IF EXISTS wp_commentmeta’
    if you see 
   the prior lines they start with — (a comment line), except the last line that
   starts with – -. so if you take out that space most likely your query will run…
 *  Thread Starter [xctechs](https://wordpress.org/support/users/xctechs/)
 * (@xctechs)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/importing-sql-getting-error-1064-you-have-error-sql-syntax/#post-2516576)
 * this file is from backup sql for full backup for wordpress blog
 *  Thread Starter [xctechs](https://wordpress.org/support/users/xctechs/)
 * (@xctechs)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/importing-sql-getting-error-1064-you-have-error-sql-syntax/#post-2516582)
 * i checked its not an space 🙁

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

The topic ‘Importing sql getting error #1064 You Have error SQL Syntax’ is closed
to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [xctechs](https://wordpress.org/support/users/xctechs/)
 * Last activity: [14 years, 4 months ago](https://wordpress.org/support/topic/importing-sql-getting-error-1064-you-have-error-sql-syntax/#post-2516582)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics