Hello, I use BLOB fields to store pictures, it works nice, but problem arises when trying to backup/restore data, or else export BLOB fields to another database. I tried to use MysqlFront to export / import data, but it appears can't deal with BLOB, so it writes null character on TXT file for BLOB places.
I also tried to use PhpMyAdmin , it works fine to generate TXT file, writing lot of strange characters for BLOB, (I think) correctly slashed. Problem is I can't recover data generated by PhpMyAdmin. These data is read successfully by prompt line commands (mysql < backup.sql) or even by MysqlFront load & exec SQL files, but when comparing data, it appears character were lost into BLOB. I don't know if PhpMyAdmin correctly apply slash rules here. I wrote my own script to export BLOB fields, but couldn't address some few slash cases, then when returning to JPG pictures, some of them appears distorted. Problem became so hard I decided again to search for professional tools. Thanks in advanced Miguel - Brazil --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
