Transferring Blob Data

[rivka]

I'm moving to a new server, and have a table that has some data stored in a blob field. Using phpmyadmin to dump the data just gives a bunch of binary nonsense -- what do I need to do to be able to transfer this blob data?

[daphreeek]

Well when I tried the same, I got the exact value of the blob field in the dump output.

But the reason u get a binary output is possibly because a blob is binary.

2 my knowledge, if u use the output from the phpmyadmin dump as an sql command on the new database, it should work.

Try it. If it doesnt work, then you can write a php script which will get the info from the database and then put it on the new one 🙂

• Matt

[[deleted]]

mysqladmin 'should' work, and the binary 'nonsense' is ofcourse your data.

But it is much better to use mysqldump instead. Ask your host for help if you cannot get to mysqldump yourself.