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 accessing the data files directly and
indirectly using command line and/or GUI tools.
In case a) mysql would recover the data files itself in most cases next time
when the server is started as long as the logfiles, datafiles, config files
are all there in the original positions (talking about InnoDB).
b) If the network connection times out or client is diconnected than all
executed commands since the last commit,begin gets rolled back (will not be
c) If the Innodb files are damaged so that the mysql server does not startup
than no client tool (command line or GUI) that uses the indirect access
method can access any data.
I know that there are tools in the mysql package which access and repair
(My)ISAM tables directly (server doesnt need to run), but that isnt true for
the InnoDB tables I believe. I am not sure if InnoDB Hotbackup can directly
access the InnoDB tables.
What I know is that there will be a book coming up in February from Paul
Dubois (Certification Study Guide) which is already described on Amazon.
When it comes out I believe that it will be the best book on the market so
far, answering many of those and similar questions. I had the honour to
review one of those preprints, all I can say so far is "Very impressive", you
will see for yourself..
On Friday 14 November 2003 00:58, nm wrote:
> Do you know how to test a crash and a rollback?