MySQL Database Restore Problem (Index)

Discussion in 'MySQL' started by Blaster, Apr 6, 2007.

  1. #1
    Currently I have a MySQL database (Version 5.0.26) that contains a very large table (MYISAM). The problem I’m having is when I try to restore the database backup (via MYSQLDUMP) it hangs up on the index of this table and reports a failure (Corrupted restore).
    My question is this...Is there a way to perform a full backup on this table and not include the index? Worse case, I figure I could just backup the data and rebuild the index post restore.
     
    Blaster, Apr 6, 2007 IP
  2. briansol

    briansol Well-Known Member

    Messages:
    221
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    110
    #2
    i think
    --disable-keys
    is what you're looking for....
     
    briansol, Apr 10, 2007 IP