Hi, I’m using a desktop version and today suddenly it says I have corrupted database. I always save my database everyday to my gdrive and when i try to restore from gdrive, even that manager says corrupted. I have read about using sqllite3 etc in this forum, but i have limited knowledge on using it. Can anyone please be kind enough to guide me on restoring my database please? I’m stressed out as this is a very important database for my business. Thank you in advance.
What version of Manager are you using?
Thanks for the reply. I’m not sure my previous version, but i’ve updated to the latest version hoping that it’ll solve my corrupted database, but it didnt. I sometimes update my manager though, so im not sure which my version was before i updated today.
Regards,
Dennis S
Do you have multiple backups on Gdrive?
If so, you will gave to try to import them to find a non-corrupted version
Do you have a backup or backups other than on drive eg USB stick?
Yes, i have an old backup which i tried to open with the latest manager version and its fine, although thats a months old backup.
My only backups are only stored on gdrive.
You can’t just copy a sqlite database that’s in use, right? Use a command like this:
sqlite3 original.sqlite ".backup 'backup_file.sqlite'"
and then copy the backup file. (Or use the command to create a backup file directly on your backup device.)