Corrupt db, using the posted method to fix results in a zero byte file

[dunewarrior]

@dunewarrior said:
Figured it out. apparently SQLITE adds a ROLLBACK to the sql dump now IF there is a fault encountered during the dump process, which there is. SO the FAQ needs updated and the ROLLBACK in the dump file needs changed into a COMMIT. i will try that on mine and post results.

Worked like a charm, at least the DB now passes a pragma check and is running for my server.

Might be time to update the knowledgebase page

[NewPlaza]

@dunewarrior said:
Might be time to update the knowledgebase page

You better get a T-shirt if you manage to pull that off.

[dunewarrior]

@NewPlaza said:

@dunewarrior said:
Might be time to update the knowledgebase page

You better get a T-shirt if you manage to pull that off.

I might just do it myself, for a t-shirt

[dgrizzard]

Just wanted to add (since this worked for me) for anyone who isn’t familiar, you open the dump.sql file in a text editor and change the last line from ROLLBACK; to COMMIT;

Thanks again to the OP for figuring this out!

[clinito]

Thank you so much… saved me to start from fresh!