Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next
Broken backup file & database
Author Message
DVD Profiler Unlimited RegistrantGreenmiller
Registered: July 29, 2007
Posts: 12
Posted:
PM this userDirect link to this postReply with quote
Hi,
looking for ideas for the following problem:
An error occurred while backing up a database. Now Profiler shows no profiles in the database and the restore fails during "Restoring custom credit photos" resp.  during "Skipping custom credit photos" (Apparently non-profiler files somehow got into the "CreditPhotos" Folder which must have caused the crash).
All the database files are still there and the restore window shows all titles. So this information is still there ... just where is it?
I guess I will have to build a new db now; a list of titles would be of great help. If the restore can still read them it's got to be possible to extract that information somehow ... I hope?

Any ideas? 
DVD Profiler Unlimited RegistrantGreenmiller
Registered: July 29, 2007
Posts: 12
Posted:
PM this userDirect link to this postReply with quote
Ok, I've made screenshots of the restore window ... at least a little help.
(I'd still take suggestions for making the restore work after all of course ...    )

greetz
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Greenmiller:
Quote:
So this information is still there ... just where is it?

For a bit background information: Data Recovery

Now I would as a first step make a copy of the database-folder.

After that a database-repair seems in order: Tools -> Options -> Utilities -> Repair Profile Database and choose "full"

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Unlimited RegistrantGreenmiller
Registered: July 29, 2007
Posts: 12
Posted:
PM this userDirect link to this postReply with quote
@ Mithi
thank you for your reply, alas - I've tried it all, repair, re-install, running it on another computer ...

Another question ... Didn't there use to be a placeholder in the Cast/Crew windows when there is no photo for that person? It's there in the "cast information" overview, but not in the detail frame right above the cast list .... 
DVD Profiler Unlimited RegistrantAstrakan
Registered: Feb 12, 2000
Registered: March 28, 2007
Reputation: High Rating
Canada Posts: 1,299
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Have you tried just unchecking the "Restore custom credits photos" check box in the restore window? If that's the step at which it fails, then you should hopefully be able to restore everything except for the custom credits photos.

If that does't work, I'd uncheck one other box and try again. If it fails again, then work your way through the checkboxes one at a time and try to restore again. If it keeps failing, hopefully at least it will work when only "Restore profiles" is checked.

And if that too fails, I'd suggest starting a blank database and downloading your collection from your online list. That can be done via Online -> DVD Profiler Online, and selecting "Download" when prompted.
Tags, tags, bo bags, banana fana fo fags, mi my mo mags, TAGS!
Dolly's not alone. You can also clone profiles.
You've got questions? You've got answers? Take the DVD Profiler Wiki for a spin.
 Last edited: by Astrakan
DVD Profiler Unlimited RegistrantGreenmiller
Registered: July 29, 2007
Posts: 12
Posted:
PM this userDirect link to this postReply with quote
Quoting Astrakan:
Have you tried just unchecking the "Restore custom credits photos" check box in the restore window?

None of the built-in features works.
I've started a new db ... just a few hundred profiles to go 
The only thing to be learned - never live with just one backup!

Thanks all!
DVD Profiler Unlimited RegistrantStar ContributorNexus the Sixth
Contributor since 2002
Registered: March 13, 2007
Reputation: High Rating
Sweden Posts: 3,197
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Unless you choose not to for some reason when backing up, there should always be a second backup copy in your database folder. Have you tried to rename and restore that one?
First registered: February 15, 2002
 Last edited: by Nexus the Sixth
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Astrokan mentioned this, but I think it is also applicable to Mithi's advice: always start any recovery or restore operations from a new clean database, instead of loading an existing one and attempting to overwrite. I'm almost certain I can remember Ken giving this advice during Beta debug cycles.

@Greenmiller, given all the available methods, there should virtually no cisrcumstance where one needs to start from scratch - short of losing all your backups, all copies of collection.XML and the online simultaneously.

I mean you can even rebuild a database from old flag sets, which are simply text file lists of profileIDs - in this case, you don't get personal info, but it is a quick start.

In summary, you can automatically rebuild from (in order of quality):

All of these can preserve personal info
- Restoring a backup into a clean database
- Restoring from the online into a clean database
- Using BulkEdit to import into a clean database a CSV file created by CSV Export or collection.xml created from DVDP Export

Finally, for a quick start without personal info
- Use native DVDP bulk import of a UPC list. This list can be barcode scanned, typed manually, or recovered from old flag sets
- Use BulkEdit to bulk import Profile IDs and preliminary personal info from a CSV file generated using Excel
- Use BulkEdit - ScrapeGoat to grab bunches of DVD profile IDs from other Online collections of users that have similar tastes and thereby have many of the same items in their collections

There may be other good options if you also own one of the mobile solutions, but I have not personally tested them.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantGreenmiller
Registered: July 29, 2007
Posts: 12
Posted:
PM this userDirect link to this postReply with quote
Thank you all for your good advice!

I've recovered an old version of the backup from a windows image. That gives me a good start.
My collection is not online, was never exported to Excel and in large parts the profiles were custommade, because it contains old video recordings that never made it to DVD.  Live and learn

Have a good one!
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next