Are you attempting any sort of editing of the exported file? We routinely dump our production database, which includes several tables that hold TIF images, with no problems at all. In fact, we'll also transfer data between servers with a command like:
Mysqldump --add-drop-table <databasename> -uroot -ppassword | mysql --host=<otherIPaddress> -uroot -ppassword IN addition, we'll also dump to text files with no problem at all. This is a part of our daily backup and has worked for data restore/loading on several servers, both LINUX and Windows. The only time we've had problems is if I would try to edit the file, the editor would truncate the text lines containing the blob data which would then create corrupted images. -----Original Message----- From: Terry & Cheryl Haimann [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 11:11 AM To: mysql Subject: mysqldump ? I have a mysql 3.23 running under win98. I also have a database with a largeblob, which has a jpeg image in it. Now I am trying to upload this to a free server using the following command to export the table: bin/mysqldump -u user --password=mypass mydatabase mytable > dumpdir\mytable.sql The jpegs are becoming corrupted, I know it is happening in the mysqldump program. Because, I have a rh 8.0 box running mysql 3.23 and if I issue the following command: mysql -u user --password=mypass mydatabase < mytable.sql All of the data is ok except for the blobs which are corrupted. I also tryed exporting it as: bin/mysqldump -u user --password=mypass --quick mydatabase mytable > dumpdir\mytable.sql But the data was still corrupted. Any suggestions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
