MySQL: Referential Integrity

I recently wrote an article covering Referential Integrity within Microsoft SQL Server. This article covers the same subject within MySQL Server. The principle of using “Foreign Keys” is exactly the same. We will be using phpMyAdmin to add the key(s). This will be familiar to anyone who maintains a MySQL Database. For the purpose of …

XAMPP 1.7.3 for Windows: Folder Structure

The following is a summary of the contents of each folder within a Windows XAMPP installation. Folder Description Version Notes Anonymous       Apache Web Server Service 2.2.14 Configuration file is: “apache\conf\httpd.conf” cgi-bin       FileZillaFTP FTP Service 0.9.33 Configure using the XAMPP Console. htdocs Web Site Pages     install     …

Migrate MySQL 4.1 to MySQL 5.x (XAMPP for Windows)

I recently moved a standalone MySQL 4.1.7 Server across to a brand new XAMPP Server Running MySQL 5.1.41. This post sets out the procedure I used. Backup the Existing Database (on the Source Server) Load phpMyAdmin Select the database you wish to Migrate (make a not of the Collation Type) Select the “Export” Tab Check …