Hello,
We are currently in the process of converting our MyISAM tables to InnoDB to make our tables transaction safe. Unfortunately, I am getting the following error on one of the tables... mysql> alter table SUBSCRIBERS type = InnoDB; ERROR 1114: The table '#sql-fcc_1' is full mysql> What value should I set the following..... Currently, I set it to 512M... set-variable = innodb_buffer_pool_size=512M My SYSTEM runs V4.0.1-alpha and my server has 1GB of RAM. Thanks --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php