Importing sql getting error #1064 You Have error SQL Syntax

  • xctechs

    (@xctechs)


    14 years, 3 months ago

    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

    (@netcsvg)

    14 years, 3 months ago

    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

    (@xctechs)

    14 years, 3 months ago

    this file is from backup sql for full backup for wordpress blog

    Thread Starter xctechs

    (@xctechs)

    14 years, 3 months ago

    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