Stephen Brownlow wrote:
I must second that request, although someone else pointed out that using a LOCK FOR UPDATE would work as well since no processes would be able to touch the database during the lock.You can make backup of the database and then drop the database..When maintenance is necessary, it would be far better to be able to:
Why do you want to do it?
1. turn off one database,
2. use myisamchk, Unix or other applications to adjust it in any way,
3. turn it back on.
As long as the MySQL team thinks thats a safe way to handle things, and is willing to make sure it keeps working that way safely, I'd say we already have a solution though.
Oh yeah, without the words SQL or QUERY, this message would be spam.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
