Topic: Dropping MySql Databases/Tables...

[Jim Hale]

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!

[Michael Herger]

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