Encounter the following error in MyCC: [root@localhost:3306]ERROR 1005: Can't create table '.\abc\def.frm' (errno 121)
I'm using MySQL 3.23.49 and Win98se. The statement I used work on the default MYISAM table and DBD table and I did changed the TYPE=InnoDB in the CREATE statement. The following is part of the my.ini settings: [mysqld] innodb_data_home_dir=c:\ibdata innodb_data_file_path=ibdata1:50M set-variable=innodb_buffer_pool_size=40M set-variable=innodb_additional_mem_pool_size=5M innodb_log_group_home_dir=c:\iblogs innodb_log_arch_dir=c:\iblogs innodb_log_archive=0 set-variable=innodb_log_files_in_group=3 set-variable=innodb_log_file_size=5M set-variable=innodb_log_buffer_size=4M innodb_flush_log_at_trx_commit=1 set-variable=innodb_file_io_threads=4 set-variable=innodb_lock_wait_timeout=50 Thank you __________________________________________________ Do You Yahoo!? Yahoo! Messenger - Instant Messaging, Instant Gratification. (Now with new emoticons!) http://messenger.yahoo.com.sg/ --------------------------------------------------------------------- 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