Last week I had a server crash — hardware problems — and have spent the past week recovering. I had several php apps running on the server along with a lot of static content–including a couple thousand videos. So I spent a day rebuilding the server on a new box and restoring the static content was a breeze–really drove home the point for me about the value of keeping things simple. 500+ videos were just uploaded into a directory and were not part of a php app–very simple to restore. However, the vast majority of my content was tied to a couple Moodle LMS installs, several WordPress installs including one WordPress Mu install, and five MedaiWiki installs.
“Error Establishing a Database Connection” — How to Fix This WordPress Error: Part 1 of 2
“Error Establishing a Database Connection” — How to Fix This WordPress Error: Part 2 of 2
How to Mass Delete Unapproved Comments from Your WordPress Database Using phpMyAdmin
IMPORTANT MESSAGE: If you use the Bigdump script I illustrate below, after you are done importing your database, be sure to delete the Bigdump directory. If you leave it in place, then anyone who stumbles across it could destroy your database. So, once you are done, remove it from your server and then if you need to use it again in the future, just upload it when you need it…removing it when you are done with it.
How to Import a Large WordPress Database — An Alternative to phpMyAdmin — Part 1 of 2