On Mon, Jun 21, 2004 at 01:15:40PM +0300, Ehud Karni wrote: > 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).
Why do you call it "binary"? the mysqldump files are simply a series of mysql instructions to restore the data (instructions to create the tables and fill in the data : create table, insert) > > 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. As I have already edited mysql dump on several occasions, I can tell that it is not that difficult. BTW: you can use mysqldump to dump tables separatly. > > If you'll save the text backups, you'll be able to compare tables > from different times. But you may lose some information due to special characters and such. -- Tzafrir Cohen +---------------------------+ http://www.technion.ac.il/~tzafrir/ |vim is a mutt's best friend| mailto:[EMAIL PROTECTED] +---------------------------+ ================================================================= 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]
