Breaking Eggs And Making Omelettes

Topics On Multimedia Technology and Reverse Engineering


Archives:

MySQL Disaster Recovery Works

April 25th, 2006 by Multimedia Mike

I just want to briefly recognize MySQL for its resilience and robustness. Even in the event that a table gets corrupted, as happened today with the tables driving the MultimediaWiki, ‘CHECK TABLE’ and ‘REPAIR TABLE’ can diagnose and fix the problem and have your MySQL-backed application up and running in short order. Of course, I also have an automated script backing up the database tables off-site, every night, just for good measure.


MySQL Logo

I just want any current or future contributors to be secure in the knowledge that the data is safe.

Posted in General | 2 Comments »

2 Responses

  1. Jim Leonard Says:

    As a PostgreSQL snob, I have to point out that, had you been using PostgreSQL, your data most likely would not have gotten corrupted in the first place. :-) (ducking)

  2. Multimedia Mike Says:

    Okay, so you want to start something… :)

    My “Hello World” test programs never, ever have any data integrity issues either… because, like a certain database I could name, they don’t do anything useful!