[dev] migrating 'wicked' content from one installation to another

[Sebastian Birnbach]

Mike,

I'd sure contribute a script improvement to Horde, only the case is already
closed. I used phpMyAdmin to export wicked_pages, wicked_history and
wicked_schema_info on the one host and re-imported them on the other. The
generated *.sql files are pretty nice, it was really easy to
search-and-replace all the fields I wanted to in a text editor. The files
are also well-structured and very well readable. Re-import via phpMyAdmin
or mysql was easy, too.

The same procedure also worked well for turba. I skipped the turba_sharesng
and turba_sharesng_groups tables because I have no shared address books and
groups were not yet setup on the target system. Everything worked really
smooth, some errors were thrown but they proved to be insignificant.

  Sebastian

2015-06-24 20:38 GMT+02:00 Michael J Rubinsky <mrubinsk at horde.org>:

>
> Quoting Sebastian Birnbach <birnbacs at gmail.com>:
>
>  Dear all,
>>
>> what is the recommended way of migrating wiki pages in the 'wicked'
>> application from one host to another? Both sites run the same version of
>> wicked so it might be done by exporting the SQL tables
>>
>> wicked_pages
>> wicked_history
>> wicked_attachments
>> wicked_attachment_history and
>> wicked_schema_info
>>
>> on the one side and incecting them on the other side. I am hesitating to
>> do
>> that, though, because the users on both systems may not match.
>>
>> Of course there is always the possibility of copy-pasting the source code
>> of each page from one system to the other but that would be rather tedious
>> on a larger system and the history and the attachments would be lost.
>>
>
>
> You will probably need to write a script to migrate the data, mapping any
> different/missing users. You will also need migrate the VFS data too, since
> this is where the attachments are stored. There is a bare-bones CLI script
> in wicked/bin that outputs the page contents to XML but unfortunately
> nothing to import into a new install. Perhaps you can extend that script...
>
> --
> mike
> The Horde Project
> http://www.horde.org
> https://www.facebook.com/hordeproject
> https://www.twitter.com/hordeproject
>
> --
> dev mailing list
> Frequently Asked Questions: http://wiki.horde.org/FAQ
> To unsubscribe, mail: dev-unsubscribe at lists.horde.org
>