The day I long feared finally arrived.
My website had outgrown my server space
I took a radical step, one that I wouldn’t have done without a back-up.
I nuked every post older than 2,000 days ago. In other words, the years 2001 to 2007 are now gone.
They will return to the new site in the spring. In the short term, though, I needed the space on the server — and those old posts were taking up space.
The coding on the new site is done, save for the mobile theme. Once I get moved and settled I’ll tackle that.
I used to think WordPress’ code was bloated, but its databases are, too.
Good times.
Published by Allyn
A writer, editor, journalist, sometimes coder, occasional historian, and all-around scholar, Allyn Gibson is the writer for Diamond Comic Distributors' monthly PREVIEWS catalog, used by comic book shops and throughout the comics industry, and the editor for its monthly order forms. In his over ten years in the industry, Allyn has interviewed comics creators and pop culture celebrities, covered conventions, analyzed industry revenue trends, and written copy for comics, toys, and other pop culture merchandise. Allyn is also known for his short fiction (including the Star Trek story "Make-Believe,"the Doctor Who short story "The Spindle of Necessity," and the ReDeus story "The Ginger Kid"). Allyn has been blogging regularly with WordPress since 2004.
View more posts
Out of curiosity: how much database space did that save you?
40 megabytes. The wp_posts database went from 71 to 31 after the delete and the optimize. I hoped the optimize would be enough on its own, but that only saved me 4 (whick put me righr under my server space limit), so I went for the delete.
I thought I felt a great disturbance in the Force, as if millions of posts suddenly cried out in terror and were suddenly silenced.
They’re not gone. They’re merely hibernating.