Stephen Brownlow wrote:
You can make backup of the database and then drop the database..
Why do you want to do it?
When maintenance is necessary, it would be far better to be able to:
1. turn off one database,
2. use myisamchk, Unix or other applications to adjust it in any way,
3. turn it
At 17:53 +1100 12/11/02, Stephen Brownlow wrote:
Hello Paul,
I am only lobbying, not demanding.
Sorry. I wasn't trying to imply that you were demanding.
It's just that experience shows that feature implementation
always seems easy to the people who aren't doing the work. :-)
Paul Dubois wro
Hello Paul,
I am only lobbying, not demanding.
Paul Dubois wrote:
> Mmm, how do you know how much effort it would be?
> Have you implemented it?
Ok. IMHO it would be relatively easy for MySQL to implement, judging by my
experience dealing with Monty and his source code (specifically, the myisam
At 13:23 +1100 12/11/02, Stephen Brownlow wrote:
"Egor Egorov" <[EMAIL PROTECTED]> wrote on December 05, 2002:
What do you mean "disable database"?
Ask the MySQL server to Flush it, then not access its tables until further
notice.
You can't "turn off" the database..
Can this please be wr
"Egor Egorov" <[EMAIL PROTECTED]> wrote on December 05, 2002:
>
> What do you mean "disable database"?
Ask the MySQL server to Flush it, then not access its tables until further
notice.
> You can't "turn off" the database..
Can this please be written? It offers big benefits for little effort.
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 a
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
R
On Wed, 2002-12-04 at 22:32, Richardson, David E (MVC Corporation)
wrote:
> On a single Linux box w/mysql 3.23.52 I have 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
>
On a single Linux box w/mysql 3.23.52 I have 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 that the databa
