I'll investigate it, but not sure on what I'd be looking for.
The backup files are dramatically different in size from 2nd to 3rd of July so I'm guessing it'd be quite a large difference, or a lot of missing data.
I didn't miss any data in the initial sync since the live database wasn't problematic. I was using all areas of eGW that usually do, without problem. I only discovered the corruption upon restore.
When restoring, eGW does a backup at that point automatically.....so after checking all the previous nights backups, I went back to this original one... which supposedly represented the data at the point it was working OK when live. It was corrupted as well.
ralfbecker wrote:
The backup is a collection of csv files, have you looked into it?
As it is line based, you should be able to use diff two (unpacked) files.