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