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

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

Web Development

Node.js -understanding callback when you have to wait

This post demonstrates: – how to write a callback function so that results from your database are returned by the time you are ready to render; – how to use multi-field LIKE syntax in a SELECT statement. The most important thing to understand in Node.js is a callback mechanism and its purpose.  […]

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