Hi Andreas, it worked perfectly for me!! :-) I was able to rescue every data-byte out of the damaged database with your suggested solution. Thank you very, very much. That saved my day - oh no - week. :-) Lessons learned: NEVER use a different driver version to open an existing H2 DB! (application uses .196, but I gave .200 to Squirrel - I'm so stupid)
Thanks again, problem is SOLVED. [email protected] schrieb am Mittwoch, 24. Februar 2021 um 01:30:00 UTC+1: > > > On Tue, 2021-02-23 at 10:09 -0800, Thomas Frick wrote: > > Can anyone here please give me a hint on how to repair the DB and rescue > all the data in it (if it's possible)? > > > Good Morning Thomas. > > http://www.h2database.com/javadoc/org/h2/tools/Recover.html > > (Although this has never worked for me.) > > Please note: You should avoid opening a H2 database (e.g. 1.4.199) with > any different H2 driver (e.g. 1.4.200). > Instead you are supposed to extract to SQL script and create the DB afresh > from script. > > http://www.h2database.com/javadoc/org/h2/tools/Script.html > http://www.h2database.com/javadoc/org/h2/tools/RunScript.html > > Good luck and best regards > Andreas > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/d47888d7-fdac-4c61-b4c2-8be0441e2cf7n%40googlegroups.com.
