Asif Iqbal <[EMAIL PROTECTED]> wrote: > I already have mysql 4.0.13 running with all InnoDB tables. I am trying to use > my-huge.cnf since I have 4 gig RAM with 4 x 450 Mhz processes > > In my MySQL data directory I have two ib_logfile files > > -rw-rw---- 1 mysql mysql 5242880 Aug 26 01:55 ib_logfile0 > -rw-rw---- 1 mysql mysql 5242880 Aug 25 19:03 ib_logfile1 > > Now if I add this line in my cnf file (as recommended by my-huge.cnf) > > innodb_log_file_size = 100M > > I get the following error > > InnoDB: Error: log file /usr/local/mysql/data/ib_logfile0 is of different size 0 > 5242880 bytes > InnoDB: than specified in the .cnf file 0 104857600 bytes! > 030826 1:42:15 Can't init databases > 030826 1:42:15 Aborting > > So as a workaround I commented the innodb_log_file_size. But I really don't like > this solution. Is there a better solution ?
Move old log files to the safe place. Edit my.cnf and then start MySQL server. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
