I have a SQLite 3 database, it is from the "classic" Windows Skype, which stores all it's conversation history and chat logs, previous conference call/group chats, and more, all in this one database file called "main.db". It is standard SQLite 3, and mine specifically is pretty large as I use it as my main communications program, so something like this happening to me is not really ideal. In the meantime I am using the Windows 10 version which was able to pull my contacts and some recent chat history from the corrupt DB so that works for now.
It has since gotten corrupt, and is unable to be read. I'm not sure what caused it, but I would be randomly signed out and when I tried to log back in again I would get a "database error, please restart" message, and I should have immediately stopped there but I kept signing in and eventually when I logged back in for however many times after it kept kicking me out everything was all messed up, contacts, chat history, everything. It has about 2 years worth of chat logs and other conversation history I'd hate to loose and I have no recent backups of. Skype itself has a built in repair function and it looks like it's repaired the database itself before, but today when it tried to repair the database (which I later found out it was running through every time I logged in after being signed out with the error message) it was "messed up" like I described above.
I contacted their support, they informed me of the main.db SQLite3 file and that is where everything is stored, and that mine must be corrupt and they can't assist me any further. Certain stuff is stored in the "cloud", however that is only up to 30 days worth of calls, chat logs, and everything else. I can't retrieve anything past that (which would be before this summer started).
It left the last unfixed corrupt database file as main.corrupt, so I took this and tried to work with it, Here are the messages I'm getting when trying to read it in various applications, "Database image is malformed", and when trying to do "sqlite3 main.db "PRAGMA integrity_check"" I get several messages looking like this, "Page #####: btreeInitPage() returns error code 11"
Does anyone know of any basic commands, etc I can do to attempt to recover it? I've also searched Google and haven't had much luck. There are programs online that claim they can fix it for like $100, but I'm not entirely sure I want to spend that much money on something that may not work.
I've also tried "$ sqlite3 main.corrupt ".dump" | sqlite3 main_repaired.db" but that hasn't had much success either.
I've been looking into it myself, I am not entirely sure of the format of these databases although it seems others have documented it online as well. There is even a program called "Skyperious" which allows you to load up the database and read it, however I just get the usual "Database image is malformed", and I tried using it's own repair function but haven't had much luck, I'll keep trying though
