updating my.cnf with innodb info causes error

MySQL & MariaDB Other MySQL® Questions
1

Running 5.0.38-Ubuntu_0ubuntu1-log Ubuntu 7.04 distribution

I wanted to change some of the default InnoDB variables to try and improve performance as I am adding indexes to a huge file.

So I stopped the MySQL server.

Added these 2 lines to my.cnf file
innodb_buffer_pool_size = 500M;
innodb_log_file_size = 125M;

Restarted MySQL server

Now when I tried to upload my data using the LOAD DATA INFILE method I got this error

ERROR 1033 (HY000): Incorrect information in file: ‘./database/tablename.frm’

Why is this happening? Any help/ideas very much appreciated.
Cheers
Tom

2

One possible cause I guess is that you’ve changed the InnoDB log file size, and restarted mysql server without removing old the innodb log files so that mysql server could re-create the log files.
If this’s the case, remove innodb log files and try again.

3

Thanks Safari

That was exactly what happened.