We used to have a fair amount of data in InnoDB.
Had a few crashes from power failures at a crappy hosting provider.
Everytime the InnoDB engine seemed to detect the crashes and read up its
logfiles and recover.
I've never tried any manual InnoDB recovery / data extraction. Are there
methods?
Do you know how to test a crash and a rollback?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Do you know how to test a crash and a rollback?
You mean a client app crashing on you?
How about disabling/unplugging the network?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
Upscene Productions
http://www.upscene.com
Hi there,
I am not sure I understood your question correctly. What exactly is it that
you want to test ?
a) the recovery possibility in case of power down
b) the recovery possibility in case of client disconnection (network
interruption, timeout etc.)
c) Recovery possibilities in general