Pada Sat, 6 Jul 2002 12:22:44 +0400
Papa Carlo <[EMAIL PROTECTED]> menulis :
>
> mysqldump incorrectly export char/varchar binary and *BLOB fields.
> it export binary fields like text strings
>
> INSERT INTO users VALUES (7,'zk',1,'¦î¯¯Çbv','ó +:ºÐ','Ó]¦Ç\ZW¦{','T~âxÎË-','T
>üc¦SüG\"R-¦Íê');
>
> this is obviously incorrect and may contain non-asci characters.
> I experienced corrupt records in practice.
> You should use hex representation, for example :
> INSERT INTO users VALUES (7,'zk'',1,binary 0x112233,binary
>0x44556677,.................);
> or at least escape sequences in text strings
have you tried to put this dump file back into live DB ?
you should check the BLOB value is correct or wrong ...
i never had bad experiences in dumping blob data .... :D
--
printk("??? No FDIV bug? Lucky you...\n");
2.2.16 /usr/src/linux/include/asm-i386/bugs.h
MySQL 3.23.51 : up 16 days, Queries : 368.294 per second (avg).
---------------------------------------------------------------------
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
