Big Dump import problem

Discussion in 'MySQL' started by killer12345, Apr 14, 2010.

  1. #1
    Help I have a 761mb database (88mb compressed) that I can't import.

    [​IMG]

    Can someone tell how to fix this or another way to import it?
     
    killer12345, Apr 14, 2010 IP
  2. RHS-Chris

    RHS-Chris Well-Known Member

    Messages:
    1,007
    Likes Received:
    35
    Best Answers:
    10
    Trophy Points:
    150
    #2
    Ask your host to import the database for you through ssh.
     
    RHS-Chris, Apr 14, 2010 IP
  3. killer12345

    killer12345 Peon

    Messages:
    56
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Im using Wamp. How do I do that?
     
    killer12345, Apr 14, 2010 IP
  4. vagrant

    vagrant Peon

    Messages:
    2,284
    Likes Received:
    181
    Best Answers:
    0
    Trophy Points:
    0
    #4
    vagrant, Apr 15, 2010 IP
  5. killer12345

    killer12345 Peon

    Messages:
    56
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I've tried that. Didn't work.
     
    killer12345, Apr 15, 2010 IP
  6. vagrant

    vagrant Peon

    Messages:
    2,284
    Likes Received:
    181
    Best Answers:
    0
    Trophy Points:
    0
    #6
    OK what have your tried. ... import via phpmyadmin, import via command line, setting "bigdump" to handle comments.

    How did you produce the mysql dump in the first place and what is it used in?

    what Wamp setup are you using and what operating system is it on.?

    saying "I've tried that. Didn't work." when the post gives about 4 or 5 ways does not help.
    Please say WHAT you have tried, what the error messages were etc. or how do you expect anyone to be able to help ?

    you need to give us more info to be able to help you.
     
    vagrant, Apr 15, 2010 IP
  7. sydmeeran

    sydmeeran Active Member

    Messages:
    138
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #7
    this is because of the linebreak problem... After seeing my post .. just pm me... i will give you the solution.
     
    sydmeeran, Apr 21, 2010 IP
  8. testingwhiz

    testingwhiz Peon

    Messages:
    99
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    I am also thinking that may line breaking problem....!!
     
    testingwhiz, Apr 23, 2010 IP