MySQueaL Resources

Apache VirtualHost

To be able to host more than one web site on the same server with the same IP address, you will need to set up virtual hosting with Apache. This article explains the relavent directives for hosting separate domains and sub-domains on the same server.

Scanning Apache Logs with PHP

In this article I show one method how you might write a PHP program for parsing Apache log files to watch for certain users, or to watch for users accessing specific files on a web server.

MySQL Sub-Queries

Although MySQL provides the JOIN clause for joining data tables together for extracting data, sub-queries is a cleaner method. This tutorial article explains various types of subqueries and provides examples of each.

PHP and MySQL

If you need just the bare minimum for creating a PHP program which will connect to a MySQL server and retrieve data, this article will help you get started quickly.

Apache Logs

By default, Apache logs information on user activities and errors. However, with a few specific directives, you can alter what information is logged and where it's stored. This article explains the use of the directives TransferLog, ErrorLog, LogLevel, and CustomLog.

Apache Server Side Includes

For specific needs, this article explains how to set up and use server side includes (SSI). It shows how to configure Apache and gives some examples of SSI usage.

PHP and XML

This article shows how to read XML data using PHP and DOM (Document Object Model) and MySQL.

Using PHP to Backup MySQL

In this article I describe how to develop a PHP program to automatically backup MySQL. It presents a couple of simple methods for doing this.

E-mail Notices with PHP

This article describe a project in which I develop a simple PHP script to monitor personal email on the server. It sends a text message on to my cell phone when email from people on my watch list are retrieved.

Multiple MySQL Servers

For testing new versions of MySQL, or for isolating databases, it sometimes can be useful to set up separate MySQL servers on the same computer server. This article explains how to do that using different ports and the mysqld_safe script.

Perl CGI

This is a quick introduction to using the CGI perl module. It shows how to write a script for a web site using the more commonly used functions.

File Directories with Apache

Some web sites let you browse directories that contain files for downloading. Those directories will have a file listing, text describing the contents, along with their own icons files. This article explains how to configure Apache to display these things.

Testing a MySQL Version

If you want to test a new version of MySQL before upgrading your server, this article will explain how to have two versions running simultaneously: one for production, the other for testing.

Interim Data Recovery with MySQL

If you system performs data backups daily of your MySQL databases, but you lose data somehow between backups, you could possibly use point-in-time-recovery methods to restore interim data lost from your binary logs.

Live Backups of MySQL Using Replication

This article provides an introduction to replication service with MySQL. It focuses primarily on how to use a slave server to perform backups of data without having to shutdown the master server.

Restoring Data

If you lose your data in MySQL, but have been using mysqldump to make regular backups of you data in MySQL, you can use the dump files to restore your data. This article explains how to do this and how to avoid clobbering your data in the process.

Apache User Maintenance with PHP

In the project described in this article, I demonstrate how you might develop a PHP program for managing Apache users. It's primarily an example of how to use PHP for accessing files.

Web Interfaces in MySQL, III

This is the third part of a four-part article—of which I only wrote three parts. In the second article, I described creating a web page with Perl to modify data of a selected row from a table. When the data is changed, another Perl script is called to save the changes, to modify the data in the MySQL table. This article covers that script.

Creating Sites with MySQL and PHP

This tutorial is a primer for someone wanting to set up a web site using PHP and MySQL quickly. It gives the basics and just enough to get started and to accomplish something fast.

Being Selective with MySQL

This article is a basic tutorial explaining the SELECT statement used in MySQL to retrieve data from a database. It includes many examples.

MySQL Application Upgrade

For those who develop software applications using MySQL which is installed and used by clients or remotely located coworkers, this article goes through some of the aspects to consider when creating an upgrade to an application.

Embedding the MySQL Server Library

It's possible to embed the MySQL server library in an applications so that you don't have to install MySQL on an end user's computer. This is useful for small devices. This article explains how to do that.

Perl Interfaces for MySQL

If you need to write a program in Perl that will access MySQL, this article will get you started quickly. It shows how to connect to MySQL and to run queries.

Developing a MySQL Template

This ambitous article explains how to create a Perl scripts for upgrading a customized Perl application which uses MySQL. It provides examples to present an approach to creating software for non-technical people to use to upgrade MySQL databases applications that the reader may have developed.

C Interface to MySQL

If you need to write a program in C that will access MySQL, this article will get you started quickly. It shows how to connect to MySQL and to run queries.

Use MySQL to Stop Editing Web Pages

In this article I explain how to create a Perl interface to MySQL for retrieving and displaying data in a web page. It's a very involved, more intermediate article on using the Perl CGI and DBI modules.

Apache Basics

This article discusses the basics of configuring the basics of the Apache web server. It's referenced by several other Apache articles of mine on this site. So if you're just getting starting learning about Apache, this one should be read first.

PHP for Monitoring an FTP Site

This article show how to develop a PHP program to monitor an FTP site for files that are uploaded. It outlines creating a web interface for listing the files on the FTP site.

Apache Redirection

When a user goes to a web page that doesn't exist, an error will be returned. To better handle these kinds of errors, redirection an be used in Apache. The Apache directive Redirect may be used also to redirect users to new sections of a web site, a different domain, or a different server. This article describes these possibilities and how to configure Apache to do so.

Apache Virtual Hosting

If you want to host more than one web domain on one server, you can use the Apache directive VirtualHost. This article explains the basic configuration for Apache for vitual hosting.

Web Interfaces in MySQL, I

This is the first part of a four-part article—of which I only wrote three parts. It gives detailed explanations and examples of how to develop a web interface to MySQL with Perl. This article covers creating a simple database and a Perl CGI script to connect to it, a web interface to the database.

Apache Authentication

For private sites or just sections of a web site that you want to make accessible only to approved users, Apache can handle authentication for users. This article explains how to configure Apache, as well as how to use the htpasswd utility for creating users and setting their passwords.

Web Interfaces in MySQL, II

This is the first part of a four-part article—of which I only wrote three parts. It gives detailed explanations and examples of how to develop a web interface to MySQL with Perl. In the first article, I described creating a web page to list minimal information of rows from a table, with hyperlinks to another web page which will provide details of a selected row. This article explains the creation of that web page with details of a selected record.

Creating a Backup User

If you plan to set up a script to make backups of MySQL with a utility like mysqldump, you shouldn't use the root user. Instead, you should create a special administrative user. This very brief article explains how to create such a user with just the right amount of user privileges.

Backing Up MySQL

This tutorial explains several methods of backing up data in MySQL. It shows how to do this at the filesystem level (not a recommended method), and with mysqldump, mysqlhotcopy, and mysqlsnapshot.