Got error #1064 when import sql

Discussion in 'MySQL' started by wnj4, Feb 28, 2013.

  1. #1
    I want to move my website to another web hosting. Got an error when I import my sql. Is there anyone can help? Thanks a lot.

    Error
     
    SQL query:
     
    --
    -- Database: `u737534894_jjm`
    --
    -- --------------------------------------------------------
    --
    - - TABLE structure FOR TABLE `adboxes` --
    CREATE TABLE IF NOT EXISTS `adboxes` (
    `id` int( 8 ) NOT NULL AUTO_INCREMENT ,
    `adcode` text COLLATE utf8_unicode_ci,
    PRIMARY KEY ( `id` )
    ) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci AUTO_INCREMENT =4;
     
    MySQL said: Documentation
    #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 '--Table structure for table `adboxes`
    --
     
    CREATE TABLE IF NOT EXISTS `adboxes` (' at line 8 
    Code (markup):

     
    wnj4, Feb 28, 2013 IP
  2. Muhammad Jamshaid

    Muhammad Jamshaid Greenhorn

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    #2
    how u import database???
     
    Muhammad Jamshaid, Feb 28, 2013 IP
  3. wnj4

    wnj4 Greenhorn

    Messages:
    64
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #3
    thank you,i find what error related with.
    i was created MySQL tables first and try to import it that is error.
    i was delete the tables then import MySQL file ,it works now.
     
    wnj4, Mar 1, 2013 IP