Command Line

Git List of Remote Tags

Need to know what has been tagged in a remote repo?

This will give you a list of tags from the remote you specified.

Alias the Git List Remote Tags Command

You can create an alias for the command by running the following via command line. This will allow you to run git remotetags at the command prompt. Feel free to change origin to your preferred remote.



Use MySQL Command Line for Large WordPress DB Imports

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


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.


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.
Apps and Software

How-To: Windows 7 Shortcuts

I don’t hate Windows 7 as much as I hated MoJo-JoJo (read: Windows Vista).

So I had to learn the shortcuts. They just make life easier.

CTRL + SHIFT + N is my favorite. It creates new folders. lol.

Window Management Shortcuts

The full list of keyboard shortcuts includes:

  • Win+Home: Clear all but the active window.
  • Win+Space: All windows become transparent so you can see through to the desktop.
  • Win+Up arrow: Maximize the active window.
  • Shift+Win+Up arrow: Maximize the active window vertically.
  • Win+Down arrow: Minimize the window/Restore the window if it’s maximized.
  • Win+Left/Right arrows: Dock the window to each side of the monitor.
  • Shift+Win+Left/Right arrows: Move the window to the monitor on the left or right.

You can also interact with windows by dragging them with the mouse:

  • Drag window to the top: Maximize
  • Drag window left/right: Dock the window to fill half of the screen.
  • Shake window back/forth: Minimize everything but the current window.
  • Double-Click Top Window Border (edge): Maximize window vertically.

Taskbar Shortcuts

You can use any of these shortcut combinations to launch the applications in their respective position on the taskbar, or more:

  • Win+number (1-9): Starts the application pinned to the taskbar in that position, or switches to that program.
  • Shift+Win+number (1-9): Starts a new instance of the application pinned to the taskbar in that position.
  • Ctrl+Win+number (1-9): Cycles through open windows for the application pinned to the taskbar in that position.
  • Alt+Win+number (1-9): Opens the Jump List for the application pinned to the taskbar.
  • Win+T: Focus and scroll through items on the taskbar.
  • Win+B: Focuses the System Tray icons

In addition, you can interact with the taskbar using your mouse and a modifier key:

  • Shift+Click on a taskbar button: Open a program or quickly open another instance of a program.
  • Ctrl+Shift+Click on a taskbar button: Open a program as an administrator.
  • Shift+Right-click on a taskbar button: Show the window menu for the program (like XP does).
  • Shift+Right-click on a grouped taskbar button: Show the window menu for the group.
  • Ctrl+Click on a grouped taskbar button: Cycle through the windows of the group

Extra Shortcuts

Here’s a few more interesting hotkeys for you:

  • Ctrl+Shift+N: Creates a new folder in Windows Explorer.
  • Alt+Up: Goes up a folder level in Windows Explorer.
  • Alt+P: Toggles the preview pane in Windows Explorer.
  • Shift+Right-Click on a file: Adds Copy as Path, which copies the path of a file to the clipboard.
  • Shift+Right-Click on a file: Adds extra hidden items to the Send To menu.
  • Shift+Right-Click on a folder: Adds Command Prompt Here, which lets you easily open a command prompt in that folder.
  • Win+P: Adjust presentation settings for your display.
  • Win+(+/-): Zoom in/out.

How-To: Gateway Recovery – ALT + F10

If you’ve got a Gateway, and malware due to your… ahem… surfing has gotten you to the point where you don’t care whether you can save anything, and you’d rather just restore it to factory settings, go ahead and run Gateway eRecovery.

If you do not have Gateway eRecovery installed, hit and hold F8 to get to Advanced Boot Tools to Boot your PC in Safe Mode WITHOUT Networking. Save your important files, and then reboot again. This time use ALT + F10 to get your recovery options.

If you’ve got a bootleg version of Windows Vista (God Forbid) or Windows 7, go ahead and pop that bootleg disk in and click “Install Now” to install a clean version of Windows. It’ll save your old files in a windows.old directory for you to access and/or delete later.



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.