Practical SBS

Practical Advice for Small Business Server Administrators

MySQL

  • 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… Continue reading

    ,

  • 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

    , ,

  • 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

    ,

About Me

Microsoft Certified System Administrator; Fair Weather Rambler; Home Brewer; Park Runner; and sometime Barnsley Supporters FC Footballer.

Recent Posts