On a single Linux box w/mysql 3.23.52 I have about a dozen children of mysqld running and there are about 20 databases live in the environment. I want to take one of the databases offline but leave mysqld running with the other db's - without interrupting service.
I want mysqld to gracefully refresh itself to the fact that the database is "offline" but not require a restart. I have the luxury of time if that's part of the solution.
If I get to this point, I also want to physically move the files out of the mysqld file hierarchy, which I sort of presume would be allowed if I've now convinced mysqld to ignore the offline db. So, on this point, I'm looking for the "okey-dokey" to move the files - I know how.
THANKS!
I want mysqld to gracefully refresh itself to the fact that the database is "offline" but not require a restart. I have the luxury of time if that's part of the solution.
If I get to this point, I also want to physically move the files out of the mysqld file hierarchy, which I sort of presume would be allowed if I've now convinced mysqld to ignore the offline db. So, on this point, I'm looking for the "okey-dokey" to move the files - I know how.
THANKS!