On May 14, 2008, at 2:15 PM, Sergiu Dumitriu wrote: > [EMAIL PROTECTED] wrote: >>> Vincent Massol wrote: >>>> Hi, >>>> >>>> This is a known issue, see http://jira.xwiki.org/jira/browse/ >>>> XWIKI-2339 for a solution to the problem. >>>> >>>> Thanks >>>> -Vincent >>>> >>>> On May 13, 2008, at 10:09 AM, [EMAIL PROTECTED] >>>> wrote: >>>> >>>>> java.sql.BatchUpdateException: Packet for query is too large >>>>> (1458818 > >>>>> 1048576). You can change this value on the server by setting the >>>>> max_allowed_packet' variable. >>>>> at >>>>> com >>>>> .mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java: >>>>> 1404) >>> No, it's not that one, it is a mysql setting. See >>> http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html >>> -- >>> Sergiu Dumitriu >>> http://purl.org/net/sergiu/ >>> _______________________________________________ >>> users mailing list >>> [email protected] >>> http://lists.xwiki.org/mailman/listinfo/users >> >> Hi, >> I started Mysql with >>> mysql -u root -p --max_allowed_packet=32M >> and again tried to import but it shows the same error. > > That starts a mysql client, not the server. The best would be to > change > the my.cnf configuration file with: > > [mysqld] > max_allowed_packet=32M
that's the best indeed. if you really want the command line, I use something like: sudo /usr/local/mysql/bin/mysqld_safe --user=mysql -- max_allowed_packet=32M -Vincent _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
