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.

Importing large SQL

Discussion in 'MySQL' started by theprince, Nov 10, 2010.

0
  1. #1
    Hi,

    Please I need some help here and it would be very appreciated if you can give me a hand to solve this problem.

    I want to import a 140mo database, I already did the same task using bigdump but this time I get this error:

    Error at the line 1208: DELIMITER ;;

    Query: --
    --
    DELIMITER ;;


    MySQL: 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 'DELIMITER' at line 3

    Stopped on error
    Can you please tell me what's wrong? I need to import this sql as soon as possible, my site has been down for more than 1 week now and I feel terrible

    Thanks in advance!
     
    theprince, Nov 10, 2010 IP
  2. piske91

    piske91 Active Member

    Messages:
    43
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    63
    #2
    you can divide it in smaller files and upload it via phpadmin?
     
    piske91, Nov 10, 2010 IP
  3. elicitservers

    elicitservers Peon

    Messages:
    714
    Likes Received:
    7
    Best Answers:
    1
    Trophy Points:
    0
    #3
    What's on line 1208?
     
    elicitservers, Nov 10, 2010 IP
  4. shaftian

    shaftian Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    You can't use ; as a delimiter since that character is reserved for line termination.
     
    shaftian, Nov 12, 2010 IP
  5. jeffrey78

    jeffrey78 Peon

    Messages:
    22
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    You should try MySQLDumper
     
    jeffrey78, Nov 19, 2010 IP