472,342 Members | 1,830 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,342 software developers and data experts.

problem with blob field in mysqldump

I'm trying to dump a bugzilla installation to a file, then restore it
to a different database name (so as to test my db backup system).

I use mysqldump to dump it to a file:
# mysqldump -u root -p<passwd> (misc. options) bugs > bugs.sql

Then try to restore it to an empty DB, "foobar" with this command
# mysql -u root -p<passwd> foobar < bugs.sql

It fails, with this not-too-helpful error:
ERROR at line 163:

The failure is in the first table from bugzilla, "attachments", which
has a blob field called "the_data" of which I have no doubt is the
cause of the failure. I'm hypothesizing that it's failing because of
newline characters in the the_data field of some records, but I have
not been able to confirm that.

I have tried the following mysqldump options in varying combinations,
and none helped the issue:
--extended-insert
--quote-names
--opt
--set-variable 'net_buffer_length = 1048576'

If I skip the attachments table in the mysqldump the database restores
perfectly.

Anyone have any ideas how to solve this issue? If not, how to debug it
further? I'm seriously stuck.

My mysql server is 3.23.58

thanks,
Ben

Jul 20 '05 #1
0 2143

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Terry A. Haimann | last post by:
I have an application, DipperBase, that keeps astronomical images in a mysql database. The actual images are stored in a blob field. To get some...
0
by: qhe | last post by:
Dear All: I'm using MyODBC 3.51.06 and MySQL 4.0.18. My table has a mediumblob field, but I can't update/insert data larger than 64K. The test...
0
by: Garrett Kajmowicz | last post by:
I'm needed to insert large BLOBs into a database. With the 1MB packet limit, sending larger amounts of data would be difficult, so I had a neat...
6
by: Pierre-Benoit | last post by:
Hi there, I've a strange problem with ado.net and an Access db. I need to create a little C# app that take the content of "ole object" field and...
11
by: Chris Fink | last post by:
I have setup an Oracle table which contains a blob field. How do I insert data into this field using C# and ADO.net?
0
by: Big George | last post by:
Hello, I'm trying to save a jpg file of 300KB as a BLOB field in an Oracle 10g Database. If I try to call a Stored Procedure, it fails. If I use...
12
by: NOO Recursion | last post by:
Hi everyone! I am trying to write a program that will search a 12x12 for a thing called a "blob". A blob in the grid is made up of asterisks. A...
11
by: krishnakant Mane | last post by:
hello, I finally got some code to push a pickled list into a database table. but now the problem is technically complex although possible to solve....
55
ADezii
by: ADezii | last post by:
Of all the questions asked here at TheScripts, the one which appears with the most frequency relates to the storing of Graphic Images within Access....
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.