Have in mind this : LOCK TABLES locks tables for the current thread. UNLOCK TABLES releases any locks held by the current thread. All tables that are locked by the current thread are automatically unlocked when the thread issues another LOCK TABLES, or when the connection to the server is closed.
Andrey ----- Original Message ----- From: "andy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 7:47 PM Subject: Re: [PHP-DB] how to bring down the mysqlserver without getting an inconsistant db? > what if I have 50 tables?? > > > "Andrey Hristov" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > 02f701c1e177$abd40040$0b01a8c0@ANDreY">news:02f701c1e177$abd40040$0b01a8c0@ANDreY... > > Get all table names in a db and lock them :"show tables;"; > > > > Andrey > > ----- Original Message ----- > > From: "andy" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Thursday, April 11, 2002 7:37 PM > > Subject: [PHP-DB] how to bring down the mysqlserver without getting an > inconsistant db? > > > > > > > Hi there, > > > > > > I am wondering what would be the best way to update a db. I would like > to > > > bring down the server, but I am afraid to get > > > an inconsistant state of data. What if someone is just registering on > > > another db? Is there a way to flush and lock the whole db not just some > > > tables? > > > > > > Thanx, > > > > > > Andy > > > > > > PS: what would be the best way to exchange data on a running server? For > > > example... a db containing geodata should be updated, but the user db > should > > > be running ok > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
