Re: [Hsqldb-user] Restoring backup data

[Fred T. <fr...@us...>]

If the backups were made after shared, multiple access, then the backups
may have the same problem as the current database.

For a good backup set of this description, the property, modified=no
must be in the .properties file. 

In normal cisrumstances, it is sometimes possible that the data file and
backup file are deleted after the database is opened. This situation is
where the data of all the cached tables have been deleted by the user
prior to shutdown. 

I suppose this is not the case with your database. You can try modifying
the property to modified=yes and try to open.

In the .script file there are some statements such as SET TABLE ....
SOURCE 'value,value'. If the values reported are all -1 for a table,
then the table is not supposed to have any data.

Fred

On Wed, 22 Jul 2009 18:02 +0200, "Christian Beil"
<chr...@we...> wrote:
> Hi all,
> 
> We have a desktop application that uses HSQLDB as a data store. One of 
> our users has accessed the HSQLDB files over Windows shared directories, 
> although the application is not designed for multiple users. Somehow the 
> database files got corrupted.
> Fortunately they made some backups. The backup contains the following 
> files (with approx file sizes):
> backup 25000 KB
> data 131000 KB
> properties 1 KB
> script 236 KB
> 
> When they start the application using these files, it displays valid 
> content. Two additional files are visible in the directory: .lck and 
> log both 1 KB in size.
> 
> After shutting down the application, only two small files remain:
> properties 1 KB
> script 236 KB
> 
> Does someone have any idea what happens here? Why is the data visible in 
> the application, but gone after shutting down?
> Is there a way to restore/repair the data?
> 
> Thanks a lot.
> 
> Christian
> 
> ------------------------------------------------------------------------------
> _______________________________________________
> Hsqldb-user mailing list
> Hsq...@li...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user