MySQL Forums
Forum List  »  Backup

MySQL Dump and Data Load for InnoDb DB storing binary Data
Posted by: Mariella Di Giacomo
Date: April 25, 2006 06:22PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Dump and Data Load for InnoDb DB storing binary Data
6344
April 25, 2006 06:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.