Importing large SQL

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

  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