1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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