MySQL

How to Work with MySQL – Basic Tasks

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

No Picture
MySQL

MySQL Upgrade on Windows – Easy and Painlessly

How to update MySQL Server on Windows Machine   Preliminary notes: These steps work for MySQL Server that is running as a service on Windows machine. These steps were tested, when MySQL data directory is located on a different drive from MySQL  installation directory.   Determine your current MySQL version.  […]

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