Yes, that seems to be part of the problem. I still seem to be loosing some images though. And how can I upload to PHPMyAdmin without altering the comments that mysqldump creates.
Terry On Wed, 15 Oct 2003 12:05:19 -0500, Christensen, Dave wrote: >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]
