Recovering files from broken Raspberry Pi – Part 1

December 5, 2017 Matt Thornton 0

I have a Raspberry Pi 3 which serves solely as a MySQL server. It does have an important (production-esque) purpose but despite that… I didn’t have it backed up properly. Oops. So when it spectacularly died the other day, and, um… production things… stopped productioning… I worried a little. Well […]

MySQL table name case sensitivity

October 1, 2017 Matt Thornton 0

Just encountered a fun little issue when trying to move something from a local MySQL server to a ‘Prod’ server. The difference in architecture being that dev MySQL was running on OSX whereas the ‘Prod’ MySQL was running on Linux (debian). The issue was that a lot of my queries/views/procedures […]

gnucash + mysql + OS X 10.10: getting it running

April 7, 2015 Matt Thornton 0

This post will help you to get gnucash running with MySQL on OS X 10.10. Background I do the bookkeeping and accounts for a variety of small NFPs or charitable organisations. I recently moved my bookkeeping for these from a combination of Sharepoint (seriously) and SSRS and Excel in to […]

No Picture

Auto generate SQL audit tables and database triggers

November 28, 2012 Matt Thornton 0

One approach to monitoring version history of items in SQL tables is to use an _Audit table version with database triggers. However, the creation and maintenance of the tables and triggers can be time consuming. This post provided a nice script to automate the creation but unfortunately it suffered a […]