Re: [xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1

Hi Vincent, As per your suggestion in below answer I went through the page “http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Backup#HUsingtheXWikiExportfeature” For Xwiki export and database backup to migrate to new version. I still have one doubt that we are using virtual wikis and currently we have one DB created for one virtual Wiki. So We have one DB for main Wiki as Xwiki and multiple DBs for multiple created virtual Wikis. In the above referred page it only talks about main Wiki page export and main Xwiki DB backup. I would like to know that what should we do for our virtual Wikis and their DBs ? Do we need to export each virtual Wiki and its created DB separately ? Also Please suggest on DB indexing part as asked in below email as well. Thanks a lot Vincent for your help. Thanks & Regards, Piyush -----Original Message----- From: Kumar, Piyush Sent: Wednesday, September 28, 2016 8:04 PM To: XWiki Users Subject: RE: [xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1 Hi Vincent, Regarding DB indexing I would like to tell you that I already created below indexes as per the page http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration to deal with performance but could not get any benefit. Sice we are having 4.2 version at production, we created below mentioned indexes in our MySQL DB. Indexes for XWiki Enterprise versions after 3.2 create index xwl_value on xwikilargestrings (xwl_value(50)); create index xwd_parent on xwikidoc (xwd_parent(50)); create index xwd_class_xml on xwikidoc (xwd_class_xml(20)); create index xws_number on xwikistatsdoc (XWS_NUMBER); create index xws_classname on xwikistatsdoc (XWS_CLASSNAME); create index xwr_number on xwikistatsreferer (XWR_NUMBER); create index xwr_classname on xwikistatsreferer (XWR_CLASSNAME); create index xwr_referer on xwikistatsreferer (XWR_REFERER(50)); create index xwv_user_agent on xwikistatsvisit (XWV_USER_AGENT(255)); create index xwv_cookie on xwikistatsvisit (XWV_COOKIE(255)); create index xwv_classname on xwikistatsvisit (XWV_CLASSNAME); create index xwv_number on xwikistatsvisit (XWV_NUMBER); create index ase_requestid on activitystream_events (ase_requestid(200)); create index ase_page_date on activitystream_events (ase_page, ase_date); create index xda_docid1 on xwikiattrecyclebin (xda_docid); create index ase_param1 on activitystream_events (ase_param1(200)); create index ase_param2 on activitystream_events (ase_param2(200)); create index ase_param3 on activitystream_events (ase_param3(200)); create index ase_param4 on activitystream_events (ase_param4(200)); create index ase_param5 on activitystream_events (ase_param5(200)); Thanks & Regards, Piyush -----Original Message----- From: users [mailto:users-bounces@xwiki.org] On Behalf Of Vincent Massol Sent: Friday, September 23, 2016 6:33 PM To: XWiki Users Subject: Re: [xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1 Reply from Vincent : It is. Actually what you’ve done (stay very long on a very old version is not such a good idea ;) (will make the upgrade a lot more complex). Since you’re using a very old version you may want to export your data, install XWiki 8.2.1 and import your data. However see the limitations at http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Backup#HUsingtheXWikiEx… Reply from Vincent : Re performance you can get good perf in 4.2 too. If I had to guess I’d say you’re missing indexes in the DB, see http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances Thanks -Vincent Reply from Vincent : PS: Since this is a complex operation, I’d highly suggest that you hire some xwiki experts. There are companies offering such expertise and that are sponsoring the development of the xwiki project. See http://www.xwiki.org/xwiki/bin/view/Main/Support#HProfessionalSupport _______________________________________________ users mailing list users@xwiki.org<mailto:users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users