[Libreoffice-bugs] [Bug 128965] Error: Database connection failed when opening. Database has lost ALL information.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128965

--- Comment #13 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to Ronald from comment #12)

> Now back to the problem: whay does this happen and to prevent this?
> 
Problem with the internal HSQLDB is: It will be unzipped when opening the
database And will be wrote back to the file while closing the database. If
there is any problem when closing the database the content of the database-file
wouldn't be complete.

I have written a macro for this and put it in the Base Handbook (German Version
you could get here: https://de.libreoffice.org/get-help/documentation/
If you connect the macro directly to opening of the base-file a backup will be
made automatically.

If you will use Base for professional databases I would prefer a
database-server and connect with Base to the server-database. It could be
HSQLDB, but also something like MariaDB/MySQL or PostgreSQL.

You could also connect to an external HSQLDB without using a server. The
data-file mustn't be zipped when closing the Base-file. Would be a saver
solution than the internal HSQLDB. I have described this also in the Base
Handbook.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191221/b6551ec2/attachment.htm>