Tuesday October 21 , 2014
Text Size
   
Welcome, Guest
Username: Password: Remember me
Try to get help from other ComicRack users
  • Page:
  • 1
  • 2

TOPIC: Help with Database Backup

Help with Database Backup 4 years 4 months ago #8353

  • 600WPMPO
  • 600WPMPO's Avatar
  • OFFLINE
  • Moderator
  • Posts: 3708
  • Thank you received: 478
  • Karma: 207
Currently adding the section on backing up database, and as usual there are some things I would like to have an expert opinion on...

1. What fields does the database backup? what fields are not backed up?
This is my list.. any additions/deletions?

Book Id
File path
Series
Number
Volume
Summary
All fields in details & plot n notes tabs (except notes)
Pages details (size, width, height)
Bookmarks
Date Added
Date Opened
OpenCount
LastPageRead
Rating
ColorAdjustment
ComicInfoIsDirty
FileSize
FileModifiedTime
FileCreationTime

2. Looking at the backup.xml file, a few entries need explanation:

2a. What is the Book ID?
2b. What is ComicInfoIsDirty ?
2c. What does 'Page image' mean?


3. The file path is also present in the backup file. Does this mean that all the ecomics must be in the same path while restoring database? Is there no other way for ComicRack to identify eComics than use filepath?

4. Please confirm that the database backup works only for cbz files?

5. Any other thing worth mentioning about backups that I am missing? Something like best backup practices?

6. Can we backup List layouts & workspaces? Any manual way of doing it?

Please contribute..
Now Playing: The ComicRack Manual (Online)

See my new comics & gadgets on: Tumblr!
Last Edit: 4 years 4 months ago by 600WPMPO.
The administrator has disabled public write access.

Re: Help with Database Backup 4 years 4 months ago #8354

  • cYo
  • cYo's Avatar
  • OFFLINE
  • Moderator
  • Posts: 3396
  • Thank you received: 628
  • Karma: 171
The database backup is a simple file copy of the comicrack database.
You should not document the fields as they are internal and may change.
The administrator has disabled public write access.

Re:Help with Database Backup 4 years 4 months ago #8373

  • quidam
  • quidam's Avatar
  • OFFLINE
  • Platinum Boarder
  • not for nom
  • Posts: 448
  • Thank you received: 23
  • Karma: 30
I may be wrong as I thankfully don't have to restore database that often, but I'll try to answer:

3. The file path is also present in the backup file. Does this mean that all the ecomics must be in the same path while restoring database? Is there no other way for ComicRack to identify eComics than use filepath?

Yes and no. The main folder has to be the same as the one that was pointed in Preferences-> Library. So if it was c:\comics then before you restore your database move there all the files you want to restore.

But, the internal folder path can be different than the original one. So if it was c:\comics\DC\TheSandman\Sandman01.zip and now it's c:\comics\Sandman\Sandman_1.zip it's still going to be recognized as the same file and all the metadata from database will be assigned to it again. As long as the content of the file is the same as the original one, its name and sub-folder can be different. That's the same rule as stated in Preferences -> Library: Checked folders will be watched for changes (rename, move) while the program is running.

On the other hand, if the file path and name is identical as the original one, the content of the file may be different. So it can miss covers you added manually, etc. This is useful in normal usage: you can change archive content (for example, add another image with cover), and as long as you wont rename/move file at the same time, you can refresh it in ComicRack and you'll see the changes.

One of those two rules decide if restored file is going to be recognized correctly. You can't have different filename and its content at the same time.

That's the general rule. Of course with cbz if they have ComicInfo.xml inside then metadata will be taken form it. But as you know not all the metadata is stored there (like notes, tags).


4. Please confirm that the database backup works only for cbz files?

No. All the files of all the formats recognized by ComicRack that are in your Library, are stored in database (ComicDB.xml) so you can backup/restore their metadata.


5. Any other thing worth mentioning about backups that I am missing? Something like best backup practices?

Backup database offten. ;) You never know... Disaster may come when you expect it the least. Just two days ago ComicRack crashed for me and corrupted database so I had to restore it. It was first crash for like half year. But I kinda expected it unconsciously because I did backup 15 minutes before it happened. Lucky me. ;) I don't know if cYo got this report, I did very strange things with ComicRack that time... it was taking over 800MB of memory... I had it running for several hours, did quite a few export task + multiple comic info editing + and many other things were going in Windows in the background...

Well, just backup regularly every big update to your Library.


6. Can we backup List layouts & workspaces? Any manual way of doing it?

List Layouts and Workspaces are saved in Config.xml in the same folder where your database is stored. You can backup it manually if you want. I do. ;]
[FTP DOWN]
Warning: Spoiler! [ Click to expand ]
The administrator has disabled public write access.

Re:Help with Database Backup 4 years 4 months ago #8377

  • 600WPMPO
  • 600WPMPO's Avatar
  • OFFLINE
  • Moderator
  • Posts: 3708
  • Thank you received: 478
  • Karma: 207


Didn't I tell you all !!!

+1 karma to our friend !
Now Playing: The ComicRack Manual (Online)

See my new comics & gadgets on: Tumblr!
The administrator has disabled public write access.

Re:Help with Database Backup 4 years 4 months ago #8383

  • 600WPMPO
  • 600WPMPO's Avatar
  • OFFLINE
  • Moderator
  • Posts: 3708
  • Thank you received: 478
  • Karma: 207
In light of the above discussion, will this statement be correct ?

Now Playing: The ComicRack Manual (Online)

See my new comics & gadgets on: Tumblr!
The administrator has disabled public write access.

Re:Help with Database Backup 4 years 4 months ago #8391

  • {Oo}
  • {Oo}'s Avatar
  • OFFLINE
  • Platinum Boarder
  • The Chewie is a lie !
  • Posts: 671
  • Thank you received: 40
  • Karma: 15
The metadata is stored in .cbz as well as in .zip and .7zip and .cb7 (if you have the option enabled of course). It's just a deduction for the last 2 since I don't use them. But, they are open source so I don't see why CR wouldn't do it.
The administrator has disabled public write access.

Re:Help with Database Backup 4 years 4 months ago #8392

  • Stonepaw
  • Stonepaw's Avatar
  • OFFLINE
  • Moderator
  • Posts: 848
  • Thank you received: 237
  • Karma: 159
600WPMPO wrote:
In light of the above discussion, will this statement be correct ?

Technically you can retrieve metadata from CBRs as well since the metadata is also stored in the secondary stream of an eComic. This means that as long as you don't move the eComic to a FAT32 partition or burn it to a CD or something, you will be able to retrieve metadata from CBRs as well as CBZs.

Also "practice" and "before" are spelled wrong in the last sentence.

quidam write:
List Layouts and Workspaces are saved in Config.xml in the same folder where your database is stored. You can backup it manually if you want. I do. ;]
I think it would be a fairly simple matter to write a script to do this. If there is interest and cYo doesn't want to implement a way to back this file up with ComicRack, I could write it.
Last Edit: 4 years 4 months ago by Stonepaw.
The administrator has disabled public write access.

Re:Help with Database Backup 4 years 4 months ago #8400

  • 600WPMPO
  • 600WPMPO's Avatar
  • OFFLINE
  • Moderator
  • Posts: 3708
  • Thank you received: 478
  • Karma: 207
Stonepaw wrote:
If there is interest and cYo doesn't want to implement a way to back this file up with ComicRack, I could write it.
;) There is a definite interest Stoney!

lets see if cYo has planned anything..

p.s. and thanks for the live proof-reading :P
Now Playing: The ComicRack Manual (Online)

See my new comics & gadgets on: Tumblr!
Last Edit: 4 years 4 months ago by 600WPMPO.
The administrator has disabled public write access.

Re:Help with Database Backup 4 years 4 months ago #8412

  • quidam
  • quidam's Avatar
  • OFFLINE
  • Platinum Boarder
  • not for nom
  • Posts: 448
  • Thank you received: 23
  • Karma: 30
{Oo} wrote:
The metadata is stored in .cbz as well as in .zip and .7zip and .cb7 (if you have the option enabled of course). It's just a deduction for the last 2 since I don't use them. But, they are open source so I don't see why CR wouldn't do it.

ComicInfo.xml is only saved into cbz, cb7 and cbt, not in normal zip, 7z, tar archives.

Metadata for all supported formats is saved in database file (ComicDB.xml). For rars, pdfs, zips, etc. But also for cbz, despite the fact they can have their own ComicInfo.xml. All the files you added to Library have their corresponding metadata saved somewhere in database.
[FTP DOWN]
Warning: Spoiler! [ Click to expand ]
The administrator has disabled public write access.

Re:Help with Database Backup 4 years 4 months ago #8414

  • 600WPMPO
  • 600WPMPO's Avatar
  • OFFLINE
  • Moderator
  • Posts: 3708
  • Thank you received: 478
  • Karma: 207
quidam wrote:
Metadata for all supported formats is saved in database file (ComicDB.xml). For rars, pdfs, zips, etc. But also for cbz, despite the fact they can have their own ComicInfo.xml. All the files you added to Library have their corresponding metadata saved somewhere in database.
I still have a little query.

We must preserve the main folder in the file path for proper database restore (any format: cbz, cbr..etc). Now, that clear, I transfer some cbz files from my PC (drive D)to my USB pen drive and then to my laptop, which has a totally different folder structure. Purposely, I place it in drive E. Now, I start ComicRack, and it immediately recognizes the files and loads their metadata. These files sit in the library as if they were there since the beginning.

So, does this not give a major advantage to cbz files? Does this not imply that while restoring a database of cbz files, we can have a different main folder? Or do we even need a database backup when all our files are cbz?
Now Playing: The ComicRack Manual (Online)

See my new comics & gadgets on: Tumblr!
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Time to create page: 0.223 seconds

Who's Online

We have 111 guests online

PIM

You are not logged in.