Once i read the article here about storing binary data in a mysqldatabase and started using it to let people upload images.
now i have to move my database to an other server so i dump the tables on the old server using mysqldump and then insert them into the new one.
all goes well except for the binary data.
the images get all screwed up like half the data is missing.
I have searched and searched but couldn't find any solution to this.
If someone has any id on how to solve this. plz let me know.
ps. copying the phisical database files isnt an option coz i do not have acces to them.
now i have to move my database to an other server so i dump the tables on the old server using mysqldump and then insert them into the new one.
all goes well except for the binary data.
the images get all screwed up like half the data is missing.
I have searched and searched but couldn't find any solution to this.
If someone has any id on how to solve this. plz let me know.
ps. copying the phisical database files isnt an option coz i do not have acces to them.