WordPress version: 3.3.2
Overview: Moving WordPress site to new server. Created brand new database, imported old SQL file into new database, FTP’d WP 3.3.2 files to server and crossed my fingers.
Problem: Home page showed up just fine, but posts and inside pages all went right to File Not Found 404 pages. Sad-face.
Solution: I went to Admin > Settings > Permalinks and simply clicked “Save Changes.” I didn’t change any of the setting, I simply clicked “Save Changes.” Voila, it all worked out!
Note: this is my personal experience with this particular situation, and I’d read about this technique over the years. Your mileage may vary.
Delete 18,000 WordPress Spam Comments At Once
Client with 4-year old WordPress site had accumulated 18,000+ non-approved spam comments. This tip from WPRecipes will delete all non-approved comments.
Original article on WPRecipes: Mark asked: How to batch deleting spam comments on a WordPress blog?