RE: dropping a database to reclaim space

2006-02-22 Thread Robert DiFalco
it to be recreated next time you start MySQL. -Original Message- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 6:48 PM To: mysql@lists.mysql.com Subject: dropping a database to reclaim space Hi. I have a database that is fairly large and I'm doing some testing

Re: dropping a database to reclaim space

2006-02-22 Thread sheeri kritzer
Luke, I believe the 'mysql' database (system) does NOT use InnoDB. The best thing to do would be to change your database to skip-innodb, check that the server is working, and then delete the innodb data and log files. -Sheeri On 2/21/06, Luke Vanderfluit [EMAIL PROTECTED] wrote: Hi. I have

Re: dropping a database to reclaim space

2006-02-22 Thread Heikki Tuuri
and that doesn't show reduced disk space either. I'm doing this on a solaris 9 box. Any input appreciated. Thanks. Kind regards. -- Luke Thread dropping a database to reclaim space - Luke Vanderfluit, February 22 2006 3:48am Re: dropping a database to reclaim space - sheeri kritzer, February 22 2006 6

dropping a database to reclaim space

2006-02-21 Thread Luke Vanderfluit
Hi. I have a database that is fairly large and I'm doing some testing with 2 different mysql packages, one 32-bit, one 64bit, for comparison's sake. Now I've finished with one of the dbs and I want to reclaim the disk space. I've tried deleting a few (large) tables from the database,