Hi! For the record, I exchanged email with Kip, and it turned out he had forgotten to add the keyword 'set-variable' to the my.cnf line. It should be
set-variable=innodb_log_files_in_group=... Note that the default is 2 if you have not specified this previously in your my.cnf. I read from the 4.0 manual that the latest versions of 4.0.x do not require the extra keyword 'set-variable' any more. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query ----- Original Message ----- From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, December 20, 2002 3:45 AM Subject: /etc/my.cnf does not contain innodb_log_files_in_group. > >Description: > After ugrading from MySQL-Max-3.23.53 to 3.23.54, mysqld failed to start. > > Error message was:/usr/sbin/mysqld-max: unrecognized option `--innodb_log_files_in_group=3'. > > This option required for Innodb Hot backup! > > >How-To-Repeat: > Just upgrade MySQL-Max and try to run /usr/bin/ibbackup > >Fix: > Comment out "innodb_log_files_in_group=3" in my.cnf (still breaks ibbackup). > > >Submitter-Id: <Kipland S. Iles> > >Originator: hostmaster > >Organization: Transcor, Inc > > >MySQL support: none > >Synopsis: innodb_log_files_in_group=3 no longer valid > >Severity: critical: No database backups now > >Priority: high > >Category: mysql > >Class: sw-bug > >Release: mysql-3.23.54 (Official MySQL RPM) > > >Environment: > System: Linux dbs01 2.4.18-14smp #1 SMP Wed Sep 4 12:34:47 EDT 2002 i686 i686 i386 GNU/Linux > Architecture: i686 > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc > GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs > Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redha t-linux --with-system-zlib --enable-__cxa_atexit > Thread model: posix > gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) > Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' '-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' > LIBC: > lrwxrwxrwx 1 root root 14 Aug 19 15:38 /lib/libc.so.6 -> libc-2.2.93.so > -rwxr-xr-x 1 root root 1235468 Sep 5 19:12 /lib/libc-2.2.93.so > -rw-r--r-- 1 root root 2233342 Sep 5 18:59 /usr/lib/libc.a > -rw-r--r-- 1 root root 178 Sep 5 18:50 /usr/lib/libc.so > Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--without-innodb' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-ex ceptions -fno-rtti -mpentium' 'CXX=gcc' > > >MY BACKUP SCRIPT... > > #!/bin/sh > # KSI 20021126 > # Database HotBackup Script > > # INITIALIZATION > > STAMP="date +%Y%m%d~%H:%M:%S" > TIMESTAMP="date +%Y%m%d%H%M%S" > > echo "" > echo "=====================================================" > echo "`$STAMP`: $0 STARTED" > > BIN=/root/bin > ROTATEBU=$BIN/rotatebu > DBHOME=/database/mysql > GTS=$DBHOME/gts > MYSQL=$DBHOME/mysql > HBHOME=/database/hotbackup/etranscor > HBDIR=$HBHOME/`$TIMESTAMP` > IDBDATA=$HBDIR/innodb/idbdatab > IDBLOGS=$HBDIR/innodb/idblogsb > INNODB_CNF=$HBDIR/backup.my.cnf > MDUMPBEFORE=$HBDIR/before-ibbackup.gz > MDUMPAFTER=$HBDIR/after-ibbackup.gz > LDUMPFILE=$HBDIR/etranscor.ldif.gz > MYSQL_CNF=/etc/my.cnf > > # LETS BE SPECIFIC SO WE DONT GET SPOOFED > > alias mdump='/usr/bin/mysqldump -prodeswll' > alias idump='/usr/bin/ibbackup' > alias ldump='/root/ldifs/dump' > alias gzip='/usr/bin/gzip' > alias tar='/bin/tar' > alias rm='/bin/rm' > > # CREATE BACKUP HOME IF IT DOESNT EXIST > > if [ ! -d "$HBHOME" ] > then > echo "`$STAMP`: Creating $HBHOME" > mkdir -p $HBHOME > fi > > # CREATE BACKUP DIRS IF THEY DONT EXIST > # OR WIPE IT OUT > > if [ -d "$HBDIR" ] > then > echo "`$STAMP`: Removing $HBDIR" > rm -r $HBDIR > fi > > echo "`$STAMP`: creating $HBDIR" > mkdir -p $HBDIR > > echo "`$STAMP`: creating $IDBDATA" > mkdir -p $IDBDATA > > echo "`$STAMP`: creating $IDBLOGS" > mkdir -p $IDBLOGS > > # CREATE THE BACKUP INNODB CONF FILE DYNAMICALLY > > echo "`$STAMP`: creating $INNODB_CNF" > cat <<EOF>$INNODB_CNF > > # For Innodb Backups > # > innodb_data_home_dir = $HBDIR/innodb/idbdatab > innodb_data_file_path = ibdata1:1000M:autoextend > innodb_log_group_home_dir = $HBDIR/innodb/idblogsb > innodb_log_arch_dir = $HBDIR/idblogsb > innodb_log_files_in_group = 3 > set-variable = innodb_buffer_pool_size=500M > set-variable = innodb_additional_mem_pool_size=20M > set-variable = innodb_log_file_size=125M > set-variable = innodb_log_buffer_size=25M > innodb_flush_log_at_trx_commit=1 > set-variable = innodb_lock_wait_timeout=50 > EOF > > # DO A MYSQL DATABASE DUMP > > echo "`$STAMP`: Dumping MySQL to $MDUMPBEFORE" > mdump --all-databases | gzip >$MDUMPBEFORE > > echo "`$STAMP`: Dumping INNODB to $IDBDATA" > idump $MYSQL_CNF $INNODB_CNF > > echo "`$STAMP`: Dumping MySQL to $MDUMPAFTER" > mdump --all-databases | gzip >$MDUMPAFTER > > # CREATE TAR's OF MAIN DATABASES > > echo "`$STAMP`: creating tar: $GTS" > tar cv $GTS | gzip >$HBDIR/gts.tgz > > echo "`$STAMP`: creating tar: $MYSQL" > tar cv $MYSQL | gzip >$HBDIR/mysql.tgz > > # TAR UP INNODB > > echo "`$STAMP`: creating tar: $HBDIR/innodb" > tar cv $HBDIR/innodb | gzip >$HBDIR/innodb.tgz > > # GET A SNAPSHOT OF my.cnf > > cp $MYSQL_CNF $HBDIR > > # GET A DUMP OF THE CURRENT LDAP DATABASE FROM THE LDAP MASTER > > echo "`$STAMP`: Dumping LDAP to $LDUMPFILE" > ldump | gzip >$LDUMPFILE > > # REMOVE THE INNODB DIRECTORY > > echo "`$STAMP`: Cleaning up" > rm -r $HBDIR/innodb > > # ROTATE THE BACKUP > > $ROTATEBU > > # DONE > > echo "`$STAMP`: $0 FINISHED" > > >MY BACKUP ROTATION SCRIPT > > #!/bin/sh > # KSI 20021126 > # Database HotBackup Rotation Script > > # INITIALIZATION > > STAMP="date +%Y%m%d~%H:%M:%S" > TIMESTAMP="date +%Y%m%d%H%M%S" > > NOW="$(date +%s)" > let ONEWEEK=604800 > let LASTWEEK=NOW-ONEWEEK > > echo "" > echo "=====================================================" > echo "`$STAMP`: $0 STARTED" > echo "=====================================================" > > HBHOME=/database/hotbackup/etranscor > HBDIR=$HBHOME/`$TIMESTAMP` > > # LETS BE SPECIFIC SO WE DONT GET SPOOFED > > alias rm='/bin/rm' > alias find='/usr/bin/find' > > > echo "$LASTWEEK :LastWeek" > echo "$NOW :Now" > find $HBHOME/* -type d -printf "%T@~%f\n"| > while IFS='~' read MTIME DIR > do > if [ "$((MTIME))" -lt "$((LASTWEEK))" ] > then > echo "$MTIME $DIR will be deleted" > rm -r $HBHOME/$DIR > else > echo "$MTIME $DIR will NOT be deleted" > fi > done > > echo "=====================================================" > echo "`$STAMP`: $0 FINISHED" > echo "=====================================================" > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
