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 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 applied) 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? -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
