--- gerald_clark <[EMAIL PROTECTED]> wrote: > A UPS is of little use if you dont have software > installed to shut the > computer > down when AC power is lost.
Indeed :-). The problem was the eletrical board. This kind of problems shouldn't happen but sh*t happens :-))). Anyway, I read more carefully the manual of Innodb and I found the answers in the chapter 6. Seems that Hot Backup it's a nice tool and we have the option of recover from the logfiles too. Best regards. > > Pedro Rocadas wrote: > > >Greetings. > > > >Two days ago, during our first sql tests using > mysql > >in Innodb, we suffer an energy fault during a > storm. > >Even the UPS couldn't help :-). After energy back, > we > >realise that our database crashed and suffer > >corruption damages. I read some chapters from the > >manual but they are not so clear in answering my > >problems. My question is: what can I do to prevent > >damages in the database or in other words, is there > >some kind of temporary data to recover? Our > >application needs data up-to-date so backup is not > >sufficient. Thanks in advance for any help. > > > >__________________________________________________ > >Do you Yahoo!? > >HotJobs - Search new jobs daily now > >http://hotjobs.yahoo.com/ > > > >--------------------------------------------------------------------- > >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 > > > > > > > > > > __________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ --------------------------------------------------------------------- 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