Forums / Developer / user backup & copy
Rinze Cats
Monday 18 October 2004 2:10:28 am
I have a set of users and roles that I need to use for a number of sites. Is there a way to copy them from one site(database) by using an sql export and import them into another?
thanx rinze
Frederik Holljen
Monday 18 October 2004 4:03:51 am
You can export/import users using packages (available from the setup tab).setup -> packages -> new package -> content object export
There is currently no way to export / import roles.
Marco Zinn
Monday 18 October 2004 1:25:29 pm
I guess, you could export roles and permissions by dumping the SQL tables for these things. But that's a pain. IF you do this, you should dump and import ALL roles and permissions, overwriting your "old" roles/permissions on the "slave" systems.This may be an option, if you can live with completly identical roles&permissions in all installations.
Proceed with extreme caution, when handling users, roles and permissions. You may "lock out" your users faster than you can says "ooops"!!!! Do backups! Do backups!
Marco http://www.hyperroad-design.com
Tuesday 19 October 2004 1:12:15 am
Hi guys and thanx for the repliesThese are fresh installs, so locking out users at this stage is no problem. Does anyone know which tables should I export to copy all role/user information?
rinze