MySQL Database

Clean-up Unnecessary Plugin RSS Feed in WordPress Database

Previously we look at on how to Clean up Comment Meta in WordPress Database. If you would like to optimize your database further you may want to Cleanup Unnecessary Plugin RSS Feed as well.

Remember to backup your database prior to removing these entries.

Once done with the database backup log in to phpMyAdmin, select the right database & click on “SQL” menu on the top.

DELETE FROM wp_options WHERE option_name
LIKE '_transient_timeout_rss%';

 

DELETE FROM wp_options WHERE option_name
LIKE '_transient_rss_%';

 

DELETE FROM wp_options WHERE option_name
LIKE '_transient_timeout_feed_%';

 

DELETE FROM wp_options WHERE option_name
LIKE '_transient_feed_%';

How to Host Static & Dynamic Page (PHP) in Windows Server 2008 R2

This is just a summary on how to host static & dynamic page in Windows Server 2008 R2. For detail’s guide click on the link in the step by step guides below. Credit to TrainSignal for the detail’s guides.

  1. Install Internet Information Services (IIS)
  2. Install PHP
  3. Install MySQL Database

After completion, you should be able to host static & dynamic page. Dynamic website such as WordPress should work well.