Database backup

How to make a backup of your databases

[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 Libraries

A list of available libraries for WebDNA...

WebDNA reference

A list of all WebDNA instructions...

Technical Change History

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

Tips and Tricks

A list of user-submitted tips ...

[biotype]

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

Download WebDNA Applications

WebDNA applications...

Related Readings:

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

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

Setting a 30-minute Cookie

Configuring the expires time for a short-term cookie is tricky...

Spaghetti code

How to get rid of very long search strings...

How to setup CODA to work with WebDNA?

This page will show graphically how to setup CODA as a WebDNA partner :-)...

Export data to Excel

Here's a handy way to export your data to a text or Excel file...

Hideif on IP range

This will show or hide stuff according to the IP...