exporting binary data from Access 2000 into mySQL 4.1.5 gamma

[Alban Gerome]

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_packe t

I have tried different things to set max_allow_packe t 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_pac ket=1G
[mysqld]
max_allowed_pac ket=1G

This is also ignored completely and max_allowed_pac ket remains at 1M
no matter what I try and the append query in Access fails.

Any clues ?

Thanks,

Alban

[Rick Lones]

Re: exporting binary data from Access 2000 into mySQL 4.1.5 gamma

Evidently, "1G" is not parsed as a number.

SET max_allowed_pac ket = 1073741824;

.. . . worked for me, at least through Control Center using the 4.1
version, no reason to think it wouldn't also work from the command line.
My documentation says that the limit is 16M (16777216) if your version
is 3.x or earlier.

HTH,
-rick-

Alban Gerome wrote:
[color=blue]
> 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_packe t
>
> I have tried different things to set max_allow_packe t 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_pac ket=1G
> [mysqld]
> max_allowed_pac ket=1G
>
> This is also ignored completely and max_allowed_pac ket remains at 1M
> no matter what I try and the append query in Access fails.
>
> Any clues ?
>
> Thanks,
>
> Alban[/color]