GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

updating my.cnf with innodb info causes error

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • updating my.cnf with innodb info causes error

    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.

    Comment


    • #3
      Thanks Safari

      That was exactly what happened.

      Comment

      Working...
      X