1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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):

    SEMrush
     
    wnj4, Feb 28, 2013 IP
    SEMrush
  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