We help IT Professionals succeed at work.

Updating MYSQL

gvector1
gvector1 asked
on
603 Views
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'
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
Comment
Watch Question

Software Developer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
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ćSoftware Developer
CERTIFIED EXPERT

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

Author

Commented:
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,

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.