On Tue, 26 Aug 2003, Victoria Reznichenko wrote: > 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. >
If I move the old log in a safe place and use innodb_log_file_size = 100M, this is what I get 030826 01:40:38 mysqld started 030826 1:40:39 InnoDB: Log file /usr/local/mysql/data/ib_logfile0 did not exist: new to be created InnoDB: Setting log file /usr/local/mysql/data/ib_logfile0 size to 100 MB InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 030826 1:40:47 InnoDB: Log file /usr/local/mysql/data/ib_logfile1 did not exist: new to be created InnoDB: Setting log file /usr/local/mysql/data/ib_logfile1 size to 100 MB InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 InnoDB: Cannot initialize created log files because InnoDB: data files were not in sync with each other InnoDB: or the data files are corrupt. 030826 1:40:54 Can't init databases 030826 1:40:54 Aborting > > -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=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/[EMAIL PROTECTED]