Updating MYSQL

Posted on 2007-10-04
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
    LVL 17

    Accepted Solution

    Try dumping the DB using `--fields-escaped-by=""`. This should encolse all BLOB data and should have no problems restoring it.

    Author Comment

    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

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

    Author Comment

    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

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
    Both Easy and Powerful How easy is PHP? (  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now