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

[Sebastian Birnbach]

Mike,

you're right with your objections. I was lucky there were no attachments
and I simply mapped everything to one user. Not the most elegant solution
but sure a quick one.

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

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