Installing a XAMPP development
environment for WordPress

This article examines why a local development and testing environment is a good idea for a remotely hosted WordPress site, and how to go about installing such an environment with the open source XAMPP web server stack on a Windows PC.

Why?

It’s good practice, based on professional development methods.

In well-funded private sector environments staffed by skillful specialists, every live system has at least one development environment, but maybe several sandboxes independent of each other.

Each of these sandboxes connects to an n-Tier development environment of servers and software. The concept of ‘n-Tier’ architectures refers to the number (hence the n) or levels of components in a complete system. The reason I specified well-funded above is that the expense of a system increases with every layer of hardware and software required.

For that reason, the development environment might not resemble the production environment very closely at all, as suggested in the hypothetical model illustrated in Figure 1 below. In that hypothetical, a bunch of developer PCs or laptops connect to just two development servers simulating a production environment that involves five servers (and maybe even more if one or another function is clustered for failover or scalability).

Continue reading “Installing a XAMPP development
environment for WordPress”

Installing a XAMPP developmentenvironment for WordPress

This article examines why a local development and testing environment is a good idea for a remotely hosted WordPress site, and how to go about installing such an environment with the open source XAMPP web server stack on a Windows PC.

Why?

It’s good practice, based on professional development methods.

In well-funded private sector environments staffed by skillful specialists, every live system has at least one development environment, but maybe several sandboxes independent of each other.

Each of these sandboxes connects to an n-Tier development environment of servers and software. The concept of ‘n-Tier’ architectures refers to the number (hence the n) or levels of components in a complete system. The reason I specified well-funded above is that the expense of a system increases with every layer of hardware and software required.

For that reason, the development environment might not resemble the production environment very closely at all, as suggested in the hypothetical model illustrated in Figure 1 below. In that hypothetical, a bunch of developer PCs or laptops connect to just two development servers simulating a production environment that involves five servers (and maybe even more if one or another function is clustered for failover or scalability).

Continue reading “Installing a XAMPP developmentenvironment for WordPress”

Deleting spam comments from
WordPress MySQL database

Even if server space is not expensive, it pays to massage the MySQL database back-end of WordPress from time to time.
One example of this is deleting entries for spam comments.

The WordPress blogging system relies on the free MySQL database, which stores the information needed to link all posts to images and themes. Images are stored separately in a folder called ‘uploads’: < root >/wp-content/uploads, where < root > is the directory path on the server to the WordPress installation.

The database stores all words typed or copy-pasted into WordPress, including all comments.

Continue reading “Deleting spam comments from
WordPress MySQL database”

Deleting spam comments from WordPress MySQL database

Even if server space is not expensive, it pays to massage the MySQL database back-end of WordPress from time to time.
One example of this is deleting entries for spam comments.

The WordPress blogging system relies on the free MySQL database, which stores the information needed to link all posts to images and themes. Images are stored separately in a folder called ‘uploads’: < root >/wp-content/uploads, where < root > is the directory path on the server to the WordPress installation.

The database stores all words typed or copy-pasted into WordPress, including all comments.

Continue reading “Deleting spam comments from WordPress MySQL database”

Deleting spam comments fromWordPress MySQL database

Even if server space is not expensive, it pays to massage the MySQL database back-end of WordPress from time to time.
One example of this is deleting entries for spam comments.

The WordPress blogging system relies on the free MySQL database, which stores the information needed to link all posts to images and themes. Images are stored separately in a folder called ‘uploads’: < root >/wp-content/uploads, where < root > is the directory path on the server to the WordPress installation.

The database stores all words typed or copy-pasted into WordPress, including all comments.

Continue reading “Deleting spam comments fromWordPress MySQL database”