On Tue, 3 Aug 2004 10:07:25 -0400 , David Seltzer <[EMAIL PROTECTED]> wrote: > Hi all, > > I've been searching the archives & mysql documentation for a while and I > can't seem to find an answer to my question - > > Is there a way to force InnoDB to shrink its filesize? I just dropped a 7GB > table, but it hasn't freed up the disk space and I need it back. From what > I've been reading, a restart will cause this to happen, but I'm in a > production environment, and I'm afraid that InnoDB will take its sweet time > while my users are holding their breath. > > Does anyone have any experience with this?
No, a restart will not shrink it. Currently the only option I can think of is to do a dump and restore, using mysqldump (since innodb hot backup just copies the data file, it won't be of any use in shrinking it). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
