MySQL blob - view table with phpMyAdmin php

[jedraw]

I am relatively new to PHP, MySQL and java. I have a java program that puts a filesystem gif into a MySQL table containing a blob field. A second java program reads the blob from MySQL table and creates a gif in a separate filesystem file.

I am using phpmyadmin and mysql and apache (downloaded from

http://www.firepages.com.au/)

to monitor the mySql tables.

I get error messages when looking at the table containing the blob.

For example:
Notice: Undefined variable: error_url in d:\phpdev\phpmyadmin\tbl_properties_operations.php on line 41
I also get
Can't open file: 'co_mda_tbl.MYD'. (errno: 145)

The real issue is that, although the java program works and when I run the second java program, I can view my logs and the resulting gifs. But, the phpadmin is not consistently showing me any record counts in the table. Another table, where I get gif names from, works as expected - counts, browse etc.

The table with the blob sometimes gives counts and allows browse on the non-blob fields, but most often shows no record count etc. (Makes it look like program has not completed or MySQL is waiting on something?)

When I do a CHECK on the blob table, I get various errors.
If I REPAIR the blob table I get record counts.

Is there an issue with MySQL Tables containing blobs and phpAdmin?

I am using W2K professional.
Here is blob table structure:

# phpMyAdmin MySQL-Dump
# version 2.3.2
#

http://www.phpmyadmin.net/

(download page)
#
# Host: localhost
# Generation Time: Nov 20, 2003 at 09:03 PM
# Server version: 4.00.00
# PHP Version: 4.2.3
# Database : `newCCCtest`
# --------------------------------------------------------

#
# Table structure for table `co_mda_tbl`
#

CREATE TABLE co_mda_tbl (
estblmt_no varchar(12) NOT NULL default '',
iso_lang_cd char(3) NOT NULL default '',
mda_fl_nm varchar(20) NOT NULL default '',
mda_cntnt_blob longblob,
PRIMARY KEY (estblmt_no,iso_lang_cd),
KEY mda_fl_nm (mda_fl_nm)
) TYPE=MyISAM COMMENT='simulates newCCC media table with graphics stored in database';



Any assistance would be appreciated.

j

 

[hvass]

Difficult to know - I no not tend to use Blob types maybe there are some issues or restrictions on use of Blobs
but
phpmyadmin just runs plain old SQL statements so probably nothing to do with phpmyadmin
Sounds like your tables are getting in a mess hence the check and repair and phpmyadmin's inability to report their size properly.