Images not showing after import of data with MYSQL

rbross

Hello,
We have an EC2 instance on AWS. We exported the MYSQL data from BASDBTEST.
We imported the BSV then import the MYSQL data using MYSQL. All data shows fine but there are no images.
We have a picture of each contact on the edit form and they are not displaying.
We checked to see if the images were included in the export of data from MYSQL and they were.
Checked DB to see if images were being stored in DB and not pointing to them in the local machine and they are.

Any idea's as to what could be the issue?

Regards,
Roger Ross

kklosson

Did you compare and validate the data types between the old and new instances?

rbross

No, we did not compare or validate anything. There was no data in BASDBTEST in the EC2 instance. This was loading the data and the BSV for the first time.

Roger

kklosson

In my basdbtest, an image attribute has a photo_DOCTYPE and a photo_DOCDATA database field, where "photo" is the attribute name. They are varchar and longblob respectively. Any help?

rbross

My Photo attribute in BASDBTEST is the same as yours.
ContactPhoto_DOCTYPE and a ContactPhoto_DOCDATA database field They are varchar and longblob as well.

When I did the Data export from MYSQL I chose the Self Contained File Option. Then we just Imported the file with MYSQL on the EC2 instance.

Do my images need to be on the EC2 instance in a folder someplace?

Roger

kklosson

No, they should be stored as blob data. Is there an data in the blob attribute?

rbross

Yes, When I do a query in MYSQL ContactPhoto_DOCTYPE has the filename for the picture ie, MyPicture.jpg
The ContactPhoto_DOCDATA Shows Blob, if I right click on a record for the Blob and show values in Editor and click on each tab, Binary Data, Text Data and Image, I see something on each one. However this is on my local machine. I can check the EC2 instance for MYSQL, but the person set this up for me said he can see data in MYSQL.

Not sure what else to check?

Roger

rbross

Data Type for ContactPhoto_DOCDATA is a LONGBLOB are you saying it should just be a BLOB?
LONGBLOB is how AwareIM created it. Do I need to p[physically change it in the DB to BLOB?

kklosson

Nope, it's good. just checking.

rbross

Could it be a memory issue? the EC2 instance I Setup does not have a lot of memory on it and the images I am using have not been optimized at all, they are about 52k each. That doesn't sound that big?

rbross

Issue resolved, not sure how though!
I exported just the Contact table using HediSQL and imported it again on the remote machine.
Now I can see the image preview when in HEIDISQL. Whet into AwareIM and can see images as well for all contacts.
Maybe it was the different between MYSQL Workbench and HEIDISQL? The first export was done using MYSQL WorkBench and imported using HEIDISQL.