WordPress

Use MySQL Command Line for Large WordPress DB Imports

You should always use the MySQL command line for large WordPress DB imports.

Why?

Not only is it much faster, but it’s more performant – regardless of the environment.

To get started, run the first statement below via the MySQL command line tool to disable auto-commit, unique and foreign key checks.

set autocommit=0; set unique_checks=0; set foreign_key_checks=0;

Select your DB and run your import.

use databasename; source /path/to/large-wordpress-dump.sql;

And then run this last line to enable them again.

set autocommit=0; set unique_checks=0; set foreign_key_checks=0;

I prefer to use a bash function tied to an alias for this command.

 
Tutorials

WP: 3.3 JS Menus and Widgets Fix

Update: This hotfix is no longer needed.

WordPress 3.3 has been released. But before you hit the “Update Now” button, let’s have a chat.

After upgrading, you may encounter issues using the new JavaScript features – such as menus, drag & drop widgets, andthe new media uploader.

Installing the HotFix plugin for WordPress saved our asses this week. However, be sure to edit the hotfix.php file to include the WordPress 3.3 update. We implemented this hotfix patch, and things seem to be functioning a lot better.

Fix your WordPress 3.3 Javascript Menus and Widgets Panel:

  1. Download WordPress HotFix Plugin, and then
  2. Replace the hotfix.php file with this hotfix patch.
 
WordPress

WordPress 2.5

After having upgraded a few clients to WordPress 2.5, I don’t want to upgrade my personal sites yet.

I’m not super excited about the UI like I was about the jump from WordPress 1.5 to WordPress 2.3. I love my admin dropdown menus too much. While there are definite improvements in other areas, the new dashboard UI isn’t as exciting as one would hope.

Maybe it just takes a little getting used to.