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.