Hi there,
I'm trying to export a pictures table, my mySQL database table already
exists so I have linked both tables in Access and I tried to run a
simple append query in Access to export the data but I either :
- lose the connection to mySQL
- have packets that exceed max_allow_packet
I have tried different things to set max_allow_packet to a higher
value which seems to be 1M by default. I want it to be 1G like setting
the value at run-time from the prompt but it seems that no matter what
I tried, I either get the syntax wrong or the command is simply
ignored.
I have also added in my.cnf, the following lines :
[mysql]
max_allowed_packet=1G
[mysqld]
max_allowed_packet=1G
This is also ignored completely and max_allowed_packet remains at 1M
no matter what I try and the append query in Access fails.
Any clues ?
Thanks,
Alban