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:

Technical Change History

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

WebDNA Modules

A list of the currently available modules...

Download WebDNA Applications

WebDNA applications...

WebDNA Libraries

A list of available libraries for WebDNA...

F.A.Q

A compilation of some user's questions...

Tips and Tricks

A list of user-submitted tips ...

Related Readings:

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...

Hideif on IP range

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

How to keep the text variable after a function has finished

By default...

Setting a 30-minute Cookie

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

Extracting the first sentence out of a block of text

I need to extract the first sentence out of a block of text...