In Options/Path Backup set to "C:\users\empadmin\AppData\Roaming\LibreOffice\4\user\backup
Options/- Load/Save - General Always create Backup copy
Split database folder located in C:\users\empadmin\download\database which contains the following files
mydb.data, mydb.properties,mydb.script,hsqldb.jar and sqltool.jar
I changed the path in Options/Path for the backup to the above split database location but no success. Also tried to manually copy mydbdata into the split database folder as as mydb.bak. That works, but the next time I run the base program mydb.bak is no longer in the folder.
When I look at the original backup folder for Options\Path I see some old SplitDatabase backup files, but no new ones containing the current data.
Not 100% sure about everything discussed in the question.
When you split your database, you changed the rules. When you set up for backup, Base saves a copy of yourDBname.ods as yourDBname.bak in the folder indicated by Backup Paths in Options. Since you split the data out of the .ods file, it is no longer backed up by LO.
You should never place a backup in the same location as the original - FOR ANYTHING! If one goes, so does the other. You need to make backups of the entire folder periodically and place it elsewhere such as on a removable HD or CD or a backup of the entire disk (do this at least monthly or more if a lot of changes in system or data). Only takes a short time compared to recovering manually.
By changing the Backups path, all backups (Base, Writer, Calc, etc) will go to this new location. Not a good idea since this is a specific DB folder.
With a split DB the backups are manual (except .ods which is only a piece of the puzzle).
Edit
.odb files are NOT backed up by LO regardless of the setting. All Base files should be backed up manually by the user.
Are you saying that with a split database there is no option to automatically create a backup every time the file is changed? Should I also backup .properties and .script or just backup the complete folder to another location each time? What exactly happens when something happens to the database and you get the message that it is being recovered? Is there an explanation somewhere in the documentation for this recovery process?
Sorry, I see you said to make a backup of entire folder in your answer. I’m more than a little gun shy about data loss since I experienced problems previously when my database was embedded. Mainly I want to be sure that when the backup is created it is not already corrupted. Ideally would like to save it in a cloud server.
Sorry about being a bit harsh in my answer, but few realize the importance until there is a problem. Was part of my job in Data Center. Usually a LO file being recovered is because not closing properly - did this many times playing with macros and always recovered properly. There is no doc (to my knowledge) on this process. Been using a split DB (fair size) for 18 mos now & no problems. Main DB though is MySQL. Finally, Yes - backup the entire folder. My backups have always worked.