Re: 1266 creating innodb tables

2005-11-12 Thread P. Evans
Much thanks, that did the trick. Pierre Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote: P. Evans wrote: > skip-innodb is commented out,thats why its not in the options I sent > previously. > The logs are showing something peculiar - > InnoDB: Error: log file ./ib_logfile0 is of different si

Re: 1266 creating innodb tables

2005-11-11 Thread Jasper Bryant-Greene
P. Evans wrote: skip-innodb is commented out,thats why its not in the options I sent previously. The logs are showing something peculiar - InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 268435456 bytes! ls shows

Re: 1266 creating innodb tables

2005-11-11 Thread P. Evans
skip-innodb is commented out,thats why its not in the options I sent previously. The logs are showing something peculiar - InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 268435456 bytes! ls shows : drwxr-x--- 2

Re: 1266 creating innodb tables

2005-11-10 Thread Gleb Paharenko
Hello. > Anywhere else I can check for that ? Send the output of 'show variables'. I'm especially interested in version, and have_innodb. Are there any lines in the error log similar to "InnoDB: Started"? BTW, options to MySQL Server could be passed in several different ways: http://dev

Re: 1266 creating innodb tables

2005-11-10 Thread Jasper Bryant-Greene
P. Evans wrote: Shawn, as far as I can tell, no. Here's all my innodb options set in my.cnf : Well, it's easy to check: grep skip-innodb my.cnf Is there anything interesting in the logs, maybe on MySQL startup? Jasper -- MySQL General Mailing List For list archives: http://lists

Re: 1266 creating innodb tables

2005-11-10 Thread P. Evans
Shawn, as far as I can tell, no. Here's all my innodb options set in my.cnf : innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 4G innodb_data_file_path = ibdata1:10M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 inno

Re: 1266 creating innodb tables

2005-11-10 Thread SGreen
Is your server configured with "skip-innodb" ? It's an option that turns off support to that engine forcing it to elect a different method of storage. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "P. Evans" <[EMAIL PROTECTED]> wrote on 11/10/2005 10:10:44 AM: > Here's a

Re: 1266 creating innodb tables

2005-11-10 Thread P. Evans
Here's an example : mysql> create table petest (col1 integer,col2 char(5)) engine=innodb; Query OK, 0 rows affected, 1 warning (0.07 sec) mysql> show warnings -> ; +-+--++ | Level | Code | Message

Re: 1266 creating innodb tables

2005-11-09 Thread Jasper Bryant-Greene
P. Evans wrote: Whenever I try to create a table using innodb, i get a 1266 warning that the table has been created with myisam instead. I receive the error both at the mysql command line and using the mysql query browser. Can you please show us the CREATE TABLE command that you are using?

1266 creating innodb tables

2005-11-09 Thread P. Evans
Whenever I try to create a table using innodb, i get a 1266 warning that the table has been created with myisam instead. I receive the error both at the mysql command line and using the mysql query browser. I've also tried alterring the table to change the engine , which says it complet