I tried opening the file as zip and yes, it is broken. I also tried importing the database script file but it just seems to die after a w while, I must be doing it wrong: mysql -u xwiki -p xwiki < xwiki_db.sql Enter password: ***** ERROR 2006 (HY000) at line 1: MySQL server has gone away
The export tool dies at 6mb and in the log the following is recorded: 2010-01-11 08:47:51,935 [http://dbaierxpa:8080/xwiki/bin/export/XWiki/Export?editor=globaladmin§ion=Export] INFO .AbstractXWikiMigrationManager - No storage migration required since current version is [15429] 2010-01-11 08:48:08,326 [http://dbaierxpa:8080/xwiki/bin/export/XWiki/Export?editor=globaladmin§ion=Export] WARN web.XWikiAction - Uncaught exception: Error number 0 in 11: Uncaught exception Wrapped Exception: Java heap space com.xpn.xwiki.XWikiException: Error number 0 in 11: Uncaught exception Wrapped Exception: Java heap space at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:238) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) ... Wrapped Exception: java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(Unknown Source) at java.lang.AbstractStringBuilder.expandCapacity(Unknown Source) at java.lang.AbstractStringBuilder.append(Unknown Source) at java.lang.StringBuffer.append(Unknown Source) ... I run a jetty service, with setting wrapper.java.maxmemory=256 so it seems weird that it would run out of memory? Also, I know little about servlet containers, are there any benefits of migrate to tomcat over jetty? daniel ________________________________ From: tmortagne [via XWiki] [mailto:ml-node+4279359-1043483...@n2.nabble.com] Sent: Saturday, January 09, 2010 2:50 PM To: Daniel Johansson Subject: Re: [xwiki-users] Migrate to Mysql On Sat, Jan 9, 2010 at 02:19, Aplamon <[hidden email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4279359&i=0>> wrote: > > I have been using the standalone package (2.04) for some time and now our > wiki is starting to grow. So I wanted to migrate over to a Mysql database. I > have setup the default wiki in Mysql, that works. Now I want to move over > all the content. I thought I could just export a xar file and then import it > into my Mysql instance. But first off the xar file is only like 6megs big > and second when I try to import it the tool says there are no documents in > it. Could you check if the generated xar is valid ? It's supposed to be a zip file containing each page as XML files, you can simply rename it to <file>.zip to open it. The is some issues to export/import big wikis in the default distribution, we are working on it. In the meantime you can use http://code.xwiki.org/xwiki/bin/view/Snippets/LargeWikiExportSnippet (first script) and http://code.xwiki.org/xwiki/bin/view/Snippets/LargeXARImportScriptSnippet > > Also, are attachment exported? We have a few rather large files as > attachments so 6 megs seems really small. Yes attachments are exported. > > Thank you > Daniel > -- > View this message in context: > http://n2.nabble.com/Migrate-to-Mysql-tp4275838p4275838.html > Sent from the XWiki- Users mailing list archive at Nabble.com. > _______________________________________________ > users mailing list > [hidden > email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4279359&i=1> > http://lists.xwiki.org/mailman/listinfo/users > -- Thomas Mortagne _______________________________________________ users mailing list [hidden email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4279359&i=2> http://lists.xwiki.org/mailman/listinfo/users ________________________________ View message @ http://n2.nabble.com/Migrate-to-Mysql-tp4275838p4279359.html To unsubscribe from Migrate to Mysql, click here< (link removed) >. -- View this message in context: http://n2.nabble.com/Migrate-to-Mysql-tp4275838p4286620.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
