Thread: Libra How to fix a (minor?) database error?
View Single Post
Old 12-09-2021, 08:25 PM   #16
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by Mister L View Post
This is my fault, I tried to import data into a table which already contained the same data... I thought it would be replaced. A bit stupid of me. I deleted all the data from the table and then imported it again and then it worked perfectly.
That's not a mistake I'd ever make. Again.
Quote:
Thanks I will wait then.

I think now I've got everything figured out that I want to do.

Am I missing any steps?
  1. export bookmarks table in csv (done)
  2. backup (manual copy) damaged database just in case (done)
  3. verify all books on device are matched to books in Calibre library
  4. add tag in Calibre to all books on device so I know which ones to restore just in case
  5. on device, logout then login
  6. (if necessary) send books from Calibre to device
  7. using the plugin, update the metadata of the books on the device (read dates/status, sent date, collections...)
  8. import the saved bookmarks to the table from the csv file

Thank you again for all your help, I really appreciate it.
That looks good. It should work and will safe. I think the only thing I would do is to take a full copy of the books partition before starting. That way, if something goes wrong, you can restore this and start again. I do this frequently with some of the testing I do.
davidfor is offline   Reply With Quote