MySQL Dump and Data Load for InnoDb DB storing binary Data

[Mariella Di Giacomo]

Hi,

I have been running mysql-max-5.0.15-linux-i686-glibc23.
I have created and loaded a DB containing several InnoDB tables and
one MyISAM table containing binary data (binary file stored in a LONGBLOB field).

I need to backup the DB and loaded into another DB.

I have used mysqldump (mysqldump --max_allowed_packet=200M .....) to dump the DB (while nobody was using it).

When I have tried to use mysql command to load the data back into a MySQL DB
I got the error.
In particular the error refers to loading the table with the binary content
-----------------------------------------------------------------------
ERROR 1064 (42000) at line 85: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump: Error 2013).
-----------------------------------------------------------------------

One possible alternative could be to use mysqldump for the ASCII data fields tables and cp for the MyISAM table that contains binary data.

In the case I would have used an InnoDB table (like I have in another MySQL DB) for storing the binary data (LONGBLOB)
How could I dump and reload the schema and content of that table without getting errors ?

Could you please help ?
Thanks in advance for your help,

Mariella