No Picture
MySQL

How to Move MySQL D/B Files (Windows)

Locate your MySQL installation files and central configuration file basedir=”C:/Program Files/MySQL/MySQL Server 5.1/” Your MySQL configuration is stored in “my.ini” file Locate your MySQL Database location: datadir=”C:/Documents and Settings/All Users/ Application Data/MySQL/MySQL Server 5.1/Data/” Stop MySQL service. Modify My.ini file to point to a new D/B location and Save. Move […]

No Picture
MySQL

Work with MySQL – Basic WordPress Queries

This article was born, as I was searching for ways to handle thousands of registered WordPress users, who never do anything, never return to the site, and never even change their default password.               Table of Topics -1030- List all registered users sorted by date -1060- Group registered users […]

IIS

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 […]

No Picture
MySQL

Can I Clean Old Versions of the Same Post?

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’, […]

No Picture
MySQL

MySQL on Windows – Questions Answered

  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 […]