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

[Michael J Rubinsky]

Quoting Sebastian Birnbach <birnbacs at gmail.com>:

> 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.

Sure, that's fine, but your original post mentioned that the usernames  
might not be the same across the installations - so your imported  
tables will have incorrect users. Also, if this is all you did, you  
most likely lost any attachments. They will still show on the wiki  
page, but the actual data might not be present (depending on if you  
properly migrated the VFS also...).



> 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
>>



-- 
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: smime.p7s
Type: application/pkcs7-signature
Size: 5869 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/dev/attachments/20150624/c4badb14/attachment.bin>