#24995
Building a Database-Driven Web Site Using PHP and MySQL
A hands-on look at what's involved in building a database-driven Web site. We'll be using two new tools for this: the PHP scripting language and the MySQL relational database.
Yank, Kevin. MySQL (2004). Articles>Web Design>Server Side Includes>SQL
#24996
An Introduction to Database Normalization
When users ask for advice about their database applications, one of the first things I try to help them with is the normalization of their table structure. Normalization is the process of removing redundant data from your tables in order to improve storage efficiency, data integrity and scalability. This improvement is balanced against an increase in complexity and potential performance losses from the joining of the normalized tables at query-time.
Hillyer, Mike. MySQL (2004). Articles>Information Design>Databases>SQL
#31816
Migrating from Microsoft SQL Server and Access to MySQL 
In this article I will cover the basics of migrating an application from an Access or SQL Server database to MySQL. We'll start with various reasons why you should (or should not) migrate your existing Access or SQL Server database to MySQL, then cover the planning stages of an application migration. Next we will look at the tools and methods for migrating your actual data from Access/MSSQL to MySQL, followed by some general guidelines for modifying your client application from a Microsoft database to MySQL. Finally, we'll look at some considerations to make when deploying your new MySQL database and application.
Hillyer, Mike. MySQL (2007). Articles>Information Design>Databases>SQL
#25352
Securing a MySQL Server on Windows
Windows servers can be difficulty to keep secure. The intent of this article is to list the steps that an administrator can take to properly secure a MySQL installation on Windows. While the procedures listed are written for Windows users, the principles contained herein will be of benefit to users of Linux and Unix as well.
Hillyer, Mike. MySQL (2005). Design>Information Design>Security>SQL
