Awhile back, I wrote up some instructions for doing a basic install of MySQL on Windows, including the steps to secure it. Now that I’m working on another MySQL book, I decided to start putting together some videos to go with it and I’ve created a couple on MySQL / MariaDB installation. These videos include…
All posts in #LearnMySQLNow
A Few Thoughts on the Book Writing Process
It Seems Like I’ve Been Here Before … People seem fairly impressed when I mention that I’ve written a couple of books on databases and software. I try not to make a big deal of it, just mentioning it in passing as appropriate, because I actually don’t consider it to be a big deal. I’m…
How to Perform a Basic MySQL Installation in Windows
One of the nice features of MySQL as a database software is its noinstall option in which you download the files themselves and perform a manual installation that takes just under a gigabyte of space on your drive. If you’re a developer or a student, this means you can quickly create a new self-contained instance wherever…
How To Create a Local WordPress site with XAMPP
XAMPP is one of many AMP software stacks (Apache – MySQL – PHP) that can be used to create a local web development environment for design and testing. It automatically installs and configures Apache as a web server so that you can view your pages through http://localhost, MySQL as a database server for website data…
Calculated Fields in CiviCRM
One of CiviCRM’s strengths is the ability to add custom fields to hold specific information about your contacts. One thing it doesn’t offer (yet) is a calculated field type that will present the results of calculations of other fields. While calculated fields are generally discouraged in relational database design, they are sometimes necessary within a…
Importing Case Data into CiviCase
Migrating to CiviCase On a recent project, I setup CiviCRM and CiviCase to enable a local organization to better manage its client database. The old database had been developed in Borland Paradox and was quickly becoming unusable. As a free and open source solution, CiviCRM turned out to be just the solution needed to accommodate this…
MySQL User Defined Function Example: Data Cleanup
(Updated June 9, 2016) The Challenge One of my current projects involves migrating a large amount of data away from an old custom Borland Paradox application into a new CiviCRM system. As with too many quickly-constructed apps, this old Paradox database wasn’t especially well designed and, among other the other challenges in salvaging the data, there were…
Installing MySQL on Mac OS X El Capitan
A few months ago, I wrote about how to install MySQL on Windows with IIS. Now I want to show you how to create an AMP web programming stack (Apache, MySQL & PHP) on Mac OS X. As with Windows, you could just go with a ready-made development environment like MAMP but, if you’re going to be…
A Complete Guide to Installing MySQL and PHP with IIS
Note: This article was written in 2015 and is in the process of being updated. It is still useful as a general guide for issues you might encounter in this type of installation. Please take this into consideration when downloading components. One of my latest projects was setting up WordPress, the popular content management system,…
Fixing the Orange (or Red) Status Icon in WampServer
As part of my latest project, I decided to try out WampServer, the Windows development environment for developing web applications with Apache web server, MySQL database and PHP scripting (Windows, Apache, MySQL, PHP – WAMP). Packages like WampServer and EasyPHP are simplified ways to create a testing environment on your PC without spending a lot…