how to Backup userman configuration

hajid · October 6, 2006, 3:15am

hi all,

how to backup user database and userman configuration ? and restore at new ROS.

sergejs · October 6, 2006, 5:35am

you can try ‘/tool user-manager export’ and then ‘import’ to another router.

hajid · October 10, 2006, 12:15pm

i got this error :

[admin@MikroTik] > import userman.rsc
Opening script file userman.rsc
Script file loaded and executed successfully
input does not match any value of subscriber

please help. urgent

sergejs · October 10, 2006, 1:55pm

Please provide the content of the used export file.

sergejs · October 10, 2006, 2:25pm

You have the problem with importing, because of ‘tool user-manager customer’ configuration exported to the end of *.rsc file,
but routers, users and credits belong to customer.

Issue will be fixed in the next RouterOS version (customer information will be placed/imported correctly).

Giepie · April 15, 2007, 2:52pm

I am trying to export user settings from my 2.9.42 (RB532) MT to the new V3Beta7 (PC Based) MT.

I used /tool user-manager export date to export the settings.

When I go to the V3Beta7 MT, I user /tool user-manager import, but it does not recognize the import command, only export command. Is this a bug or am I missing something?

I have also tried to import it under users, but with no success.

Any help will be greatly appreciated.

G

atheros · May 2, 2007, 8:58am

wat is the final story ?

Giepie · May 2, 2007, 2:35pm

Hi Atheros

No replies about it yet, I reckon MT are in the process of fixing the bug.

It’s been several weeks now that I’m trying to move my growing user base to authenticate on my new dedicated router PC, but with the missing IMPORT command, I just have to wait.

Re, G

ChildOTK · June 2, 2007, 9:34pm

Hey Guys,

I dont know if your problem still exists, I also got the same errors while using the

/tool user-manager export

command.

Now, I have come to a solution, what I did is,

/tool user-manager router export file=router

I did this for each ‘section’ or user-manager, i.e. customer, user, and router, copied the files to me new router, and imported them individually, and this worked.

/import customer
/import user
/import router

Only problem is this does not keep the users bandwidth usage and session logs, if anybody knows how to get this then please let me know

I hope this helps you guys

Giepie · June 2, 2007, 10:44pm

Hey Darren (ChildOTK)

Thanks for your reply. I also got it working as follow:

/tool user-manager database load name=whatever

This imported everything, even the usage, but it sort of corrupted the database. When I tried to select all users and reset their bandwidth for the next month (luckily this UM server is not live yet), it kept telling me I first need to select at least one user. Then I did:
/tool user-manager database reset. This fixed the database and had all the users. Please note I exported from V2.9.41 to V3b7&8

What I think we all need are the following:

The ability to export EVERYTHING for backup purposes (backup of individual sections would also be helpful for if you only want to import your user database but no router or usage settings)
The ability to export usage to CSV file for accounting purposes
The ability to import ALL data from CSV file. This would be nice if you need to edit something between export and import.

Regards, Giepie