Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Related Tools

Notices

Reply
 
Thread Tools Search this Thread
Old 02-07-2011, 12:39 AM   #1
dee1952
Junior Member
dee1952 began at the beginning.
 
Posts: 1
Karma: 10
Join Date: Feb 2011
Device: sony reader
Question Backup for Calibre

Hi, I'm really new at this. Was interested in knowing what I needed to backup to ensure that my Calibre Info is safe?
dee1952 is offline   Reply With Quote
Old 02-07-2011, 01:17 AM   #2
kiwidude
calibre/Sigil Developer
kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.kiwidude ought to be getting tired of karma fortunes by now.
 
Posts: 4,230
Karma: 1345754
Join Date: Oct 2010
Location: London, UK
Device: Kindle Paperwhite 3G, iPad 3, iPad Air
From the user manual:
http://calibre-ebook.com/user_manual...o-i-backup-app
kiwidude is offline   Reply With Quote
 
Advertisement
Old 02-08-2011, 02:26 AM   #3
Debby
Connoisseur
Debby will become famous soon enoughDebby will become famous soon enoughDebby will become famous soon enoughDebby will become famous soon enoughDebby will become famous soon enoughDebby will become famous soon enough
 
Debby's Avatar
 
Posts: 75
Karma: 600
Join Date: Jul 2008
Location: Depends Upon the Season.....
Device: Cybook, Sony & ipad
With help from others I created batch files that automatically back up my meta data every night.

See thread http://www.mobileread.com/forums/showthread.php?t=83311&highlight=Debby&page=3


Automatically Back up Library and Meta data

Create 2 .bat files and run them in Windows Task Scheduler.


1. Robocopy – you probably already have it - http://en.wikipedia.org/wiki/Robocopy

2. Install Notepad++ (it’s free) to create .bat files - http://www.filehippo.com/download_notepad/

Highlight items in RED should be the location of your Files

Blue highlight is a NEW directory where you will save your backup – you only need quotes around file name if there is a space in your name. If there is not, then do not use them.

To copy Metadata: copy this into Notepad++ and save as .bat file

@echo off
REM metafile copy documents
Z:
cd\My Documents\Calibrelibrary\Familybks
if exist metadata.db.6 del metadata.db.6
if exist metadata.db.5 ren metadata.db.5 metadata.db.6
if exist metadata.db.4 ren metadata.db.4 metadata.db.5
if exist metadata.db.3 ren metadata.db.3 metadata.db.4
if exist metadata.db.2 ren metadata.db.2 metadata.db.3
if exist metadata.db.1 ren metadata.db.1 metadata.db.2
if exist metadata.db copy metadata.db metadata.db.1

robocopy "Z:\My Documents\Calibrelibrary\Familybks" F:\CalibreBU /s /purge /xo /r:1 /w:1

To copy entire library:
@echo off
REM copy documents
robocopy "Z:\My Documents\Calibrelibrary\Familybks" "Z:\My Documents\Calibre Saved Libraries\BatchFile BU" /s /purge /xo /r:1 /w:1
Finish

Place these files in a directory called Batch Files and go to Windows Scheduler and add them. Under Actions: Start a Program C:\Batch Files\whatever your name is. You can select how often you want it to run. I do mine daily at 2:00 am. That should be it!

Good Luck.
Debby is offline   Reply With Quote
Old 02-08-2011, 07:11 AM   #4
Manichean
Wizard
Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!
 
Manichean's Avatar
 
Posts: 3,130
Karma: 80520
Join Date: Feb 2008
Location: Germany
Device: Cybook Gen3
Note that playing back a metadata.db backup from an earlier date than the library currently is at can lead to inconsistencies between the database and the directory structure. A full library backup should be your preferred backup method.
Calibre also already contains a mechanism that backs up the metadata with each change so that you can recreate the metadata.db should it get corrupted, so having a manual backup as well is redundant.
Manichean is offline   Reply With Quote
Old 02-08-2011, 07:58 AM   #5
Lady Fitzgerald
Wizard
Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.
 
Lady Fitzgerald's Avatar
 
Posts: 2,013
Karma: 251649
Join Date: Apr 2010
Location: Tempe, AZ, USA, Earth
Device: JetBook Lite (away from home) + 1 spare, 32" TV (at home)
I'm using Carbonite for my offsite backup. It automatically updates shortly after a file has been created, deleted, or altered (and maintains versions for a week). If I were to lose my library and my local backup, I will be able to restore my library from Carbonite. It's a little less than $5/month for unlimited capacity and I don't even have to think about it since everything is automatic..
Lady Fitzgerald is offline   Reply With Quote
Old 02-08-2011, 10:02 AM   #6
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by Manichean View Post
Note that playing back a metadata.db backup from an earlier date than the library currently is at can lead to inconsistencies between the database and the directory structure. A full library backup should be your preferred backup method.
It's preferred to do a full backup, but the core of Calibre is metadata.db. That file is small, so multiple backups are tiny. It keeps a complete list of all your books, authors, titles, file locations and other data about the status of your library in the past, which I find very useful in a disaster recovery. Yes, if you restore an old metadata.db to a new library, you will get some inconsistencies, but most of them can be corrected with the library error recovery and management tools.

Quote:
Calibre also already contains a mechanism that backs up the metadata with each change so that you can recreate the metadata.db should it get corrupted, so having a manual backup as well is redundant.
Metadata.db keeps your custom recipes and other data that does not apply to a single book. That data is not found in the opf file for individual books. The bottom line is that a metadata.db backup can be very useful and yesterday's metadata.db is a backup I can make in seconds and will rapidly recover 99.8% of my Calibre install if metadata.db becomes corrupted. I still keep a full backup of all books, covers, and metadata.db, but I also keep the same rolling metadata.db backup described here. It's sort of a belt and suspenders thing.
Starson17 is offline   Reply With Quote
Old 02-08-2011, 10:07 AM   #7
Manichean
Wizard
Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!
 
Manichean's Avatar
 
Posts: 3,130
Karma: 80520
Join Date: Feb 2008
Location: Germany
Device: Cybook Gen3
Quote:
Originally Posted by Starson17 View Post
Metadata.db keeps your custom recipes and other data that does not apply to a single book. That data is not found in the opf file for individual books.
Ah, yes, you're right. I forgot about that sort of thing.
Manichean is offline   Reply With Quote
Old 02-08-2011, 11:10 AM   #8
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by Manichean View Post
Ah, yes, you're right. I forgot about that sort of thing.
I don't use the catalog function much, but I suspect it operates almost entirely on the metadata.db file. If I have backup copies of metadata.db, I suspect I can restore it to an empty directory and get various formatted catalogs of what was in my library previously. (I know I can get that info out using SQL, even if the catalog wouldn't run). That info is sometimes useful to me.
Starson17 is offline   Reply With Quote
Old 02-08-2011, 01:06 PM   #9
nynaevelan
eBook Junkie
nynaevelan ought to be getting tired of karma fortunes by now.nynaevelan ought to be getting tired of karma fortunes by now.nynaevelan ought to be getting tired of karma fortunes by now.nynaevelan ought to be getting tired of karma fortunes by now.nynaevelan ought to be getting tired of karma fortunes by now.nynaevelan ought to be getting tired of karma fortunes by now.nynaevelan ought to be getting tired of karma fortunes by now.nynaevelan ought to be getting tired of karma fortunes by now.nynaevelan ought to be getting tired of karma fortunes by now.nynaevelan ought to be getting tired of karma fortunes by now.nynaevelan ought to be getting tired of karma fortunes by now.
 
nynaevelan's Avatar
 
Posts: 1,508
Karma: 1464018
Join Date: May 2010
Location: USA
Device: Kindle Fire 6 2014, Kindle PW2, Galaxy Note 3
I use SyncBack to back up my metadata.db, settings folder and book folders as well as keep a separate backup of the books and their opf files.
nynaevelan is offline   Reply With Quote
Old 02-08-2011, 02:28 PM   #10
edbro
Warthog Driver
edbro is fluent in JavaScript as well as Klingon.edbro is fluent in JavaScript as well as Klingon.edbro is fluent in JavaScript as well as Klingon.edbro is fluent in JavaScript as well as Klingon.edbro is fluent in JavaScript as well as Klingon.edbro is fluent in JavaScript as well as Klingon.edbro is fluent in JavaScript as well as Klingon.edbro is fluent in JavaScript as well as Klingon.edbro is fluent in JavaScript as well as Klingon.edbro is fluent in JavaScript as well as Klingon.edbro is fluent in JavaScript as well as Klingon.
 
edbro's Avatar
 
Posts: 632
Karma: 4911
Join Date: Jul 2007
Location: Grapevine, TX
Device: iPad4
I put my library in Dropbox. Now I can access my books from any computer plus they are backed up to the web along with their metadata.
edbro is offline   Reply With Quote
Old 02-10-2011, 05:54 AM   #11
diamante
piedra preciosa
diamante has a spectacular aura aboutdiamante has a spectacular aura aboutdiamante has a spectacular aura aboutdiamante has a spectacular aura aboutdiamante has a spectacular aura aboutdiamante has a spectacular aura aboutdiamante has a spectacular aura aboutdiamante has a spectacular aura aboutdiamante has a spectacular aura aboutdiamante has a spectacular aura aboutdiamante has a spectacular aura about
 
Posts: 44
Karma: 4170
Join Date: Jan 2011
Location: Boston, Massachusetts
Device: Sony PRS-350, Kindle 2, several Palm OS devices
Question

Quote:
Originally Posted by Manichean View Post
Calibre also already contains a mechanism that backs up the metadata with each change so that you can recreate the metadata.db should it get corrupted, so having a manual backup as well is redundant.
Could I ask you to describe this mechanism in a little more detail? Where can I find the backups?
diamante is offline   Reply With Quote
Old 02-10-2011, 06:33 AM   #12
Manichean
Wizard
Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!
 
Manichean's Avatar
 
Posts: 3,130
Karma: 80520
Join Date: Feb 2008
Location: Germany
Device: Cybook Gen3
See the metadata.opf inside each book folder? Those are backups. There's a tool to reconstruct the database from that information.
Manichean is offline   Reply With Quote
Old 02-10-2011, 07:15 AM   #13
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,909
Karma: 12755553
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by Manichean View Post
See the metadata.opf inside each book folder? Those are backups. There's a tool to reconstruct the database from that information.
The tool is the Restore database menu item under the Library maintenance menu.
DoctorOhh is offline   Reply With Quote
Old 02-10-2011, 07:35 AM   #14
Manichean
Wizard
Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!
 
Manichean's Avatar
 
Posts: 3,130
Karma: 80520
Join Date: Feb 2008
Location: Germany
Device: Cybook Gen3
Right, this is in the GUI as well, now...
Manichean is offline   Reply With Quote
Old 02-10-2011, 10:56 AM   #15
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by Manichean View Post
See the metadata.opf inside each book folder? Those are backups. There's a tool to reconstruct the database from that information.
I know you know this, but the tool reconstructs an approximation to the database, not the entire database. It misses a few things, most notably stored custom recipes.
Starson17 is offline   Reply With Quote
Reply

Tags
backup, calibre

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Old Thread] Calibre Backup and Restore Timber Calibre 21 06-01-2011 08:31 PM
Backup Maggie-Me Calibre 3 01-01-2011 06:13 PM
What kind of backup policy does/can calibre have rollercoaster Calibre 9 04-09-2010 01:25 AM
Backup Calibre conversion settings Amalthia Calibre 5 12-01-2009 02:41 PM
unable to get my book backup back into Calibre? error msg inside stustaff Calibre 13 05-04-2009 05:51 AM


All times are GMT -4. The time now is 11:05 PM.


MobileRead.com is a privately owned, operated and funded community.