Updating MYSQL

Posted on 2007-10-04
Medium Priority
Last Modified: 2008-01-09
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'
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?????

Question by:gvector1
  • 2
  • 2
LVL 17

Accepted Solution

Aleksandar Bradarić earned 2000 total points
ID: 20015895
Try dumping the DB using `--fields-escaped-by=""`. This should encolse all BLOB data and should have no problems restoring it.

Author Comment

ID: 20112680
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??????
LVL 17

Expert Comment

by:Aleksandar Bradarić
ID: 20117359
Not that I know of... Maybe someone else has a better idea...

Author Comment

ID: 20181698
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.


Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month15 days, 16 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question