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
