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:

[biotype]

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

WebDNA Modules

A list of the currently available modules...

AWS Raw WebDNA LAMP-Plus WebServer

Amazon Web Services (AWS) README for Machine Image ID...

Tips and Tricks

A list of user-submitted tips ...

WebDNA Libraries

A list of available libraries for WebDNA...

Technical Change History

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

Related Readings:

File upload example

...

Removing whitespace

How can I remove all whitespace entered by a user from an input box (ie card number)...

Formatting a long list in a table

How to show the result of a search as a table...

WebDNA interaction with zip

I have a project where I'm allowing several people to upload images...

Redefining [date] & [time] to match your time zone

Your server is not always in the same time zone as your web site...

Database backup

How to make a backup of your databases...