Cleaning Up Your WordPress Database

November 19, 2012

Problem: Difficulty importing or exporting large WordPress database files.
Over the years, one of my blogs has acquired upwards of 1,000 posts and 10,000 comments, and I’ve changed hosting companies 3 or 4 different times. Each time, I’ve experienced various degrees of hassle related to the exporting and importing of the large database files. The first time I changed hosting companies, I used the standard WordPress export functionality, resulting in an XML file upwards of 40MB. Trying to import this file via WordPress was a total nightmare, which I eventually solved by using this Python script to split the export file into about 40 smaller chunks, and uploading each one by one. Not fun!

Read More →






Western Edition Skateboards

December 6, 2010

“We have worked with many web designers before and Chris was the fastest and easiest to work with. He did a great job creating a clean, easy-to-maintain site in a timely fashion.”—Ian Johnson, Art Director

Read More →