Auto-backup -timer question.

[Marc Vanzegbroeck]

Hi,

According to the problem I had with
http://forums.fivetechsupport.com/viewtopic.php?f=3&t=37039

I have create a little program to make a SQL-backup.
I want to do a backup every hour. Each time he create another file-name, so there is no overwrite. Now I keep 30 versions of a backup
Now is my question, what is the best.
Calling each time the program with Window Schedule, or start the program, and create a backup each hour with timer in FW?

[Otto]

Hello Marc,
are you using an inhouse server or is the SQL database hosted somewhere.
Best regards
Otto

[Marc Vanzegbroeck]

Otto,

I use it on a NAS with MariaDB of a customer that had the Hack-problem.
Now I installed the backup-program on a PC, and start the backup with Windows Schedule, that create it on the local harddisk.
It's working fine now

[nageswaragunupudi]

In my opinion, Windows Schedule is better.

For backup, FWH has its own built-in backup and restore methods, which are quite fast.

Code: Select all  Expand view

#include "fivewin.ch"

function Main()

   local oCn
   
   oCn := maria_Connect( <server>, <db>, <user>, <pw> )
   oCn:BackUp( [<db>], <cDstFile> )
   oCn:Close()
   
return nil