At 11:48 +1000 5/3/05, Daniel Kasak wrote:
Number of processes running now: 0
050502 20:31:26 mysqld restarted
050502 20:31:27 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 301734057
InnoDB: Doing recovery: scanned up to log sequence number 0 301734057
InnoDB: Last MySQL binlog file position 0 2049456, file name
./screamer-bin.021
050502 20:31:27 InnoDB: Flushing modified pages from the buffer pool...
050502 20:31:27 InnoDB: Started
/usr/sbin/mysqld: ready for connections.
Version: '4.0.24-log' socket: '/var/run/mysqld/mysqld.sock' port:
3306 Gentoo Linux mysql-4.0.24
A mysqld process already exists at Mon May 2 20:31:58 EST 2005
My 'backup' ( basically shutdown, truncate query log, start again )
script looks like:
---
for I in database_1 database_2 database_3
do
mysqldump --opt $I > $I.sql -psome_password
done
/etc/init.d/mysql stop
sleep 30
echo "" > /var/log/mysql/mysql.log
/etc/init.d/mysql start
---
There would have been nothing else happening at the time of the backup -
everyone was at home.
Whenever I see stuff in the logs like the above, I start to worry.
Should I 'trust' everything is OK, or dump, restore from a backup, and
process the transaction log?
You can worry if you like. :-)
But "InnoDB: Started" means that InnoDB successfully performed its autorecovery
procedure. Any transactions that had committed by the time of the crash
will be intact. Transactions that were in process and not committed will have
been undone. The transaction log (by which I assume you mean the binary
log?) won't have any extra information, because transactions aren't written
to it until they commit.
The preceding comments apply to InnoDB, of course. If you're concerned
about tables for other storage engines, it might be a different question.
For MyISAM, I recommend starting the server with --myisam-recover=BACKUP,FORCE.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
