Sure I could... but i would be able to "MOUNT/UNMOUNT" a database... so i could "myisampack" a db, move to another filesystem... and so on... that feature shouldn't hard to add to a new version of mysql... isn't for you?
-----Messaggio originale----- Da: rich johnson [mailto:[EMAIL PROTECTED] Inviato: marted́ 10 giugno 2003 12.37 A: Davide Campanella; [EMAIL PROTECTED] Oggetto: Re: Offline database? >Is there a way to put a database offline? So doing i could work on it with >myisamchk being sure that mysqld cannot touch the files... and no >corruptions should happen! I have heard of people doing stuff with locking tables so no-one can write to them, flushing them to close the files, then running myisamchk and finally releasing the lock. That solution has always sounded a bit fishy to me, and I would hate having to automate such a process. Why can't you use CHECK TABLE? - Rich _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]