The Rebirth of Slicksta

Count Files in a Directory

find . -type f | wc -l

• 2
• Link

Converting Database Character Sets

If you’re like Slicksta then your WordPress installation might have generated tables with the latin_swedish_ci collation. This is the default setting for many web hosts that offer click-to-install MYSQL databases.

So what if you want to change your default collation to something like utf8_general_ci? Slicksta needed to do this because special characters were showing up all jacked up looking in posts.

The WordPress site offers this helpful tutorial. The instructions are pretty scary for a non-tech person however. As an alternative, here are the steps Slicksta took to successfully convert:

1. Back up your WP database. If you don’t know how to do this then you should not proceed any further.
2. Run the following in phpmyadmin or a similar tool
   

   alter table wp_posts change post_content post_content LONGBLOB; alter table wp_posts change post_content post_content LONGTEXT CHARACTER SET utf8;

• 5
• Link

Rank rows in MYSQL

SELECT t.id, t.value,
       @rownum := @rownum + 1 AS rank
  FROM TABLE t, (SELECT @rownum := 0) r

• Link