Hi,

On Thu, Feb 18, 2010 at 7:45 AM, Colin Campbell
<colin.campb...@ptfs-europe.com> wrote:
> If you have everything in one ibdata file it can be difficult to recover
> space.

Yes, that's why is a good idea to use a separate file for each InnoDB
table; you can enable this by turning on the innodb_file_per_table
option in the MySQL configuration file.  If you're using a single
InnoDB tablespace now, however, making the switch would involve either
dropping and recreating the database from a mysqldump or loading the
data into a new database or a replicate, pointing Koha to it, and
dropping the old database.

Regards,

Galen
-- 
Galen Charlton
gmcha...@gmail.com
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha.org
http://lists.koha.org/mailman/listinfo/koha-devel

Reply via email to