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 Feature Requests Page: 1  Previous   Next
Syncing databases
Author Message
DVD Profiler Desktop and Mobile RegistrantStar Contributorajm
dvd-aholic
Registered: March 13, 2007
United Kingdom Posts: 525
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Now we have support for multiple databases, and creating a new database has the option of copying the currently opened one, what I think would be nice, is to be able to use this as a backup.

So, my plan would be you initially create a new database and copy the existing one. Now obviously you want to store the new database on another drive somewhere.

So it then creates and copies all the exising profiles and cover images.

Then at a later date you could then have a sync option, that copies the profiles across and update only images that have changed, and removes now unused ones.

In theory this will be far quicker than using the current back option. Especially for those with large collections.

Home of the phpDVDProfiler forums
DVD Profiler Unlimited RegistrantStar ContributorRHo
Registered: March 13, 2007
Posts: 2,759
Posted:
PM this userDirect link to this postReply with quote
Quoting ajm:
Quote:
In theory this will be far quicker than using the current back option. Especially for those with large collections.

Why should that be faster? I'd say backup speed on modern computers is only limited by disk reading and writing speed. The same amount of data has to be read and approx. the same amount of data has to be written. Actually the backup file can be (or is) even smaller than the original database. Computing time (converting the database into a file) is not the limiting factor IMO.
DVD Profiler Desktop and Mobile RegistrantStar Contributorajm
dvd-aholic
Registered: March 13, 2007
United Kingdom Posts: 525
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
It will be faster as it can check if the existing image has the same timestamp as the one it would be overwriting and if they are the same, don't write it. Thus saving loads of time.

Checking a timestamp of a file is far quicker than reading the file and then writing it out.

Home of the phpDVDProfiler forums
DVD Profiler Unlimited RegistrantStar ContributorRHo
Registered: March 13, 2007
Posts: 2,759
Posted:
PM this userDirect link to this postReply with quote
Quoting ajm:
Quote:
It will be faster as it can check if the existing image has the same timestamp as the one it would be overwriting and if they are the same, don't write it. Thus saving loads of time.

Checking a timestamp of a file is far quicker than reading the file and then writing it out.

Agreed for syncing an existing backup. I have somehow not read that part. But I would not do this for backup purposes. I do want to keep several backup generations.

But your proposal (or even a two way syncronisation) would be great for syncing two databases. E.g. Desktop computer and laptop.
DVD Profiler Desktop and Mobile RegistrantMarcCastermans
Registered: March 15, 2007
Posts: 116
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting RHo:
Quote:

But your proposal (or even a two way syncronisation) would be great for syncing two databases. E.g. Desktop computer and laptop.


This is a great idea.
Greetz,
Marc Castermans

DVD Profiler Desktop and Mobile RegistrantStar Contributorajm
dvd-aholic
Registered: March 13, 2007
United Kingdom Posts: 525
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting RHo:
Quote:

But your proposal (or even a two way syncronisation) would be great for syncing two databases. E.g. Desktop computer and laptop.


That's basically what I'd use it for. But its also an effective backup solution.

Currently I backup to my 4gb pen drive, then restore it on my work laptop. So a backup takes 10 mins as does the restore.

By just copying the database files and using some simple timestamp test for whether or not to copy images, it should make the sync take well under a minute on subsequent runs.

Home of the phpDVDProfiler forums
DVD Profiler Desktop and Mobile RegistrantGraveworm
Registered: April 7, 2007
United Kingdom Posts: 357
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting MarcCastermans:
Quote:
Quoting RHo:
Quote:

But your proposal (or even a two way syncronisation) would be great for syncing two databases. E.g. Desktop computer and laptop.


This is a great idea.


Another one who thinks it is a great idea for this reason. I have DVDpro on my desktop and laptop, backup restore is no headache in terms of time BUT it's can be a real pain if I have updated records on both. Sync (as per mobile version) would make it much easier.
 Last edited: by Graveworm
DVD Profiler Unlimited RegistrantRossRoy
Registered: March 13, 2007
Posts: 793
Posted:
PM this userDirect link to this postReply with quote
I'm late, but I'd like this idea too!

Currently, I use SyncBackSE to sync the MyDoc/DVD Profiler folder to my 8gb pen drive, but I've had a few instances where it messed up some stuff (although to be fair, it's probably a wrong move by me).

Anything to make backup and sync faster, I'm all for it!
DVD Profiler Desktop and Mobile RegistrantStar Contributorajm
dvd-aholic
Registered: March 13, 2007
United Kingdom Posts: 525
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Not surprisingly, I've now got a little rsync script that does my backup to my pen drive. I use cwrsync on windows.

Now I having rsync installing on my c: drive. But it would be an easy thing to do, to install it on the pen drive and then you can run it in 'local copy mode'. So, you could then set up 2 batch files. The first to copy from drive c to your pen drive and the second to copy from your pen drive to drive c.

I've just currently got :-

rsync -vha --stats --delete "/cygdrive/c/Documents and Settings/ajm/My Documents/DVD Profiler" "/cygdrive/g/DVDProfiler Backup/mydocs/"

Which will backup all my dvdprofiler databases (all 1 of them currently)

You'd just need to reverse the 2 directory names for the second batch file.

You'd also just need to change where the CWRSYNCHOME variable points too in the demo script to ensure it points to your pen drive.

With rsync, the first run will take a while. Its backing up everything. But after that it will just backup the changes.

Home of the phpDVDProfiler forums
DVD Profiler Unlimited Registrantsmeehrrr
Registered: March 26, 2007
Posts: 196
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I'm using foldershare (http://www.foldershare.com) to keep my database synchronized across the multiple machines I use.  It works so well that I've pretty much retired my USB stick.
 Last edited: by smeehrrr
DVD Profiler Unlimited RegistrantRossRoy
Registered: March 13, 2007
Posts: 793
Posted:
PM this userDirect link to this postReply with quote
Quoting ajm:
Quote:
Now I having rsync installing on my c: drive. But it would be an easy thing to do, to install it on the pen drive and then you can run it in 'local copy mode'. So, you could then set up 2 batch files. The first to copy from drive c to your pen drive and the second to copy from your pen drive to drive c.


Can it run as a portable app on the USB stick without leaving any registry keys on the machine? Or do I actually need an rsync server on the machine for it to work?
DVD Profiler Desktop and Mobile RegistrantStar Contributorajm
dvd-aholic
Registered: March 13, 2007
United Kingdom Posts: 525
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Ross, rsync doesn't do anything fancy with reg keys as far as I can tell. It seems to run fine from the installation on my pen drive.

And no, you don't need the rsync server. You're just running it as a 'smart' copy command.

Home of the phpDVDProfiler forums
    Invelos Forums->DVD Profiler: Desktop Feature Requests Page: 1  Previous   Next