MySQL – Domain Web Center

Node.js -understanding callback when you have to wait

2024-07-30 Udar Gromov 0

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

How to Install WordPress 4.X on Windows 10 and IIS 7.5

2024-07-19 Udar Gromov 6

This article is written for those who need to test/evaluate features of new WordPress release on a local machine before rolling it out to all the serves. This article describes running PHP on IIS 7.5 through FastCGI. For best results, reader is required to be able to start and stop […]

How to Work with MySQL – Basic Tasks

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

PHP chokes server with TEMP files – Updated and Solved

2024-04-23 Udar Gromov 0

I am running PHP on IIS 7.5. This is a Windows 2012 Server. Fresh clean install every time. The only way to access and delete these TEMP files are by using a command prompt. And this deletion procedure will run for several DAYS . . . The Problem The story […]

Adding a new WordPress site to an Existing Installation

2024-01-30 Udar Gromov 0

Task You already have a working WordPress (WP) site. Now, you need to add one more site with a new MySQL database. This document describes how to add one more database and install a new WP site on the same server. Download Download latest WordPress ZIP package (3.X) and unzip […]

How to Move MySQL D/B Files (Windows)

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

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