Warning: Illegal string offset 'lang' in /home/educhalk/public_html/blog/wp-content/plugins/keyword-statistics/keyword-statistics.php on line 353

Warning: Illegal string offset 'keywords' in /home/educhalk/public_html/blog/wp-content/plugins/keyword-statistics/keyword-statistics.php on line 354

Warning: Illegal string offset 'description' in /home/educhalk/public_html/blog/wp-content/plugins/keyword-statistics/keyword-statistics.php on line 356

Warning: Illegal string offset 'lang' in /home/educhalk/public_html/blog/wp-content/plugins/keyword-statistics/keyword-statistics.php on line 353

Warning: Illegal string offset 'keywords' in /home/educhalk/public_html/blog/wp-content/plugins/keyword-statistics/keyword-statistics.php on line 354

Warning: Illegal string offset 'description' in /home/educhalk/public_html/blog/wp-content/plugins/keyword-statistics/keyword-statistics.php on line 356

Warning: Illegal string offset 'lang' in /home/educhalk/public_html/blog/wp-content/plugins/keyword-statistics/keyword-statistics.php on line 353

Warning: Illegal string offset 'keywords' in /home/educhalk/public_html/blog/wp-content/plugins/keyword-statistics/keyword-statistics.php on line 354

Warning: Illegal string offset 'description' in /home/educhalk/public_html/blog/wp-content/plugins/keyword-statistics/keyword-statistics.php on line 356

Warning: Illegal string offset 'lang' in /home/educhalk/public_html/blog/wp-content/plugins/keyword-statistics/keyword-statistics.php on line 353

Warning: Illegal string offset 'keywords' in /home/educhalk/public_html/blog/wp-content/plugins/keyword-statistics/keyword-statistics.php on line 354

Warning: Illegal string offset 'description' in /home/educhalk/public_html/blog/wp-content/plugins/keyword-statistics/keyword-statistics.php on line 356

Archive

Archive for the ‘WP database’ Category

MySql Database Nightmare — Innodb vs MyISAM

October 11th, 2010 1 comment

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

March 7th, 2009 173 comments

“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 WordPress Comments

January 27th, 2009 31 comments

How to Mass Delete Unapproved Comments from Your WordPress Database Using phpMyAdmin

How to Import a Large WordPress Database — An Alternative to phpMyAdmin

January 26th, 2009 37 comments

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

WordPress Database Tip: How to Optimize and/or Repair Your Database

January 22nd, 2009 9 comments