hello all,
Top of the day to you all. How do i write a script to back up usermanager data everyday at 3pm? I have to do a manual back up of usermanager data each time using the terminal mode...[admin@MT] tool user-manager database..
Urgent help needed pls.
Copy and paste this:
This should save your user-manager database everyday at 15:00 to a file named "userman.umb". You could restore this database using the "/tool user-manager database load name=userman" command.
Explanation: The originally posted command (starting directly with "add ..." will only work if you are at the "/system scheduler" hierarchy of the console, i.e. your console prompt does already show " system scheduler>"...
Best regards,
Christian Meis
Code: Select all
/system scheduler add name="backup_userman_database" on-event="/tool user-manager database save name=userman" \
start-date=jan/01/1970 start-time=15:00:00 interval=1d comment="" \
disabled=noExplanation: The originally posted command (starting directly with "add ..." will only work if you are at the "/system scheduler" hierarchy of the console, i.e. your console prompt does already show " system scheduler>"...
Best regards,
Christian Meis
-
-
shawnsmith
just joined
- Posts: 12
- Joined:
Re: script to backup usermanager data everyday
I have been backing up the userman db with this script now, but when i try to restore, it gives me the following error.:
> tool user-manager database load name=userman.umb
Restore user-manager database? [y/N]: y
Loading user-manager database backup
Failed to load user-manager database backup
broken file
Any ideas ? i have tried this on a different RB and it gives me the same error ??
my script looks like this :
/tool user-manager database save name=userman
Any help would be appreciated.
> tool user-manager database load name=userman.umb
Restore user-manager database? [y/N]: y
Loading user-manager database backup
Failed to load user-manager database backup
broken file
Any ideas ? i have tried this on a different RB and it gives me the same error ??
my script looks like this :
/tool user-manager database save name=userman
Any help would be appreciated.
Re: script to backup usermanager data everyday
I can replicate this, but I can't find a way to make this work. Did you get any resolution?
-
-
shawnsmith
just joined
- Posts: 12
- Joined:
Re: script to backup usermanager data everyday
No, i still have this problem. I have no idea as to what is causing it or how to resolve it.
How did you replicate the error ?
How did you replicate the error ?
Re: script to backup usermanager data everyday
Replication was on a 2.9.46 RB5XX build. Just did a /tool user-manager database save name=file then a corresponding load. I haven't tried this on an x86 build or on 3.0rc4. Currently, I'm using an export to get a backup.
Re: script to backup usermanager data everyday
Just tested the backup and restore (save/load) of the user manager database on an Intel based router and it worked fine. This suggests an endian problem with the code because this only fails for me on MIPS based routers.
-
-
shawnsmith
just joined
- Posts: 12
- Joined:
Re: script to backup usermanager data everyday
If you are using the /tool user-manager export feature to backup your DB, how do you restore the exported data ?
Shawn
Shawn
Re: script to backup usermanager data everyday
Very carefully. It's a manual and tedious process. Instead, I just moved my User Manager to an Intel box.
Re: script to backup usermanager data everyday
Hi Shawn
What version of MT are you running on the UM you wish to backup?
If my mind serves me right, the very first versions of UM could not be restored to the later versions, so you first had to upgrade your UM system and then do a backup.
I hope this is helpful.
G
What version of MT are you running on the UM you wish to backup?
If my mind serves me right, the very first versions of UM could not be restored to the later versions, so you first had to upgrade your UM system and then do a backup.
I hope this is helpful.
G
Re: script to backup usermanager data everyday
Sorry for bringing up an almost 2 year old thread but I feel this is relevant to the subject......
Is there a way to have an external server independant to the Usermanager back up the database remotely instead of having it just on the UserManager just incase the Usermanager's data is lost due to a fault?
Is there a way to have an external server independant to the Usermanager back up the database remotely instead of having it just on the UserManager just incase the Usermanager's data is lost due to a fault?
Re: script to backup usermanager data everyday
Yes, you could backup the usermanager's database, then use external tools like scp or ftp to pull the file off the router and onto the target. SSH or API could be used to trigger the backup remotely and run the necessary command on the router itself.Sorry for bringing up an almost 2 year old thread but I feel this is relevant to the subject......
Is there a way to have an external server independant to the Usermanager back up the database remotely instead of having it just on the UserManager just incase the Usermanager's data is lost due to a fault?
Hope this helps,
Re: script to backup usermanager data everyday
This is hapening because you have active hotspot or ppp users ... you must do backup when is no active users ... or disconect all active usersI have been backing up the userman db with this script now, but when i try to restore, it gives me the following error.:
> tool user-manager database load name=userman.umb
Restore user-manager database? [y/N]: y
Loading user-manager database backup
Failed to load user-manager database backup
broken file
Any ideas ? i have tried this on a different RB and it gives me the same error ??
my script looks like this :
/tool user-manager database save name=userman
Any help would be appreciated.
Re: script to backup usermanager data everyday
Following on from this script here below, would it be possible to introduce a check to see if any users are active, and if so, wait 5 minutes (loop).
Code: Select all
/system scheduler add name="backup_userman_database" on-event="/tool user-manager database save name=userman" \
start-date=jan/01/1970 start-time=15:00:00 interval=1d comment="" \
disabled=no
Re: script to backup usermanager data everyday
easier is to disconnect all active users ...
-
-
stenlycicero
just joined
- Posts: 3
- Joined:
Re: script to backup usermanager data everyday
sorry for bringin up this old thread.
is there anyway to recover "broken file" of User manager umb database ?
i've experience this problem after incidentally backup with several of users in active mode.
and the router is just being netinstalled.
is there anyway to recover "broken file" of User manager umb database ?
i've experience this problem after incidentally backup with several of users in active mode.
and the router is just being netinstalled.
Re: script to backup usermanager data everyday
You should be able to rebuild the DB with this command:
/tool user-manager database rebuild
I've had to done it a few times. It is not always sucessful though.
Hope it helps
G
/tool user-manager database rebuild
I've had to done it a few times. It is not always sucessful though.
Hope it helps
G
-
-
stenlycicero
just joined
- Posts: 3
- Joined:
Re: script to backup usermanager data everyday
i've done the rebuild and it's successful restore the old one backup file.
when i trying to restore the latest backup file, it's still comes with the same error: broken file.
as long as i remember, when the "save" process executed, there are several user in active mode.
when i trying to restore the latest backup file, it's still comes with the same error: broken file.
as long as i remember, when the "save" process executed, there are several user in active mode.
Who is online
Users browsing this forum: No registered users and 7 guests