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?
You have listed the dump and reload phases of this operation, but there is another phase implicit in what you're doing: the transfer of the file from one machine to another.
How are you transferring the file, and are you sure that process is not changing the file contents?
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
