MySQL

MySQL: install, manage, backup, update, customize

No Picture
MySQL

How to Move MySQL D/B Files (Windows)

2025-11-27 Udar Gromov 1
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

2025-11-25 Udar Gromov 1
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 […]
MySQL

Uninstall just one instance of SQL server

2025-07-18 Udar Gromov 0
You have several instances of SQL Server (Express) installed and you need to remove/uninstall just one of the instances. Here are the steps tested in Windows 10 with SQL Server  2019 Express —01—  Open App & Features —02— Find MS SQL Server 2019 (64-bit) and click Uninstall:   —03— Confirm […]
MySQL

How to Work with MySQL – Basic Tasks

2025-07-15 Udar Gromov 0
This material is tested with MySQL 5.1 and 5.5 on various Windows versions. This article covers these topics: -010- MySQL Data Location -020- Shortcut to MySQL Command Shell -030- Create a New Database -035- Delete an Existing Database -040- Display a List of All DB Users -050- Display a List […]
IIS

Movng WordPress Site to a W2K8 Server and IIS7

2010-07-19 Udar Gromov 0
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?

2010-06-30 Udar Gromov 0
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

2010-06-27 Udar Gromov 0
  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 […]