Database backup

How to make a backup of your databases

numero = 54
interpreted = N
texte =
[listfiles path=databases/][showif [isfile]=T][COPYFILE from=databases/[filename]&to=db_daily_archives/[listwords words=[filename]&delimiters=.][showif [index]=1][word]_[date %A_%p][/showif][showif [index]=2].[word][/showif][/listwords]][/showif][/listfiles]
Write a trigger to run the script 2 times a day and change the path to your DB directory. This copies all .db & .hdr files to an archive folder with the day and AM or PM. You will get a morning and evening backup of each file in your DB folder. Each week the script overwrites the files with the new ones. Example.db would be saves as: Example_Monday_AM.db Example_Monday_PM.db Example_Tuesday_AM.db etc.
[listfiles path=databases/]
[showif [isfile]=T]
[COPYFILE from=databases/[filename]&to=db_daily_archives/[listwords words=[filename]&delimiters=.]
[showif [index]=1][word]_[date %A_%p][/showif]
[showif [index]=2].[word][/showif]
[/listwords]]
[/showif]
[/listfiles]


Write a trigger to run the script 2 times a day and change the path to your DB directory. This copies all .db & .hdr files to an archive folder with the day and AM or PM. You will get a morning and evening backup of each file in your DB folder. Each week the script overwrites the files with the new ones.

Example.db would be saves as:

Example_Monday_AM.db
Example_Monday_PM.db
Example_Tuesday_AM.db
etc. Brian Boegershausen

DOWNLOAD WEBDNA NOW!

Top Articles:

WebDNA Modules

A list of the currently available modules...

Technical Change History

This Technical Change History provides a reverse chronological list of WebDNA changes...

Tips and Tricks

A list of user-submitted tips ...

F.A.Q

A compilation of some user's questions...

[biotype]

BioType is a behavioral biometrics WebDNA function based on ADGS research and development (from version 8...

Download WebDNA Applications

WebDNA applications...

Related Readings:

Write Once Use Many

Reuse the same code over and over again on your site with the [include] context...

Using a simple Array of Variables with [interpret]

The [interpret] context is very powerful command in the hands of a skilled WebDNA programmer...

ImageMagick

Use ImageMagick to manipulate images when you upload them...

Cloning a Record

Often...

Find duplicate records

Find duplicate records and do something with them...

How many working days?

This small script finds the number of working days between two dates...