I have an application, DipperBase, that keeps astronomical images in a
mysql database. The actual images are stored in a blob field. To get
some test data, I downloaded some SEDS images of Messier objects, freely
available on the intenet. I have been havinng dificulty uploading the
SEDS images using mysqldump method.
My ap has two ways to upload my database to
server on the internet (for inclusion in a web page.)
1. My program can connect directly to the server's mysql database and do a
record by record copy.
2. My program can start a mysqldump command to dump the database.
The first method works fine, but with a dial up connection it is rather
slow.
The second method works fine with my personal images (and a NASA image,)
but the SEDS images never display after the upload. I have tried two
seperate methods of using mysqdump to get the data backed up.
The first method issued the following:
c:\mysql\bin\mysqldump -r \mysql\dumpdir\backup.dmp --user=myuser
--password=mypassword mydatabase
per a sugestion from bobb, I also tryed using the "--opt" switch.
The second method involved doing the following steps.
a. Backing up just my lookup tables with the following command:
c:\mysql\bin\mysqldump -r \mysql\dumpdir\backup.dmp --user=myuser
--password=mypassword mydatabase table1 table2 table3 tableN
b. Updating the object table with an integer value of the record number.
And then issuing first a
c:\mysql\bin\mysqldump "-w RecNbr>=1 and RecNbr <=5" -r \mysql\dumpdir\Obj0.dmp --user=myuser
--password=mypassword mydatabase object
1 and 5 is based upon a block size that the user enters.
and then I would follow up with
c:\mysql\bin\mysqldump -t "-w RecNbr>=6 and RecNbr <=10" -r
\mysql\dumpdir\Obj1.dmp --user=myuser
--password=mypassword mydatabase object
and this loop would repeat until the table is completely backed up.
Everything resulted in my SEDS images not being viewable on the web
page when using mysqldump as the coping method. I don't think it is a
size issue, since my images and the NASA image are of equal size as the
SEDS images. I also don't beleive it is a timeout issue.
Could there be something in the SEDS images that is messing me up and is
there a work around. It should be noted that the web page attributes the
SEDS images to SEDS.
The local machine is running Win98 and my program is written in Delphi 4.
The test server machine is running RedHat 8 and both are running MySQL 3.23
--
Author of Dipperbase (www.HaimannOnline.com/DipperBase)
A Astronomy Image database, which allows upload to the web.
Currently in alpha-testing.