Problem when importing dump using bigdump

Discussion in 'MySQL' started by fortify, Mar 3, 2007.

0
  1. #1
    When i tried to import my database using big dump i got this error

    Error at the line 3788: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

    Query: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;


    MySQL: Variable 'sql_mode' can't be set to the value of 'NULL'


    Can anyone help
     
    fortify, Mar 3, 2007 IP
  2. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #2
    hmm, make sure to escape your data, or try a different import method
     
    ccoonen, Mar 5, 2007 IP
  3. coolwind

    coolwind Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hi,
    I get the same error you are getting. Do you know any easy way to restore a database? I've tried the SSH commands and it doesnt work.
     
    coolwind, Mar 11, 2007 IP