Category: MySQL

Things I Learned Restoring a MySQL Dump File

May 6, 2026May 12, 2026 Andrew Comeau

I got an e-mail yesterday from a client who wants to move on from the MySQL-based CiviCRM solution I found for them years ago and needs one more backup before they switch over. I figure this is going to require a bit of query writing on my part to actually extract the data they need…

Databases, MySQL

Connecting Microsoft Access to MySQL and SQLite

July 3, 2022June 16, 2025 Andrew Comeau

Update, June 2025 – I’ve updated the Github repository with a version of this project for connecting Microsoft Access to SQLite. In my latest video, I demonstrate how to use Microsoft Access as a front-end for MySQL without having to create a DSN entry on the client machine. Access easily connects to MySQL through an…

Databases, Microsoft Access, MySQL

Installing MySQL and MariaDB (Videos)

February 10, 2020February 18, 2023 Andrew Comeau

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…

MySQL