Luke,
if you do not have ANY valuable InnoDB tables in the installation, you can
simply delete the ibdata files and ib_logfiles. Be very careful if you have
several MySQL instances in the same computer.
As Sheeri wrote, MySQL's system tables 'user.MYD' etc. are MyISAM tables in
the 'mysql' database directory. They are not InnoDB type.
In the future, you may want to put the option:
innodb_file_per_table
to your my.cnf. Then InnoDB tables are stored in .ibd files in individual
database directories, and dropping those tables does free the disk space to
the operating system. The ibdata files never shrink.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
........................
Hi.
I have a database that is fairly large and I'm doing some testing with 2
different mysql packages, one 32-bit, one 64bit, for comparison's sake.
Now I've finished with one of the dbs and I want to reclaim the disk space.
I've tried deleting a few (large) tables from the database, thinking
this would free up space, however the mysql/var/ibdata1 file doesn't
change in size.
How can I get rid of a table or even complete database to reclaim disk
space?
I don't really want to delete the ibdata1 file, because that will also
delete the system database right?
I've already tried drop database and that doesn't show reduced disk
space either.
I'm doing this on a solaris 9 box.
Any input appreciated.
Thanks.
Kind regards.
--
Luke
Thread
dropping a database to reclaim space - Luke Vanderfluit, February 22 2006
3:48am
Re: dropping a database to reclaim space - sheeri kritzer, February 22 2006
6:32pm
RE: dropping a database to reclaim space - Robert DiFalco, February 22 2006
5:14pm
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]