Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Jim Hale on January 18, 2003, 04:54:50 AM

Title: Dropping MySql Databases/Tables...
Post by: Jim Hale on January 18, 2003, 04:54:50 AM

I'm hoping this is an easy question - but I can't even get the RedHat list to pass it thru... :/

When you drop a database or table from MySQL, does it completely remove it, freeing up the space on the HD, or is there something else I need to do to reclaim the space?

Just a general question... :)

Thanks!

Title: Re: Dropping MySql Databases/Tables...
Post by: Michael Herger on January 18, 2003, 11:03:10 PM

It's completely removed. Go to /var/lib/mysql/yourDB/ (replace yourDB with your database's name). There are three files per table: .frm, .myd and .myi. If you drop a table these three files are removed. If you empty it, they're reset to a minimal size.

Michael