Re: [sqlite] Tool for extracting deleted data from unvacuumed SQLite files

2017-10-03 Thread LincolnBurrows 
If you are not a developer you can avoid having the same problem again using
Sqlite Recovery tool and  recover deleted records from Sqlite database
  . It adds
single-master replication to SQLite.



--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Tool for extracting deleted data from unvacuumed SQLite files

2017-10-03 Thread LincolnBurrows 
If you are not a developer you can avoid having the same problem again using
Sqlite Recovery tool and  recover deleted records from Sqlite database
  . It adds
single-master replication to SQLite.



--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Restore SQLite DB from WAL

2017-09-02 Thread LincolnBurrows 
Sometimes, the corruption is only or mostly in indexes, in which case it
would be possible to get some or most records by trying to dump the entire
database with .dump, and use those commands to create a new database:

$ sqlite3 mydata.db ".dump" | sqlite3 new.db

The easiest and most reliable way is to use  Sqlite Recovery Software
   to fix
corruption in SQLite Database.



--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users