MySQL

MySQL: install, manage, backup, update, customize

Movng WordPress Site to a W2K8 Server and IIS7

2010/07/19
By
Modified: 2011/03/15
Movng WordPress Site to a W2K8 Server and IIS7

If you like to be in control of all your servers, you would love the gentle nature of WordPress installation.  Installation includes PHP,  MySQL  and  WordPress components.  All steps can be done manually.  Instead of running install, you can just copy files and directories, and make manual configurations adjustments.  It is like labyrinth of  DLL(s) meets the non-DLL world for the first time.   Check IIS7 Installed Components Windows Server 2008 comes with IIS 7.  Windows 7  and Server 2008 R2 come with IIS 7.5. Check that CGI is installed under IIS Roles (Windows Features).   Installing PHP Download and install latest PHP. Warning 1: Pick “nts” (non-thread-safe) package, if you are…

Read more »


How to install WordPress 3.0 on XP and IIS 5.1 Manually

2010/07/09
By
Modified: 2010/08/09
How to install WordPress 3.0 on XP and IIS 5.1 Manually

If you ever need to transfer your own installation of WordPress from machine to machine, you might need these notes. How to configure a new WordPress install on a new PC and copy My-SQL D/B file.

Read more »

Can I Clean Old Versions of the Same Post?

2010/06/30
By
Modified: 2010/08/09

Question: Each time I modify a POST, a copy of old POST is created and saved. Can I control, how many old posts to retain? Can I clean all old posts? Answer: Yes! You can stop collecting old versions of the posts by adding this line to your wp-config.php file: define('WP_POST_REVISIONS', false); And Yes! You can delete all “revisions” by running this SQL statement against you database: DELETE wp_posts.post_type FROM wp_posts WHERE wp_posts.post_type = "revision"

Read more »

MySQL on Windows – Questions Answered

2010/06/28
By
Modified: 2010/09/23

  I just installed WordPress with MySQL.  I am familiar with all the intricacies of SQL Query.  I am asking from MS SQL Admin point of view.  These questions from a person who never saw MySQL before:   – Where DB files are located?    – See other post – Is DB backup available and free? – How to add new tables and fields? – How to move database from one PC to another?    – See bellow and other post – Is ODBS driver is available – Yes! – Is GUI software is available – Yes!  I am sure I will find answers pretty easy, but if you have any tips and tricks, please reply. Within days of…

Read more »