MobileRead Forums - View Single Post

Lucas Malor · 11-29-2016, 05:01 PM

I missed the table name. Thank you David, as usual. If someone is interested, this is the trick to restore the bookmarks under Linux (or Windows with minsys):

PHP Code:


			
sqlite3 BACKUP_DATABASE.sqlite

.mode insert Bookmark
.out /PATH/TO/FILE.sql 
select * from Bookmark;

CTRL+D

cat /PATH/TO/FILE.sql  | sqlite3 NEW_DATABASE.sqlite

(I suggest you to backup the db before)

11-29-2016, 05:01 PM	#10
Lucas Malor Pain in the arse Posts: 758 Karma: 77856 Join Date: Apr 2013 Device: Kobo Aura One, Kindle 4	I missed the table name. Thank you David, as usual. If someone is interested, this is the trick to restore the bookmarks under Linux (or Windows with minsys): PHP Code: `sqlite3 BACKUP_DATABASE.sqlite .mode insert Bookmark .out /PATH/TO/FILE.sql select * from Bookmark; CTRL+D cat /PATH/TO/FILE.sql \| sqlite3 NEW_DATABASE.sqlite` (I suggest you to backup the db before)