On Fri, Feb 11, 2005 at 11:36:39AM -0700, Risto Treksler wrote: > backing up the database is very important, > but using the above command it is needlessly difficult to roll it back > > I use d > > mysqldump --opt --allow-keywords --all-databases -uroot > mysqldump-0.16.sql > gzip mysqldump-0.16.sql
Alas, this can be needlessly difficult in another direction. I recommend against using "--all-databases" -- at least some, and possibly many, people are using the MySQL install on their box for other things; you don't want *that* stuff to roll back at the same time. Cheers, -- jra -- Jay R. Ashworth [EMAIL PROTECTED] Designer Baylink RFC 2100 Ashworth & Associates The Things I Think '87 e24 St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274 If you can read this... thank a system adminstrator. Or two. --me
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
