Thread: Clara HD Import Sqlite
View Single Post
Old 06-15-2020, 06:04 PM   #7
geek1011
Wizard
geek1011 ought to be getting tired of karma fortunes by now.geek1011 ought to be getting tired of karma fortunes by now.geek1011 ought to be getting tired of karma fortunes by now.geek1011 ought to be getting tired of karma fortunes by now.geek1011 ought to be getting tired of karma fortunes by now.geek1011 ought to be getting tired of karma fortunes by now.geek1011 ought to be getting tired of karma fortunes by now.geek1011 ought to be getting tired of karma fortunes by now.geek1011 ought to be getting tired of karma fortunes by now.geek1011 ought to be getting tired of karma fortunes by now.geek1011 ought to be getting tired of karma fortunes by now.
 
Posts: 2,805
Karma: 7423683
Join Date: May 2016
Location: Ontario, Canada
Device: Kobo Mini, Aura Edition 2 v1, Clara HD
Quote:
Originally Posted by angeladottavio View Post
Thank you. I have been trying to figure out how to copy the bookmark table in the new database, but I haven't been able to understand it. Could you explain it, please?
One way would be to use .dump to dump the entire DB (warning: it's large), then copy the insert statements for the bookmark table to the other db.

The other way would be to use the ATTACH command to attach the other database, then copy between them using an INSERT and SELECT in the same statement.

If you're using a GUI, you might be able to copy the rows as-is.
geek1011 is offline   Reply With Quote