Re: shutdown database but not mysqld

2006-11-22 Thread Philip Mather
Kieran, Just make a backup of the database to a file using mysqldump and then drop the database. If you need to recreate it again in the future, you can use the mysqldump backup file. Oh indeed, but if you got a "x"GB database that's not exactly going to be quick. I'm thinking of instead of sl

Re: shutdown database but not mysqld

2006-11-22 Thread Kieran Kelleher
Just make a backup of the database to a file using mysqldump and then drop the database. If you need to recreate it again in the future, you can use the mysqldump backup file. On Nov 21, 2006, at 9:28 PM, Alfred Mak wrote: Can I shutdown one of the databases in MySQL but not the whole mysq

Re: shutdown database but not mysqld

2006-11-22 Thread Philip Mather
Dan, In the last episode (Nov 22), Alfred Mak said: Can I shutdown one of the databases in MySQL but not the whole mysqld process (i.e. keeping the other databases still running) ? "shutdown" would be the wrong word then :) How about revoking permissions (either at the mysql or the fi

Re: shutdown database but not mysqld

2006-11-21 Thread Dan Nelson
In the last episode (Nov 22), Alfred Mak said: > Can I shutdown one of the databases in MySQL but not the whole mysqld > process (i.e. keeping the other databases still running) ? "shutdown" would be the wrong word then :) How about revoking permissions (either at the mysql or the filesystem leve