Apache Friends Support Forum

I hope someone can help me I have added a BLOB field in phpmyadmin but don't seem to have the MIME columns that allow MIME Type and Browser Transformation option. I have searched the online documentation and all the settings in the config file seem to be set to allow this.

You don't have this filed while _creating_ the table? What Version of phpMyAdmin are you using?

glitzi

Thanks for your reply, I am using phpMyAdmin - 2.11.9.2

OK, i have here 2.11.4, there it is still included. On my 3.0.0 installation it is also missing. Maybe they removed it. Don't know why...

glitzi

This gets stranger I have the exact same version on another PC and the options are available???????
It surely must be a setting somewhere

OK, what type of Storage Engine are you using? On my new Installation i am running InnoDB, on XAMPP it is MyISAM. Maybe it is related to this?

glitzi

On my new Installation i am running InnoDB, on XAMPP it is MyISAM. Maybe it is related to this?

I don't think so, because these columns are phpMyAdmin specific and doesn't exists in MySQL.

but don't seem to have the MIME columns that allow MIME Type

You must setup the phpmyadmin database, including the column comments table, and you must enable these columns in "config.inc.php":
http://wiki.cihar.com/pma/Config#column_info
http://wiki.cihar.com/pma/Config#BrowseMIME

Thanks for you reply but which config file? do you mean the one in libraries as the standard config.inc doesn't have these listed?

but which config file?

That one from phpMyAdmin. It's name is "condfig.inc.php".
http://wiki.cihar.com/pma/Quick_Install#Manually

witham wrote:Thanks for you reply but which config file? do you mean the one in libraries as the standard config.inc doesn't have these listed?

In the folder .\xampp\phpMyAdmin there should be a file called config_inc.php

If this file is missing or is a shortened version (compare the file size of the file config_default.php to be copied over below) then you can try the following as this approach is both simple and effective, as I mention below.
It also assures continuity as the default file has been used, in your case exclusively perhaps, up to this point.

Go to .\xampp\phpMyAdmin\libraries and find the file config_default.php

Now copy this file to the phpMyAdmin root folder .\xampp\phpMyAdmin and then rename it to config_inc.php

Now do your phpMyAdmin configuration edits in the newly copied and renamed file - save the file and restart Apache after editing.

phpMyAdmin looks for config_default.php in the phpMyAdmin/libraries folder first then overrides this file with any differences it finds in the config_inc.php file in the phpMyAdmin root folder - if no config-inc.php file is found then phpMyAdmin simply uses the config_default.php file only.

It is advised not to make any edits in the config_default.php file hence the reason to copy over and rename it as I set out above which also simplifies the configuration process by not having to keep checking 2 different configuration files when editing.

I hope this helps to clear up the configuration file issue for you - you should now be able to find the column details for your original request.

no need to copy the whole config.default.php file,
see http://wiki.cihar.com/pma/config.inc.php

thanks sharley that sorted it out many thanks