MySQL: Referential Integrity

May 17, 2013May 17, 2013 ~ Stephen Holder ~ Leave a comment

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 … Continue reading MySQL: Referential Integrity

XAMPP 1.7.3 for Windows: Folder Structure

May 23, 2012April 1, 2014 ~ Stephen Holder ~ Leave a comment

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 … Continue reading XAMPP 1.7.3 for Windows: Folder Structure

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

January 25, 2011January 25, 2011 ~ Stephen Holder ~ Leave a comment

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 … Continue reading Migrate MySQL 4.1 to MySQL 5.x (XAMPP for Windows)