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:

AWS Raw WebDNA LAMP-Plus WebServer

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

WebDNA Modules

A list of the currently available modules...

WebDNA reference

...

Technical Change History

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

WebDNA Libraries

A list of available libraries for WebDNA...

Tips and Tricks

A list of user-submitted tips ...

Related Readings:

PayPal gateway

...

ImageMagick

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

How many working days?

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

Export data to Excel

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

Extracting the first sentence out of a block of text

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

Spaghetti code

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