/system script
add name=FTP-Backup policy=ftp,reboot,read,write,policy,test,winbox,password,sniff,sensitive source="# automated System - UM database backup 2 External FTP\r\
    \n# Get time\r\
    \n:local ts [/system clock get time]\r\
    \n:set ts ([:pick \$ts 0 2].[:pick \$ts 3 5].[:pick \$ts 6 8])\r\
    \n# Get Date\r\
    \n:local ds [/system clock get date]\r\
    \n:set ds ([:pick \$ds 7 11].[:pick \$ds 0 3].[:pick \$ds 4 6])\r\
    \n# This line to generate the file name for user manager backup - file name will be UMDB- ServerName\? - Date\? - Time\?\r\
    \n:local fname (\"/UMDB-\".[/system identity get name].\"-\".\$ds.\"-\".\$ts.\".umb\")\r\
    \n# This line to generate the file name for System backup - file name will be UMDB- ServerName\? - Date\? - Time\?\r\
    \n:local fname1 (\"/UMDB-\".[/system identity get name].\"-\".\$ds.\"-\".\$ts.\".backup\")\r\
    \n# all above is workaround to get unique \$filename=UserManagerDB  - \$filename1=System\r\
    \n/tool user-manager database save name=\$fname\r\
    \n:log info message=UserManagerBackupFinished;\r\
    \n/system backup save name=\$fname1\r\
    \n:log info message=SystemBackupFinished;\r\
    \n# Upload the UserManagerDB Backup to External FTP - change address to your ftp server + user + pass\r\
    \n/tool fetch address=www.1.com src-path=\$fname user=user mode=ftp password=pass dst-path=/ upload=yes\r\
    \n# Upload the System Backup to External FTP - change address to your ftp server + user + pass\r\
    \n/tool fetch address=www.1.com src-path=\$fname1 user=user mode=ftp password=pass dst-path=/ upload=yes\r\
    \n# Delay time to finish the upload - increase it if your backup file is big\r\
    \n:delay 60s;\r\
    \n# Find file name start with UMDB- then remove\r\
    \n:foreach i in=[/file find] do={:if ([:typeof [:find [/file get \$i name] \"UMDB-\"]]!=\"nil\") do={/file remove \$i}}\r\
    \n:log info message=UserMangerBackup-SystemBackup-TempRemoved;\r\
    \n:log info message=UserManger-SystemBackup2CentOS-Finished;"

/system scheduler 
add comment="" disabled=no interval=1d name="System-UM DB- FTP backup" \
on-event=FTP-Backup start-date=jan/01/1970 start-time=00:00:00

disk1
└── backups
    └── auto
        ├── export
        │   └── Mikrotik-RB750Gr3_2-20170109-145244.rsc
        └── Mikrotik-RB750Gr3_2-20170109-145244.backup

3 directories, 2 files

# basedir
:local fbase "/disk1/backups/auto"

# filename prefix
:local fnp "Mikrotik"

# months array
:local months ("jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec");

# get time
:local ts [/system clock get time]
:set ts ([:pick $ts 0 2].[:pick $ts 3 5].[:pick $ts 6 8])

# get Date
:local ds [/system clock get date]
# convert name of month to number
:local month [ :pick $ds 0 3 ];
:local mm ([ :find $months $month -1 ] + 1);
:if ($mm < 10) do={ :set mm ("0" . $mm); }
# set $ds to format YYYY-MM-DD
:set ds ([:pick $ds 7 11] . $mm . [:pick $ds 4 6])

# file name for system backup 
:local backupfn ($fnp."-".[/system identity get name]."-".$ds."-".$ts.".backup")
# file name for config export
:local exportfn ($fnp."-".[/system identity get name]."-".$ds."-".$ts.".rsc")

# backup the data
/system backup save name="$fbase/$backupfn"
:log info message="system backup saved $fbase/$backupfn (1/2)"
/export compact file="$fbase/export/$exportfn"
:log info message="configuration export saved $fbase/export/$exportfn (2/2)."

#Get Time and Date
:local ts [/system clock get time]
:set ts ([:pick $ts 0 2].[:pick $ts 3 5].[:pick $ts 6 8])
:local ds [/system clock get date]
:set ds ([:pick $ds 7 11].[:pick $ds 0 3].[:pick $ds 4 6])

# This line to generate the file name for System backup 
:local fname1 ("CCR-FTP--".$ds."-".$ts.".backup") 


/system backup save name=$fname1;
#uncomment to send also by email (configure the tool email in your MK with valid smtp)
#/tool e-mail send to="email@domain.com" subject=("mikrotik  backup") body="Respaldo Historico CloudCore" file=$fname1;
#post to root of the ftp server
/tool fetch address=www.ftp.com src-path=$fname1 user=usr mode=ftp password=passwd dst-path=$fname1 upload=yes
:log info "Backup Done";