Community discussions

MikroTik App
 
User avatar
stmx38
Long time Member
Long time Member
Topic Author
Posts: 615
Joined: Thu Feb 14, 2008 4:03 pm
Location: Moldova, Chisinau

Dude v6 - Backup locally

Sun Jul 16, 2017 7:26 pm

Dude v6 - Backup locally

Requirements
Dude v6 and above

Note: Please be aware, Dude is stopping during database export/import!

Configuration
1. Create a script.
System --> Scripts:
Name: backup-dude-locally
Policy: ftp, read, write, test
Source:
#
# Backup Dude locally
#
# Define variables
:local dudeconffilename "Dude_configuration_backup"
:local dudedbfilename "Dude_db_backup"
:local dudeconffileext "rsc"
:local dudedbfileext "db"
:local localbackuppath "disk1"
#
# Get date and time
#
{
:local curDate [/system clock get date]
:local curTime [/system clock get time]
:local systemName [/system identity get name]
:local curMonth [:pick $curDate 0 3]
 :set curMonth ( [ :find key="$curMonth" in="jan,feb,mar,apr,may,jun,jul,aug,sep,oct,nov,dec" from=-1 ] / 4 + 1)
 if ( $curMonth < 10 ) do={
  :set curMonth ( "0".$curMonth )
 } else={
  :set curMonth $curMonth
 }
:local curDay   [:pick $curDate 4 6]
:local curYear  [:pick $curDate 7 13]
:local curHour  [:pick $curTime 0 2]
:local curMin   [:pick $curTime 3 5]
:local now ("$curYear"."$curMonth"."$curDay" ."-"."$curHour"."$curMin")
#
# Make Dude backup
#
:log warn message="Dude backup locally started";
/dude export file="$localbackuppath/$dudeconffilename_$now.$dudeconffileext"
/dude export-db backup-file="$localbackuppath/$dudedbfilename_$now.$dudedbfileext"
:log warn message="Dude backup locally finished";
#
}
Dude-v6-Backup-locally-01-Script.png
2. Create a schedule.
System --> Scheduler:
Name: backup-dude-locally
Start Day: Nov/07/2017
Start Time: 02:00:00
Interval: 1d 00:00:00
Policy: ftp, read, write, test
On Event: dude-backup-locally
Dude-v6-Backup-locally-02-Schedule.png
3. See the result
Files
Dude-v6-Backup-locally-03-Files.png

Restore backup
In case of need, you can restore Dude v6 from recently created backup:
/dude set enabled=no
/import disk1/Dude_configuration_backup_20170716-0200.rsc
/dude import-db backup-file=disk1/Dude_db_backup_20170716-0200.db
/dude set enabled=yes

Used materials
1. Export to File - Filename Variable
2. Manual:The Dude v6/DB import export

Related solutions
1. Dude v6 - Backup to FTP
You do not have the required permissions to view the files attached to this post.
Last edited by stmx38 on Fri May 05, 2023 6:02 am, edited 1 time in total.
 
excession
Frequent Visitor
Frequent Visitor
Posts: 95
Joined: Mon May 11, 2015 8:16 pm

Re: Dude v6 - Backup locally

Thu Aug 16, 2018 5:12 pm

This saved me a lot of time, thanks for sharing.
 
simogere
Frequent Visitor
Frequent Visitor
Posts: 56
Joined: Fri May 24, 2013 11:54 am

Re: Dude v6 - Backup locally

Wed Jan 04, 2023 1:11 am

Hi @stmx38, thanks for the tips.

A simple question:

Image

Why the backup db is half the size of the original db?
 
User avatar
stmx38
Long time Member
Long time Member
Topic Author
Posts: 615
Joined: Thu Feb 14, 2008 4:03 pm
Location: Moldova, Chisinau

Re: Dude v6 - Backup locally

Thu Jan 05, 2023 6:37 am

Hello @simogere, I'm out of the topic now and can't reproduce and check it.

Can it be related to the DB vacuum effect?
Manual:The Dude v6/DB import export does not provide so much details.

If you have an assumption that you lose some data, probably it can be better to restore that backup on another device and check if all is in place.

Who is online

Users browsing this forum: No registered users and 8 guests