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!
