Connexion rapide:  

Forum: Wishes and new features

Sujet Automatic Database Backups

Ce topic est ancien et peut contenir des informations obselètes ou incorrectes.

Have VDJ backup the database after a certain amount of launches.

 

Posté Fri 01 Aug 14 @ 1:20 pm
FruitPRO InfinityMember since 2003
+1
 

Posté Fri 01 Aug 14 @ 1:23 pm
taylaPRO InfinityMember since 2007
Excellent idea.
 

Posté Fri 01 Aug 14 @ 2:16 pm
locoDogPRO InfinityModeratorMember since 2013
It would save me a job +1
 

Posté Fri 01 Aug 14 @ 2:43 pm
+1
 

Posté Sat 02 Aug 14 @ 6:08 pm
+1
 

Posté Tue 02 Sep 14 @ 4:17 am
lincol2PRO InfinityMember since 2011
+1
 

Posté Wed 03 Sep 14 @ 9:34 am
+1
 

Posté Wed 03 Sep 14 @ 2:35 pm
PachNPRO InfinityMember since 2009
+1

and please implement this as an optional feature with variable values, such as date and time or amount of launches until the backup is done.
 

Posté Thu 04 Sep 14 @ 8:36 am
Dodge57PRO InfinityMember since 2009
 

Posté Wed 08 Oct 14 @ 5:52 am
PachNPRO InfinityMember since 2009
Inspired by the batch file Dodge57 created I sat down and wrote another little tool for backing up the VDJ data.
The tool does not only save the C:\.... database.xml, it saves everything related to VDJ to a given path and creates a nice little zip.

The Zip then may look like this:

DatabaseBackup_20141010_1153.zip (<--- format is yyyyMMdd_HHmm*)
-- driveC
---- VirtualDJ
------Skins...
------Mappers...
------ database.xml
(...)
-- driveM
---- VirtuaDJ
------ folders...
------ database.xml

So what does the application do?

1. It checks if there is his settings file called "DatabaseBackupSettings.xml". If not, it will be created. This file is always located in the same directory the application is executed. The "DatabaseBackupSettings.xml" basically just contains the path to where the backup zip will be stored. It's default path is "C:\VdjBackupDatabase". Once the file was created (after the tool run once) you could open the xml with an editor and change the path to your needs. (Maybe to a folder on your NAS, or your Dropbox folder or sth.)

2. Now all drives are being collected and
3. runs through all drives and checks for the "VirtualDJ" folder. If it was found it is copied to a working directory called "temp" which will be created inside the path stored in the DatabaseBackupSettings.xml. So for the default path "C:\VdjDatabaseBackup" a new directory "C:\VdjDatabaseBackup\temp" will be created.

4. After every "VirtualDJ" folder was copied to the "temp" directory. All datas within these directory will be zipped and the zip will finally be in the directory given in the settings.xml.

5. After the work is done, the "temp" directory will be deleted.

6. The name and structure of the Zip is like the above "diagramm". It will contain 1 ore more folders called "drive" + the drive letter. So you could distinguish between the "VirtualDJ" folders.
Note: The zipping may take some time, depending on the amount and type of files to be zipped.


This is the first version of the tool, so there could be some bugs in it. I've given it to some german users to test it. If you are interested in testing PM me and I will give you a download link.

After the testing is over, I will try to get it to the Addons page for everyone to use.




*yyyy = year, MM = month, dd = day, HH = hour, mm = minute
 

Posté Fri 10 Oct 14 @ 6:05 am
What operating systems will this run on? Will it work on XP?

Do you have to run it manually or does it schedule a backup?
 

Posté Fri 10 Oct 14 @ 6:59 am
PachNPRO InfinityMember since 2009
It's written for Windows and should work on XP (as long as .NET Framework 4 or higher is installed).

You could run it manually or use the windows function for scheduled tasks, then it will start automatically ;)
 

Posté Fri 10 Oct 14 @ 7:14 am


(Les anciens sujets et forums sont automatiquement fermés)