Any way to ignore SQL errors in a .sql file when restoring to database using bigdump?

Discussion in 'MySQL' started by BMR777, Nov 26, 2008.

0
  1. #1
    Hello All,

    I'm trying to restore a 500+ MB SQL database using BigDump, however it keeps getting caught up on many SQL errors in the .sql file I wish to restore and thus never finishes the database import. Anyone know of a way that I can either force bigdump to ignore SQL syntax errors or set something on the database / PHPMyAdmin so that I can run SQL queries on the DB regardless of the correctness of the syntax / ignore syntax errors?

    Any help would be much appreciated. :)

    BMR777
     
    BMR777, Nov 26, 2008 IP
  2. nirajkum

    nirajkum Active Member

    Messages:
    815
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    58
    #2
    I would suggest to export schema first then export data of table one by one . This way you could ignore the error
     
    nirajkum, Dec 1, 2008 IP
  3. gordonrp

    gordonrp Peon

    Messages:
    76
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    gordonrp, Dec 1, 2008 IP
  4. BMR777

    BMR777 Well-Known Member

    Messages:
    145
    Likes Received:
    8
    Best Answers:
    1
    Trophy Points:
    140
    #4
    Thanks, gordonrp. Yep, it's MySQL. Thanks for the tip. :)

    Brandon
     
    BMR777, Dec 1, 2008 IP