I had to do some disk space recovery mysql last month... I have backed up some of the raw .MYI, .MYD files and deleted them from the data directory. Running 5.0.18, I had to shut down mysql and restart before it freed up the space.
> -----Original Message----- > From: Dan Nelson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 21, 2006 3:58 PM > To: luiz Rafael > Cc: mysql@lists.mysql.com > Subject: Re: reclaim disk space > > In the last episode (Jun 21), luiz Rafael said: > > how to reclain the disk space used by an table that was dropped? > > For most storage engines, each table is in its own file so a dropped > table immediately returns space back to the OS. For InnoDB in > tablespace mode (i.e. innodb_file_per_table is unset), you will have to > back up and drop all your InnoDB tables, delete the tablespace files, > and reload the tables. > > http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html > http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html > > -- > Dan Nelson > [EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
