innodb file won't shrink

[Steve]

I'm using INNODB with mysql 4.0.12 and a single data file:

innodb_data_file_path = ibdata1:10M:autoextend

My database has grown out of hand though and I am almost out of disk
space:

df:
/dev/sdb1 35859376 34878228 981148 98% /

ls -l:
-rw-rw---- 1 mysql mysql 35406217216 Jul 8 21:00 ibdata1

I have deleted a large portion of the database but the file size has
not shrunk. I understand that it has autoextended to this size but am
hoping that there is some command/utility that can shrink it down or
take off extents since I really need some disk space back. Am I off
base? Does anything like this exist?

thanks,

-Steve

[Steve]

I found the following thread:

http://groups.google.com/groups?thre...ie.NCTU.edu.tw

That was from 2001 and talks about the potential for INNODB tools...
does anyone know if any work has been made on those? I just can't
believe that there's no real way for me to make this file smaller when
the space is no longer needed/used... the suggested -> dump the
database and then recreate it just won't since I have a 34+GB db and
no more space on my drive?

Anyone? Please!

-Steve

[sjpapa]

In order to shrink a MySQL database look at:
http://dev.mysql.com/doc/mysql/en/ad...-removing.html

buy another disk to add space and go back to the url above.