On Tue, 26 Aug 2003, Victoria Reznichenko wrote:
> Asif Iqbal <iqbala@stripped> 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
