Importing table with graphix from Access into MySQL

[KUZZ]

i have a table in a MSACCESS DB with the following fields:

PTNR = PART NUMBER (varchar, 20)
REV = REVISION (int, 3)
PIC1 = PICTURE #1 (OLE OBJ = to longblob in mysql)
PIC2 = PICTURE #2 (OLE OBJ = to longblob in mysql)


I am trying to import this table using ODCB drives and SQLyog (GUI, for MySQL databases). I cannot make it work. I have tried pushing the data in from an Access DB using update queryes, i tried pulling the data in from SQLyog in both cases using ODCB drivers. I can't make it work.

some PIC1 and PIC2 fileds have pictures store in them
some have only pic1, some only pic2 and others have null in both fields.

The query that imports the data into mysql db craps out when it reaches the fields with data in them. Has anyone tried to import tables with graphix in them from access inty mysql and succeded? If so, HOW?!!!
Good luck,
Kuzz

"Time spent debating the impossible subtracts from the time during which you
can try to accomplish it."



Good luck,
Kuzz

"Time spent debating the impossible subtracts from the time during which you
can try to accomplish it."

 

[KUZZ]

solution is increase to desired size variable max_allowed_packet. For import purposes i just put a 1GB figure. Worked just fine

Good luck,
Kuzz

"Time spent debating the impossible subtracts from the time during which you
can try to accomplish it."