Database Repair and Maintenance
Every MySQL administrator hopes to avoid having to deal with corrupted or destroyed database tables. But just hoping won't keep problems from occurring. There are steps you can take to minimize your risks and learn what to do if bad things do happen:
Crash recovery. Should disaster strike in spite of your best efforts, you should know how to repair or restore your tables. Crash recovery should be necessary only rarely, but when it is, it's an unpleasant, high-stress business (especially with the phone ringing and people knocking on the door while you're scrambling to fix things). Nevertheless, you must know how to do it because your users will be quite unhappy otherwise! Be familiar with the table-checking and ...
Get MySQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
