"Filip Sergeys" <[EMAIL PROTECTED]> schrieb am 25.11.2004 16:10:28: > I'am seeking the answer on three hypothetical situation where I need to > recover a database (needed to write out a DRP) > > 1) suppose somebody updates a table with wrong values and that query is > committed. After a few hours the error is spotted. Is it possible to > recover that individual table without stopping the entire database? If > it is not possible while the database is online, how do I recover the > database without losing the latest transaction on other tables; because > if I set back a backup until the time just before the disaster, I lose > all information since then on the other tables > > Maybe two cases must be seen > a) no one changed that table after the update > b) other transactions where done on that table since the update the only way I see: install max-db on a second server. on this second server you recover your database until the point, where this table has been ok. then you can recover your table-data (for example with the loader-tool) into your original database. you don't have to stop your original database. > > 2) same situation, but one or more tables where dropped. same thing Greetings Ulrich Lickert ____________________________________________________ Ulrich Lickert, Universitaetsklinikum Freiburg Klinikrechenzentrum, Agnesenstr. 6-8, D-79106 Freiburg Tel +49-761-270-2265 Fax +49-761-270-2066 E-Mail [EMAIL PROTECTED] WWW: http://www.uniklinik-freiburg.de/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
