hello. You can read lock whole database's tables like this :
FLUSH TABLES WITH READ LOCK ; and unlock with UNLOCK TABLES ; ----- Original Message ----- From: "Franz, Fa. PostDirekt MA" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 10:35 PM Subject: locking tables , mysql 3.23.41 > Dear Ladies and Gentlemen, > > in order to backup databases or better the whole server file-based , I'd > like > to know , if there is a way to get a read-Lock for all tables in a database > or even better for all tables in all databases. > Something like: > > LOCK TABLES <db_name>.% READ; > > which I tried cause I'm fooolish but it didn't work :o) > > If not , is there a nice tool (best would be command-line) to > do a full online-backup of all data on a server. > > Linux 2.4.10 , mysql 3.23.41 > > If I missed anything in the docs , just tell me where , please. > > Klaus > > > Topaktuelle Consumer-Adressen anmieten www.consumeradressen.de > > > Diese Mail ist von: > Deutsche Post Direkt GmbH > Beleglese Center Mannheim > > Klaus Franz > Manager Abgleichsysteme > > Willy-Brandt-Platz 13 Tel. 06 21.129 56 436 > 68161 Mannheim > > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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