Dumping problem. Help!!

Discussion in 'MySQL' started by Overclock099, Jan 3, 2008.

0
  1. #1
    I want to dump a database for one of my client. But i got this error..

    Anyone know what happen.. I think this is server problem. The server is from dot5hosting.com. I have contact support & they ask will asking thier technician to look at the problem.. Until now (over 24 hour now) they still not do anything.

    I never found this problem. This file size is not big. Only 515kb.. Please advice..
     
    Overclock099, Jan 3, 2008 IP
  2. countZZero

    countZZero Peon

    Messages:
    23
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    What are the other options on the dump screen? There are 15 or 20 different options you can select when exporting a MySQL database. One of these is checked incorrectly. Hint: When in doubt, take the defaults.

    Cheers,

    Karl
    www.fastercats.com
    www.market-match.info
     
    countZZero, Jan 3, 2008 IP
  3. Marty_

    Marty_ Banned

    Messages:
    1,031
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    0
    #3

    You probable have this fixed already, but I just thought I would add this.

    All you need to do is remove the line: 
    SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
    PHP:
    From the sql file in question.
     
    Marty_, Jan 6, 2008 IP
  4. Overclock099

    Overclock099 Notable Member

    Messages:
    3,648
    Likes Received:
    122
    Best Answers:
    0
    Trophy Points:
    280
    #4
    Oh yes..I have fix the problem..Thanks for the tips..:)
     
    Overclock099, Jan 6, 2008 IP
  5. seanyboyyo

    seanyboyyo Banned

    Messages:
    1,161
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #5
    peptobismo =D

    haha

    (in case you were wondering this is a joke, b/c of the name of the title!)
     
    seanyboyyo, Jan 9, 2008 IP