asked on

Updating MYSQL

I am trying to migrate some data from one MySql Database to another and have a problem. I do a dump of a table that contains a blob field that I use to store an image. When I go to load that dump into another database table I get errors like the following:

Error at line 819: Unknown command '\0'
or
Error at line 1974: Unknown command '\Z'

How can I successfully migrate a blob field's contents from one database table to another using a dump?????

Thanks
Kendal

ASKER CERTIFIED SOLUTION

Aleksandar Bradarić

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gvector1

ASKER

In order to use that option, I have to also use the --tab option which creates a .sql file for creating the table and a .txt file with the actual data. I then have to go down the line and execute a mysql + .sql file to create each table then go back and do a load data infile with the .txt data dumps. Any other approaches to accomplish this??????

Aleksandar Bradarić

Not that I know of... Maybe someone else has a better idea...

gvector1

ASKER

Okay, I have gotten through the upgrade. I will award you the points as you have helped me solve my problem. I ended up doing a complete dump of the database and loading into the new version. I then ended up doing a "select into outfile fields enclosed by" statement and then using a load data infile command to reload the table that had the blob fields that were causing the problems. That ended up working for me.

Thanks,