Copy mysql blob field from one database to the other?

11MB isn't a huge file, I'm surprised your host has such a low max upload size. Have you thought about exporting as SQL, splitting the file in two (in Notepad++ or something) then uploading it in smaller sections? Wouldn't take long.

1 - In terms of speed, I suspect this is probably the way to go. – middaparka Feb 2 '10 at 12:46 hmmm... that sort of worked but the blobs remain empty. – half-a-nerd Feb 2 '10 at 15:15.

Perhaps check to see if you can increase the max_allowed_packet setting on your mysql DB. I'm not sure if it affects inserts, but I remember having to adjust this setting when I worked on a web-app that allowed users to download 3-5MB binaries from blob fields in the DB. This link may be helpful, from a quick google search: astahost.com/info.php/max_allowed_packet....

Might work, but I am not allowed to change that. – half-a-nerd Feb 4 '10 at 12:27.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.