another trick that might work is just to deny access to everyone to the database. if no one has access to it, then its as good as gone.
i don't know if MySQL would allow just grant blah on *.* to user; revoke all on disabled_db.* from user; and alot of it depends on how the security is setup and possibly why you want just that database temporaraly gone. On Thursday 05 December 2002 8:05, you wrote: > Richardson, > Thursday, December 05, 2002, 12:32:27 AM, you wrote: > > RDE> On a single Linux box w/mysql 3.23.52 I have mysqld running and there > are RDE> about 20 databases live in the environment. I want to take one of > the RDE> databases offline but leave mysqld running with the other db's - > without RDE> interrupting service. > > RDE> I want mysqld to gracefully refresh itself that the database is > "offline" RDE> and not require a restart. I have the luxury of time if > that's helpful to RDE> the solution. > > RDE> How do I "disable" a database in a running server and leave the rest > of the RDE> db's in production? > > What do you mean "disable database"? > You can't "turn off" the database.. > You can make backup of the database and then drop the database.. > Why do you want to do it? -- mysql, sql, query --------------------------------------------------------------------- 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
