List:General Discussion« Previous MessageNext Message »
From:Jungsu Heo Date:February 6 2003 7:52am
Subject:Re: locking tables , mysql 3.23.41
View as plain text  
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" <K.Franz@stripped>
To: <mysql@stripped>
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 <mysql-thread131672@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-jsheo=simplexi.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


Thread
locking tables , mysql 3.23.41Fa. PostDirekt MA Franz5 Feb
  • Re: locking tables , mysql 3.23.41Jungsu Heo6 Feb