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.