Thread: How do I export notes (annotation) to my computer?
View Single Post
Old 05-27-2016, 07:23 PM   #30
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 marp68 View Post
Yes, the laws may of course differ between countries. Here in Sweden the laws says you can make a copy or backup but only for private use. Don't know if it applies to ebooks though.

I think I will start out with the DE option. I also discovered the kobo utility option to delete empty DE annotation files. So the only ones that remains would be the one to backup.
Yes, that is needed as the firmware doesn't cleanup these files when deleting a book. It's caused a bit of confusion when people have deleted a book and then sent a new copy to the device.
Quote:
Sorry, just to be clear about the practical stuff about the user partition backup and the database backup.

Will a normal complete folder copy of what's visible on the device select enough? And when copying back to device, do I just replace everything that is visible on the new/factory reset device? And then just run the device as normal?
Copy everything on the partition. If you are using a Mac or Linux, there are hidden directories. These must be copied. For the restore, I normally delete everything and then copy the backup back to the devvice.
Quote:
Regarding database, I've set the kobo utilities to backup and compress the database automatically. Is that results a "full" database that I can use to dump the bookmark table to file with SQLite? And practically, how do you load the file back into the database on the device, with SQLite as well? Hmm... why not just use the the whole backuped database from the beginning then? I probably misunderstood something here. And does this means that the bookmark table contains the actual annotations etc?
The database backup is a copy of the file containing the database. So, yes it is a full backup. It's intended use is for when you realised the database on the device is corrupted. If there haven't been many changes, then simple replacing the database on the device and restarting it will get the you out of trouble. You will lose any changes made since the backup was made.

The longer the time since the backup and the more changes, the less worthwhile it is to restore the database. You will lose to many changes, any added books have to be processed and any removed books removed from the database. A factory reset is the ultimate in this. Unless the books are restored to exactly the same place, the contents of the database will effectively be cleared and rebuild.

To restore just one table is done by opening the backup database with an SQLite database manager and using its tools to export the table. Then opening the live database and importing the table.
davidfor is offline   Reply With Quote