Sometimes you’ll need to update post and page urls when going from a development environment to production, or more simply when going from one domain to the next. If you have many (10s to 100s), and you will have that if the WP snapshots have been run, then you’ll want to update them all easily. You can do this with MySQL:

UPDATE wp_posts SET guid = REPLACE(guid,’dev.site.com’,'www.site.com’);
UPDATE wp_posts SET post_content = REPLACE(post_content,’dev.site.com’,'www.site.com’);
UPDATE wp_options SET option_value = REPLACE(option_value,’dev.site.com’,'www.site.com’);

That’s it. You can update your WordPress post and page url values with just a little html.

• 0 Comments

I recently was on the search for a few examples of active MySQL configuration files (my.cnf). It’s always nice to see someone else’s production version of a configuration file and during this search I realized that not a lot of examples of MySQL config files were to be found on the internet.

The first place to start is MySQL’s examle config files. You can find this in mysql’s doc share, ie:

/usr/share/doc/mysql-server-5.*.*/

There are 5 example MySQL configuration files provided with most systems:

1. my-small.cnf
2. my-medium.cnf
3. my-large.cnf
4. my-huge.cnf
5. my-innodb-heavy-4G.cnf

You can take a look at the example MySQL config files above to get an idea of how these settings can be handled.

Here are a couple links to pages with MySQL config file examples:

• http://www.felipecruz.com/mysql-server-production-my-cnf-file.php
• http://forge.mysql.com/tools/tool.php?id=138
• http://www.astahost.com/info.php/Sample-Mycnf-Mysql-Configuration-File_t2727.html
• http://www.notesbit.com/index.php/web-mysql/mysql/mysql-tuning-optimizing-my-cnf-file/
• http://www.joehruska.com/?p=7

Here’s a link worth reading:

• http://www.brennan.id.au/17-MySQL_Server.html

That’s it for now. This is a resource page/blog post pointing to example MySQL configuration files.

• 0 Comments

This post is a running tab of what we at Kliky.Com consider essential WordPress Plugins. These WordPress Plugins are essential in that they should be included in every new WordPress installation we spin up. Below is our ever-updated list of plugins which should be included in every launch:

1. All in One SEO Pack
   This plugin enables certain modifications to your WordPress blog to achieve Search Engine Optimization. For example, you can customize your post title, post description and post tags for individual post. Furthermore, this plugin also has features such as auto generates Canonical URLS for your entire WordPress site and select index/noindex for various archives pages.
2. Google XML Sitemaps Generator
   This plugin will create a Google sitemaps compliant XML-Sitemap of your WordPress blog. A sitemap will help search engine spiders to crawl your content. The generated sitemap also supported by other search engine such as Yahoo, MSN and Ask.com.

That’s it. That is our list of essential WordPress plugins. These plugins should be a part of every new launch of a WordPress website.

• 0 Comments

The Six Revisions site always seems to come up with intelligent posts which inspire. If you haven’t already, you should follow their tweets. The just put up a post called, “Excellent Examples of Using Photos in Web Design” and I’d have to say it’s a great collection. I read a lot of these “lists” each day for inspiration and most of the time, it’s recycled garbage, but I’d have to say this post by Six Revisions showing the usage of photography as the basis of your Web site design is great.

Using photos as a design element and central piece in a web design is a great way to get a point across to the viewers or to just add more depth into the design. We are going to look at some examples of two popular ways of using photos in a web layout: using a large photo as your background and using a photo as the central focus in the header.

You can read their post here:

http://sixrevisions.com/design-showcase-inspiration/using-photos-web-design/

• 0 Comments

This article titled, “Joomla And WordPress: A Matter Of Mental Models” from Smashing Magazine contends that your choice of CMS depends on how you expect Web applications to allow for theming and core manipulation.

Open-source content management systems (CMS) are a large family of Web applications, but if we’re looking for stability, performance and average technical requirements, we’ll come up with a handful of options. In the past, choosing the “right” CMS was a matter of the project’s requirements, but now this is not completely valid because the paradigm of extensibility had driven the development of major CMS’ towards a model of core features that are extensible with plug-ins that fill virtually any requirement.

Picking the right CMS is then a matter of “mental models”: choosing the one that best fits our vision of how a Web application should work and what it should provide to users and administrators.

In this article, we’ll explore the main difference in the mental models: of WordPress and Joomla for theming and extending their core.

It’s an interesting read. I wish they would have thought about Drupal in this equation (which I’ve now come to prefer over Joomla) but the article and as usual with Smashing Magazine the comments are well worth taking a look at.

• 3 Comments

Here’s a good post up on Smashing outlining a few ways to extend WordPress’ custom fields to do much more that you’d initially think, “Extend WordPress with Custom Fields“.

WordPress’ popularity has grown exponentially as of late. This rise in popularity is due in part to WordPress’ custom fields. Custom fields allow you to add little bits of data to posts. They have changed the way people look at WordPress. A couple of years ago, WordPress was a blogging platform — a good one, but a blogging platform nonetheless. Now it’s widely considered to be an excellent simple content management system. How did it evolve so quickly? Custom fields, that’s how.

All in all a good read with links out to additional resources.

• 1 Comment

A very good overview of best practices for speeding up your web site from the Yahoo! Developer Network.

Very good resource:

• http://developer.yahoo.com/performance/rules.html

• 1 Comment

There’s an interesting company out there building upon its widget technology to allow publishers to create ad supported mobile versions of their Web sites.

From their own site:

ClickTurn enables people to create and sell high-impact ad units that marry brand content with content generated by both the publisher and their community.

We provide an end-to-end solution that empowers ad sales teams to delight customers, quickly deliver campaigns, and reinforce the value of the publisher’s inventory, audience, and content.

It’s worth taking a look at ClickTurn to read a bit more about what their doing here.

• 1 Comment