InnoDB Error ib_logfile0 of different size

[Asif Iqbal]

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 ?

Thanks

--
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/loo...rch=0x8B686E08
There's no place like 127.0.0.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw