Backup Table w/ binary Data?

[Anon]

Hi, Im trying to move my website to a different server and am having trouble making a backup of a table for my message board that stores an image as binary data in the table.

I dont have telnet/shell access, and have tried using MySQLFront to backup, but the pictures (binary data) arent backing up.

What can I do?

[Anon]

You could write a PHP script that could export the mySQL database to a plain text file, but then for your binary data, you can use the base64_encode() and base64_decode() functions to convert the binary data so it is safe to have in a plain text file 🙂

http://www.php.net/manual/en/function.base64-encode.php
http://www.php.net/manual/en/function.base64-decode.php

Just a though,
-Josh B