This is a fairly common situation. The short answer is that you usually don’t need to fix anything. This is a non-issue. As long as your MySQL and MySQL Client have the same major version, you can and probably should just...
Sometimes you just have to start over. I had a database that had a bunch of tables in it, almost 9000. The problem was that I didn’t know if they were the right tables. I had a mysqldump files that did...
This seems like it should be a really complicated tasks, but once you have done a few it sinks in that this is really simple… Just run each of the following 5 steps as root. Answer any questions with the...
I needed to transfer about 40 databases from a new clients server over to my hosting platform. When doing a couple database exports, I might use PHPMyAdmin to do the export. Heck, it’s convenient because I usually want to look around...
When manipulating WordPress databases for exports and merges, sometimes it is helpful to get a list of all of the parents for the categories your posts are in. For the import I am working on right now. The category list is...
I first laid eyes on Michael Widenius, the original and principle author of the MySQL database software at the 2008 MySQL Conference in San Jose. Michael, who is more commonly known simply as “Monty”, had recently had his pride and joy,...
For various reasons, sometimes the number of comments shown under the title of the post may not match the number of actual comments displayed under the post. Here is a simple SQL statement that will resolve the issue: update `wp_posts` set...
I was just over at the PHPMyAdmin site and saw this quote: Welcome to phpMyAdmin 2.11, which will probably be the last series supporting PHP 4. Notice the “probably” stuck in there. They are testing the waters. If phpMyAdmin is dropping the whole PHP 4 line, it just might push the...
I wanted to get a list of the tables in my MySQL database a couple weeks ago. I bookmarked on place that had a list of commands. I’m including that info here for furture reference. I’ve found dozens of copies of...