If you are a Linux geek like me you probably have a text file in your home directory with all your favorite command line ‘fu tricks. I thought I would share some of the ones I have collected over the years which can come in useful for remote servers where the only access you have is via ssh.
I imported an old Blogger account into a WordPress blog recently and my titles did not import correctly. So there I was stuck with 500 posts with no titles. I decided the easiest way to fix that would be to copy the post dates from the Blogger account to the titles in WordPress. So here is a fairly quick and dirty way to import qd_db_posts.post_date to qd_db_posts.post_title.
This will all be completed from your OS shell which in this case was CentOS 5.2.
The best way I have found to emulate Linux commands for Windows is by installing CYGWIN. This is an application that will run on pretty much all Windows machines and provides a ton of Linux type commands. After installing CYGWIN you will need to set your path as noted below.