Take the 2-minute tour ×  I was importing a database dump -
almost 1GB worth:  mysql -uroot -ppassword < mysqldump.sql  When
I received warnings that the hard drive was almost full. I
panicked and Ctrl-Ced the import. Twice.  Looking at my DB I can
see that the import was canceled. However when I look in
/var/lib/mysql/ I can see ibdata1 is still too big - I guess it
still has all the imported data in it. It's about twice the size
it should be for the data available in the DB.  I ran mysqlcheck
-optimize -A but if anything it made the ibdata1 file larger.
How can I clear this orphaned data out? I have about 100MB left
on the hard drive ...  share|improve this question  1 Answer 1
up vote 1 down vote accepted  This is a known bug in MySQL:
1341. It's been going on for 8 years now. You might want to try
a workaround, posted on StackOverflow:  That ibdata1 isn't
shrinking is a particularly annoying feature of MySQL. The
ibdata1 file can´t actually be shrunk unless you delete all
databases, remove the files and