user backup & copy

«

Previous topic

|

|

Next topic

»

Author	Message
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
Rinze Cats	Tuesday 19 October 2004 1:12:15 am Hi guys and thanx for the replies These 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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing:	Jan 31 2025 06:25:33
Script start
Timing:	Jan 31 2025 06:25:33
Module start 'layout'
Timing:	Jan 31 2025 06:25:33
Module start 'content'
Timing:	Jan 31 2025 06:25:33
Module end 'content'
Timing:	Jan 31 2025 06:25:33
Script end

Main resources:

Total runtime	0.0130 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0044	588.0156	151.1953
Module start 'layout'	0.0044	0.0027	739.2109	36.6172
Module start 'content'	0.0071	0.0038	775.8281	90.1250
Module end 'content'	0.0109	0.0020	865.9531	33.9922
Script end	0.0129		899.9453

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0022	17.0536	14	0.0002
Check MTime	0.0010	8.0301	14	0.0001
Mysql Total
Database connection	0.0006	4.5605	1	0.0006
Mysqli_queries	0.0024	18.5364	3	0.0008
Looping result	0.0000	0.0920	1	0.0000
Template Total	0.0017	12.9	1	0.0017
Template load	0.0009	6.6356	1	0.0009
Template processing	0.0008	6.2272	1	0.0008
Override
Cache load	0.0006	4.3986	1	0.0006
General
dbfile	0.0003	2.1634	8	0.0000
String conversion	0.0000	0.0607	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs