-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wed, 16 Jun 2004 11:47:49 +0300, Ira Abramov <[EMAIL PROTECTED]> wrote: > > so, does anyone know such a simple howto or even a DTF book from > O'Reiley? "basic MySQL operations for sysadmins" or something..
I have one suggestion (that does not answer your question, sorry). Do binary backup (mysqldump) for disaster recovery (a must), but also do a text backup (SELECT * INTO OUTFILE) of EACH table (of course, you must do this with a script). The second method (each table saved separately) will make it easier to correct human mistakes (which are more common than mechanical errors) which affects only a table or two. If you'll save the text backups, you'll be able to compare tables from different times. Ehud - -- Ehud Karni Tel: +972-3-7966-561 /"\ Mivtach - Simon Fax: +972-3-7966-667 \ / ASCII Ribbon Campaign Insurance agencies (USA) voice mail and X Against HTML Mail http://www.mvs.co.il FAX: 1-815-5509341 / \ GnuPG: 98EA398D <http://www.keyserver.net/> Better Safe Than Sorry -----BEGIN PGP SIGNATURE----- Comment: use http://www.keyserver.net/ to get my key (and others) iD8DBQFA1rVLLFvTvpjqOY0RArIEAJ9ZKpULtSaqBTPo2+gBClakdWzV6QCfTiki 8BtnV3YhTJ1kBidGPvhkscU= =XZly -----END PGP SIGNATURE----- ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
