Oh. OK. Didn't know that. Thanks. j----- k-----
On Saturday 16 February 2002 22:26, Jeremy Zawodny wrote: > On Sat, Feb 16, 2002 at 03:56:42PM -0900, Joshua J.Kugler wrote: > > In that case, i would highly recommend using mysqldump to backup > > your databases. Simply compressing the actual DB's could give you > > tables in inconsistent states, UNLESS you first shut down your DB > > server, then run the backup. > > Not true at all. Try this: > > FLUSH TABLES WITH READ LOCK > <back stuff up> > UNLOCK TABLES > > It's safe and keeps the server on-line. > > Jeremy -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
