Enabling advanced features in phpMyAdmin

A subscriber to lynda.com was watching my Up and Running with phpMyAdmin course, and was¬†puzzled by the absence of three fields in his version of phpMyAdmin when defining a table. The three fields are Mime types, Browser transformation, and Transformation options. In my opinion, they don’t serve a really useful purpose because I strongly believe that you shouldn’t store images or audio files in a database.

What puzzled me, though, was why the fields should be enabled in my version of phpMyAdmin, but not in his. It turns out that the fields are part of phpMyAdmin’s advanced features that depend on configuration storage being enabled. I’m using a recent installation of XAMPP on Windows, whereas the lynda.com subscriber was using MAMP on a Mac. XAMPP installs configuration storage automatically. MAMP doesn’t.

Although I’m not a fan of phpMyAdmin’s MIME and transformation options, configuration storage does enable some pretty useful features in phpMyAdmin, such as bookmarking SQL queries and storing table relations. So, I pulled out my Mac laptop, and decided to enable configuration storage, thinking I would be finished in 20 minutes or so. It turned out to be a lot more difficult than I anticipated.

Once I finally worked out what needed to be done, the procedure turned out to be fairly straightforward. One of the most important steps was closing down and relaunching phpMyAdmin after making all the changes. I’ve added a step-by-step guide to enabling advanced features in phpMyAdmin in the tutorials section of my site. I hope you find it useful.

This entry was posted in phpMyAdmin. Bookmark the permalink.

2 Responses to Enabling advanced features in phpMyAdmin

  1. Lewis Burdett says:

    Whenever I test a PHP script in my browser, I am constantly getting an unidentified index notice. This is getting very frustrating and I do not know what to do. Can somebody please help with this? I searched online and nothing has helped.

  2. David Powers says:

    Unidentified index means that your script is trying to use an array variable with a non-existent element. It often happens when you loop through the results of a database query, and try to display the value from a column that contains null as the value. Before trying to use or display the value, you should use isset() to check for its existence.