Can't Import Solution - Error max_allowed_packet?

Classic Servoy
1

Hi Folks

When importing a solution through /servoy-admin (the solution was exported with up to 100000 records) I get the error:

com.servoy.j2db.persistence.RepositoryException: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1063274>1048576). You can change this value on the server by setting the ‘max_allowed_packet’ variable.

I’m setting up a new MySQL Db and I’m not sure if this variable is in MySQL or Servoy.

If its in MySQL where might I look to set that variable?

2

Hi Kahuna,

This is a MySQL variable.
You can set it per session via the commandline or set it in the my.cnf file.

See http://dev.mysql.com/doc/refman/5.0/en/ … ables.html

Hope this helps.

3

ROCLASI:
Hi Kahuna,

This is a MySQL variable.
You can set it per session via the commandline or set it in the my.cnf file.

See http://dev.mysql.com/doc/refman/5.0/en/ … ables.html

Hope this helps.

Brilliant Robert - thanks for that - I’ll fix it tomorrow.

Cheers