From: Ehud Karni (ehud_at_nonexisting.hamakor.org.il)
Date: Mon 21 Jun 2004 - 13:15:40 IDT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wed, 16 Jun 2004 11:47:49 +0300, Ira Abramov <Lists-Linux-IL_at_ira.abramov.org> 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 linux-il-request_at_linux.org.il with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail linux-il-request_at_linux.org.il
This archive was generated by hypermail 2.1.7 : Mon 21 Jun 2004 - 13:29:39 IDT