ERROR 2006 (HY000) at line 1: MySQL server has gone away => http://dev.mysql.com/doc/refman/5.0/en/gone-away.html Check if max_allowed_packet=32M in my.cnf => http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL
Arnaud 2010/1/11 Aplamon <djohans...@haascnc.com>: > > 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 > _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
