I use SQLite for websites I create and manage for my clients (I am a web developer). They are very small and straightforward databases.
This is now happened twice, so it is pretty clear that it wasn't a fluke. This last one was a clear set of steps that then corrupted the database:
1. Open the database in SQLite3 by linux command line
2. Make a mistake in the data
3. Ask Git to restore the released version of the file (this is reaching out to GitHub for the copy)
4. Open the restored version, and file is corrupt
I then struggle to get it back in order, nothing I do in git fixes it. I can luckily grab it from the live website (no updates there) and all is well.
My two questions:
1. Is there something I can do differently while getting the file from the git repository to revert, it is not clear to me why git would corrupt the file
2. Is there something I can do that is easier to restore the file other than get the copy from the live website
Asked by Katie
(121 rep)
Apr 8, 2020, 03:20 PM
Last activity: Sep 30, 2022, 04:05 AM
Last activity: Sep 30, 2022, 04:05 AM