MobileRead Forums - View Single Post

davidfor · 01-14-2015, 07:19 PM

Not having a database restore function in the utilities plugin is deliberate. If there is a problem that needs a database restore, you probably don't want to do it from within calibre. It access the database and might cause problems. Plus if you need to do a restore, you need to think about what you are doing and why. And the restore is a simple file copy and rename. Plus it should be an very infrequent task, so spending the time to automate it is not necessarily worthwhile.

The annotations are stored in the database. Hence a database backup automatically has the annotations. In lot of cases, it will be pointless to restore the annotations with the rest of the database. The data needs to be consistent for everything to work properly.

You can also use the Annotations plugin to copy the annotations into a column in calibre. But, this a one-way action and they can't be restored to the device.

The real question is, what are you trying to achieve? If you are just worried about loosing the annotations if you need to do a factory reset, just make sure the backups are done and come back and ask when you need to restore them. If there is another reason, tell us and we'll see what we can suggest.

01-14-2015, 07:19 PM	#2
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	Not having a database restore function in the utilities plugin is deliberate. If there is a problem that needs a database restore, you probably don't want to do it from within calibre. It access the database and might cause problems. Plus if you need to do a restore, you need to think about what you are doing and why. And the restore is a simple file copy and rename. Plus it should be an very infrequent task, so spending the time to automate it is not necessarily worthwhile. The annotations are stored in the database. Hence a database backup automatically has the annotations. In lot of cases, it will be pointless to restore the annotations with the rest of the database. The data needs to be consistent for everything to work properly. You can also use the Annotations plugin to copy the annotations into a column in calibre. But, this a one-way action and they can't be restored to the device. The real question is, what are you trying to achieve? If you are just worried about loosing the annotations if you need to do a factory reset, just make sure the backups are done and come back and ask when you need to restore them. If there is another reason, tell us and we'll see what we can suggest.