Problems with base from time to time

Discuss the database features
Post Reply
Atanas
Posts: 1
Joined: Wed Dec 23, 2020 11:17 am

Problems with base from time to time

Post by Atanas »

Hi ,

About 9 years ago I created one split database for my small company as a temporary solution - with HSQL 1.8, LibreOffice 3.3.4 and Dropbox as a backup solution. 9 years later I am still using it :) without updates in the backend (because everything was working fine) .

However, I encounter problems recently - dropbox, for some reason, from time to time deletes my "mydb.data" and replaces the content of "mydb.script" with just
"CREATE SCHEMA PUBLIC AUTHORIZATION DBA
SET WRITE_DELAY 10 "

(also - it renames the file to mydb.script.new )

Currently my solution is to restore the files from yesterday, but sometimes this is not enough and I have to restore the database from 2 days ago (and this deletes the data from yesterday, which is quite annoying).

Any ideas what is wrong and how to fix it ?
LibreOffice 3.3.4 on Windows 10
Post Reply