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. Also, are attachment exported? We have a few rather large files as attachments so 6 megs seems really small. 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 users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

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.

Also, are attachment exported? We have a few rather large files as attachments so 6 megs seems really small.

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=427935… http://lists.xwiki.org/mailman/listinfo/users

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&…] 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&…] 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-1043483983@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=427935… wrote: 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 Yes attachments are exported. -- Thomas Mortagne _______________________________________________ users mailing list [hidden email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=427935… 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(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users