Problem description: Database / Table deletion, is final with no recovery possible.
Steps to reproduce:
1. .... Create Database
2. .... Create Tables
3. .... Delete Database
Current behavior: All is lost forever including any backup files.
Expected behavior: A Back-up file is created which is not deleted and can be used to recover an accidentally deleted Database or Table.
Operating System: Linux (Other)
Version: 18.104.22.168 release
(In reply to comment #0)
> Current behavior: All is lost forever including any backup files.
Where do you get backup files? I could only create a backup-file, when I copy the database-file and insert it on another place. This could be made also by a macro.
> Expected behavior: A Back-up file is created which is not deleted and can be
> used to recover an accidentally deleted Database or Table.
This is a new feature you wish. It could be a good idea to minimize dataloss. So I set the importance to high and enhancement. The problem isn't only a problem of a specific platform and exists also in the versions of OOo before LO has been created. So I also change Version and platform.
Not a solution for every case, but a way: The following macro will create up to 5 backups in the backup-folder of LO and then will delete the oldest backup. It should be linked to the opening of the database-document:
DIM oPath AS OBJECT
DIM oDoc AS OBJECT
DIM sTitel AS STRING
DIM sUrl_Ziel AS STRING
DIM sUrl_Start AS STRING
DIM i AS INTEGER
DIM k AS INTEGER
oDoc = ThisComponent
sTitel = oDoc.Title
sUrl_Start = oDoc.URL
oPath = createUnoService("com.sun.star.util.PathSettings")
FOR i = 1 TO 6
IF NOT FileExists(oPath.Backup & "/" & i & "_" & sTitel) THEN
IF i > 5 THEN
FOR k = 4 TO 1 STEP -1
IF FileDateTime(oPath.Backup & "/" & k & "_" & sTitel) <= FileDateTime(oPath.Backup & "/" & k+1 & "_" & sTitel) THEN
IF k = 1 THEN
i = k
i = k+1
sUrl_Ziel = oPath.Backup & "/" & i &"_" & sTitel
Adding self to CC if not already on
Changing priority back to 'medium' since the number of duplicates is lower than 5