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

Reply via email to