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