Install Parallels Tools in Ubuntu

Every time Parallels Tools needs to be updated for my Ubuntu virtual machines, I have to remember exactly how to do it, which usually involves a few clumsy Google searches.

So, for the sake of posterity, and to help anyone else in the same situation, here’s how I upgrade Parallels Tools on Ubuntu:

1. Open your Ubuntu virtual machine in Parallels.
2. In the Parallels menu, click on Virtual Machine/Reinstall Parallels Tools.  You should see a disc image (looks like a CD) appear on your Ubuntu desktop.
3. Open a Terminal and navigate to this (virtual) CD by typing: cd /media/Parallels\ Tools or cd /media/"Parallels Tools" and hit enter.
4. In your terminal window, type sudo sh install – Parallels will open the Parallels Tools Installer, which will guide you through the setup.
5. Click Next
6. Select Upgrade and click Next
7. Parallels will warn that you’re about to install and that it’s probably a good idea to save data and close open applications.  After you’ve done so, click Next.
8. Hold on while Parallels works its magic and, when it’s done, it’ll thoughtfully congratulate you and ask you to reboot.
9. Restart Ubuntu and you’re done!

I’ve already upgraded two sites using the automatic update from within the WordPress Dashboard and everything went off without a hitch.

There are a slew of new features and under-the-hood optimizations making WordPress even more pleasurable to develop with and use.

Check out the new WordPress 2.9!

MySQL Search & Replace

For database-driven sites created with content management systems like WordPress, Drupal, and Joomla, this means moving any custom themes and plugins, and it often entails exporting data from the development server’s database and copying it to the live web server.

With small databases, your content management system’s built-in import/export functions might work, or you can even search and replace an exported .sql file using a simple text editor or IDE.

Unfortunately, this doesn’t always work with larger databases, which can often be unruly and cause programs to hang, crash, spit, choke, and curse.

I searched around and found this PHP script by Mark Jackson which makes it much faster and easier to search and replace data across an entire MySQL database.

MySQL Search & Replace Project is Born

I created a quick little front end for Mark’s script using a little XHTML markup and CSS, tweaked a little PHP, and Mark and I decided to package up this tool and release it to the community under the GPL in hopes that it might help some other folks.

The MySQL Search & Replace project is hosted on LaunchPad, where you can report bugs, request features, checkout the latest version, read FAQs, contribute, and collaborate.

Using MySQL Search & Replace with WordPress

Before attempting to search and replace, please make sure to backup your database.

While this tool is easy to use, it’s also quite powerful and could easily cause harm to your database, if you’re not careful. Please make sure to read the included readme.txt file for more detailed instructions.

Since I develop WordPress sites on my local Ubuntu machines using a local LAMP install, the URLs of my work-in-progress sites usually look like:

http://localhost/projects/sewmyheadon

Of course, once I move the site to the web, it’ll probably have an address more like:

http://sewmyheadon.com

Since these URLs usually occur many times in a WordPress database, search and replace can be an invaluable tool in making sure they’re all corrected before moving the database.

Prepare a WordPress Database for a Move:

NOTE: Before running an actual replace, you can simply search to see how many times, and where, the string occurs in the database.

1. Backup, backup, backup.  Use phpMyAdmin or a WordPress plugin, but make sure you have a backup. You can’t say I didn’t tell you.
2. Download or checkout the latest version of MySQL Search & Replace
3. Unzip the files, if necessary, and place the mysql-replace folder on your server.
4. Double-check that you covered Step #1
5. Visit the URL for the MySQL Search & Replace Tool in your browser.  The URL might look something like: http://localhost/mysql-replace/
6. Fill in the necessary fields and click Start.

Get MySQL Search & Replace

• Download MySQL Search & Replace Tool
• MySQL Search & Replace Tool Project on LaunchPad.net

What Does “Bulletproof” Mean to me?

A bulletproof site is:

• Usable
• Accessible
• Secure

Most importantly, a bulletproof site provides both your users and you with a satisfying experience, regardless of browser type, network speed, physical abilities, or preferences.

I’m going to highlight some easy tools to help you:

1. Keep on top of backup and maintenance
2. Tighten up security
3. Speed up performance
4. Identify usability & accessibility issues
5. Increase usability by improving search

Backup & Maintenance

Here are some important things you need to know about backup and maintenance:

Backup regularly: I know it should go without saying, but I’ll say it again anyway: Backup regularly!

They say “it’s only important to backup the stuff you want to keep,” which for me includes custom themes and plugins and, most of all, databases.

Know your host’s backup policies and tools: Your web host should provide you with handy-dandy backup tools; spend some time familiarizing yourself with them.

Find a plugin that makes backup and maintenance easier: There are a bunch of great backup plugins. One of my favorites is WP DB Manager by Lester Chan.

WP-DBmanager Backup

WP DB Manager lets you configure automatic backup and maintenance on your WordPress database and will even email you regular backups. I highly recommend having regular backups of your database emailed to you–better safe than really, really sorry!

Beef Up Security

Another thing that should go without saying–but merits oodles of repeating anyway–is KEEP WORDPRESS AND YOUR PLUGINS UPDATED! Yes, it’s so important it even needs to be written entirely in caps.

Paying attention to security has saved my bacon enough times to supply a year’s worth of deliciously high-cholesterol breakfasts!

Tips for beefy security:

• Use the secret key in your wp­config.php
• Read the heck out of the invaluable “Hardening WordPress”
• Use SSL for Admin Pages or the helpful Admin SSL plugin by Ben Green
• Audit your WordPress setup with WP Security Scan by Michael Torbert

WP Security Scan

WP Security Scan - Audit Security on Your Site

WP Security Scan looks at your WordPress setup and file system configuration for potential security vulnerabilities and provides tools and advice on how to patch them.

Speed it Up!

A bulletproof site is a speedy site!

Google claims that a 500 millisecond increase in loading time reduces their traffic and advertising revenues by 20%! Amazon has reported that each 100 millisecond increase in load times reduces their conversion rates by 1%.

These are pretty darn convincing argument for the importance of speed.

Here’s what you can do to ensure your site has all the zip it needs:

Be prepared for traffic:

Yahoo's YSlow Plugin Finds Performance Bottlenecks

• Have good hosting infrastructure & make sure your host can quickly and easily support your site’s growth
• Tailor images & code for use on the web
• Reduce the number of requests to the server
• Offload media to other domains
• Use plugins judiciously
• Enable a caching plugin like WP Super Cache by Donncha O Caoimh

Test your site’s speed with these Firefox plugins:

• Yahoo’s YSlow
• Google Page Speed

Both YSlow and Page Speed are Firefox plugins that help identify and fix performance bottlenecks. You definitely want to avoid having a rotten rating like this!

Use the Firefox Web Developer Toolbar

Why? Because it’s amazing!

The Firefox Web Developer Toolbar by Chris Pederick is easily my favorite tool for:

• Development: Write CSS & HTML and see the effects in real time
• Troubleshooting: Troubleshoot HTML markup & CSS
• Testing: Test sites for common usability & accessibility issues

Firefox Web Developer Toolbar

Development:

Test changes on the fly with the Web Developer Toolbar

With the Web Dev toolbar, you can view and change CSS and HTML and see the effects instantly. It’s a great way to locate troublesome layout issues.

You can even use it to save changes locally; in fact, this is how I code 95% of my CSS.

Troubleshooting:

If you visit the WordPress forums, you may notice that people have tons of layout and theme issues caused by simple HTML or CSS mistakes.

The Toolbar helps you find and fix errors by making it easy to validate online, or local, HTML and CSS.

Testing

Testing your site is very important and often overlooked. The Web Dev Toolbar is an invaluable testing tool. Here are some ways I use it:

Disable CSS

Disable CSS:

Stripping your site bare by disabling CSS gives you a good idea what search engines and screen readers encounter when they visit your site.

A bulletproof site makes sense and is easy to navigate even when it’s not dolled up with fancy CSS makeup. Good, semantic markup helps both users and search engines.

Disable images:

What happens when you turn off images? There are still people on dial-up, and eliminating images can really speed up load times.

Disable Images

The New York Times website is a great example of the way a bulletproof site functions without images. For your site to be bulletproof, you should be able to answer “yes” to the following questions:

• Can you still navigate and make sense of the site?
• Is there alt text for the images?
• Is the site branding still visible?

Disable JavaScript:

It’s not uncommon for users or security software to disable or filter JavaScript, and the Web Dev Toolbar makes it easy to see how your site functions without JavaScript.

Disable JavaScript

Here’s a great example from Fickr, whose site makes wonderful use of JavaScript. Notice that even with JavaScript disabled, Flickr still works. They even present us with a handy message letting us know that our experience would be better if we had JavaScript. That’s graceful degradation!

Disable JavaScript with the Web Dev Toolbar and ask yourself:

• Does the site degrade gracefully?
• Is there an alternate version or message for users without JavaScript?
• Can you still navigate the site?
• Do forms and behaviors still work?

Validate WAI/508 Accessibility:

Test Accessibility

Just as you can validate HTML and CSS with the Web Developer Toolbar, you can also use it to send your pages through Section 508 and WAI Accessibility validators.

The Toolbar will:

• Show you major accessibility issues
• Link to usability checkpoint definitions

While automated online tests aren’t the best way to test accessibility, they’re a great start, so take advantage of this handy feature.

Improve Search for Better Usability

I can’t emphasize enough how important search is for a website’s usability and accessibility. There’s a reason Google is a household name — they’ve proven that better search equals better usability… which equals more traffic!

As sites grow, search only becomes more critical. WordPress has a search feature that was created for blogs. Unfortunately, it just ain’t good enough for a bulletproof site. (Please don’t tell WordPress search I said that, though; there’s no need to go hurting its feelings.)

Here’s How WordPress search is flawed:

A WordPress search for “hosting” on our WordPress-powered business site produces this:

WordPress Search Results

• The results are listed in reverse chronological order, which is okay for blogs, but isn’t necessarily good for businesses
• The results aren’t the most relevant
• The search terms aren’t highlighted
• When content grows, search gets worse

Meet Relevanssi, the bulletproof WordPress search solution:

Fortunately, I found a solution with Relevanssi, a fantastic search plugin by Mikko Saari. Yay!

Here’s what happens when I search for “hosting” using Relevanssi:

WordPress Search with Relevanssi

The results are ordered by relevance and the search terms are highlighted. But that’s not the only reason that Relevanssi instantly became one of my favorite plugins!

Relevanssi lets you:

• Include only posts, only pages, or both
• Index comments, tags and custom fields
• Expand shortcodes before indexing
• Limit results to certain categories or tags
• Log searches
• And much more!

Best of all, the more content you have, the better your search becomes! Now is that spiffy or what?

The Wrap

I know this is a lot of info, and it just scratches the surface of each topic, but hopefully you’ve found something helpful. Feel free to contact me if you have any questions.

I appreciate all those who attended, organized and sponsored WordCamp Seattle and I look forward to seeing you at an upcoming WordCamp!

Again, if you’d like to see me speed-talk my way through this presentation, head on over to WordPress.tv to view video of this presentation

They’ll be filling an hour with some focused, five-minute presentations that zero in on a WordPress-specific topic.

More info at:
http://www.wordcampseattle.com/2009/09/ignite-wordcamp-seattle-speakers-needed/

From now through September 14, 2009 you can get a free copy of “The Principles of Successful Freelancing” by Miles Burke by visiting:
http://twitaway.sitepoint.com/

WordCamp Seattle is September 26th, 2009 and there’s already an impressive line-up of speakers.

WordCamps are informal conferences where you can learn about the world’s most popular blogging platform, WordPress.- WordCamp Seattle

I’ve registered – if you’ll be there and want to connect, contact me.

More details at www.wordcampseattle.com

Edit: I’ll be giving a 5 minute Ignite presentation at WordCamp Seattle entitled “5 Free Ways to Bulletproof Your WordPress Site” – hope to see you there.

Relevanssi - WordPress Search Reborn

I’ve never been crazy about WordPress search, often preferring to use Google to search a site, rather than use WordPress built-in search. This goes for WordPress.org too – it’s always much easier for me to find answers in the WordPress Codex using Google searches.

WordPress search is intended for the average blog and it works alright, but when constructing a more fully-featured site, or using WordPress as a CMS, the simple, unweighted, reverse-chronological results that WordPress search provides just don’t cut the mustard.

I tried several different plugins and hacks before finding Relevanssi, a plugin by Mikko Saari, which singlehandedly fixes WordPress search, providing more relevant search results and several options to tailor result presentation.

Since I began using Relevanssi last month, Mikko has been actively developing and improving the plugin with some help from the community, and it’s quickly become one of my top five WordPress plugins. Heck, I’m even using Relevanssi on sewmyheadon.com, if you’d like to give it a try.

Relevanssi is an indispensable WordPress plugin and I encourage anyone using WordPress to try it and support its development. Trust me, you’ll never go back.

WPTouch Plugin

Being an iPhone user, I’m always happy to find sites that have mobile-friendly versions.

Despite the Safari browser that comes with the iPhone and iPod Touch,  I find many websites difficult to navigate using such a small screen.

Looking into some WordPress iPhone plugins, I installed and configured WPtouch, which automatically displays a mobile-compatible version of a WordPress site for users browsing with iPhone, iPod Touch, or Android Touch devices.

Looks alright on my iPhone.   Let me know what you think.

I’ve been using the betas for a while and have grown to love it, especially:

• the design and increased usability of the admin interface (backend)
• upgrading WordPress from within WordPress
• adding new plugins from within WordPress

Download WordPress 2.7