[horde] How to copy all Horde preferences from one user to another user?

[Michael J Rubinsky]

Quoting ersrpca001 ersrpca001 <ersrpca001 at hotmail.com>:

> Hi,
>
> How can I copy all Horde preferences from one user to another user?
> Example:
> Copy all Horde preferences from user1 at mydomain to user2 at mydomain
>
> I need preferences from all Horde modules (Horde, Imp, Mnemo, etc).
> I am using Horde in a CentOS server with cPanel, which uses a sqlite
> database.
> I have found some information on Google, but I'm not sure.
>
> It would be great if I could just run a sql command in a similar way Jan
> wrote in here in a different situation:
> https://lists.horde.org/archives/horde/Week-of-Mon-20051010/028971.html
> DELETE FROM horde_prefs WHERE pref_uid='jake' AND pref_scope='nag';

Well, you _could_ do something like:

UPDATE horde_prefs SET pref_uid='user2' WHERE pref_uid='user1';

but be sure you have a backup of the database and inspect the results  
of this operation closely. Be aware that there could very well be  
values in those preferences that reference the username or email  
address. Things like Identity preferences etc...


> I have also read this page:
> https://wiki.horde.org/ApplyGlobal
> but I didn't find additional information about this way in Google and
> also I think this doesn't apply to sqlite databases.
>
> Any help would be appreciated.
>
> Pedro
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org



-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 9272 bytes
Desc: PGP Public Key
URL: <https://lists.horde.org/archives/horde/attachments/20200229/c820d540/attachment.key>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 851 bytes
Desc: PGP Digital Signature
URL: <https://lists.horde.org/archives/horde/attachments/20200229/c820d540/attachment.sig>