Re: how to bring down the mysqlserver without getting an inconsistant db?

not sure. "show tables" is fast, it is just a select from a table in the mysql db. Get the names and issue LOCK on them. But keep the names in a array and unlock them after that. Andrey ----- Original Message ----- From: "andy" <news.letters@gmx.de> To: <php-db@lists.php.net> 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" <ahristov@icygen.com> schrieb im Newsbeitrag > news:02f701c1e177$abd40040$0b01a8c0@ANDreY... > > Get all table names in a db and lock them :"show tables;"; > > > > Andrey > > ----- Original Message ----- > > From: "andy" <news.letters@gmx.de> > > To: <php-db@lists.php.net> > > 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 > >