Web-based MySQL Administration

Sep 10, 09:38 PM

I have been using one flavor or another of PHPMyAdmin for almost the duration of the project. The app has become ubiquitous; every web host that I have used in the past seven years has had it as part of their control panel. I have installed it myself maybe a dozen times.

Late last year I moved everything from LunarPages to FatCow; I did not feel like paying for two years of hosting and FatCow was a little cheaper. For whatever reason, FatCow’s PHPMyAdmin would not import a 500kb SQL file. I hated the idea of installing my own version of PHPMyAdmin because

  1. you either need to keep up with security updates or remove the installation and
  2. it was already installed by my host!

So I looked at two alternatives. The first was SQL Buddy and I ran into similar issues uploading the file. I was starting to wonder if there was something wrong with the FatCow MySQL server, or maybe Comcast.

I finally settled on Adminer. Worked fine.

---