Over time, your WordPress database accumulates clutter. A bloated database can cause performance problems, and it may also make backing up and restoring more difficult. Continue Reading Is Your WordPress Database a Disaster? Get a grip on your tables and options to improve performance
WordPress Database
Checking and Repairing Your WordPress Database
A week or so ago now (time gets away from me in the most appalling fashion) I was about to post something on my personal blog when I encountered an unexpected problem. I got an “Error establishing database connection” message. Say what? This frequently means there’s something wrong in your wp-config.php file, or maybe your… Continue Reading Checking and Repairing Your WordPress Database
Find and Replace
I don’t know why this feature isn’t built into WordPress. It’s one we’ve desperately needed since the beginning, so when I first discovered the Find and Replace plugin, I just about threw a party. (And when I installed it I noticed that one of the developers is someone I know from the WordPress LinkedIn group.)… Continue Reading Find and Replace
How to Repair and Optimize Your Database in WordPress 2.9
This feature seemed especially likely to be useful to me for my older blogs, the ones that had gone through imports and exports and lots of different plugins. At first I wasn’t sure what you were supposed to do besides pasting the code define(‘WP_ALLOW_REPAIR’, true); into your config.php file. (And when I pasted it the… Continue Reading How to Repair and Optimize Your Database in WordPress 2.9
WordPress Database Backup
If you lose your WordPress database, you’re screwed. And you may hope that your hosting company is backing it up, but are you sure? Besides, with all those hackers out there eagerly seeking out vulnerabilities in WordPress, it’s a good thing to have a copy or two or three of your database around. Continue Reading WordPress Database Backup