>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-redhat-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'
CXXFLAGS='-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-exceptions -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
