Go · MySQL

Go SQL error “converting NULL to string is unsupported”

Go is a strongly typed programming language, and many SQL databases can also support unknown values. These values can lead to complications in Go when it encounters unexpected results such as NULL (unknown) for an empty string.

Docker · MySQL · Server · WordPress

Customise WordPress on Docker

In this guide, let's go through the process of installing and configuring WordPress on a Docker container using docker-compose. The primary goals are to install a bare-bones install with the ability to customise wp-config.php, php.ini and my.cnf. There is an expectation that you are familiar with Docker, WordPress, PHP and MySQL configuration files. Install WordPress… Continue reading Customise WordPress on Docker

backup · Linux · MySQL

Backup your MySQL/MariaDB database easily using Percona XtraBackup

Over the years I have looked around for easy to use MySQL database backup tools that I can quickly and reliably automate. I've tried many unsatisfactory solutions but finally I have found something I am happy with, Perscona's XtraBackup. Unfortunately for Windows users this is a Linux only solution. Percona is an enterprise focused database company with… Continue reading Backup your MySQL/MariaDB database easily using Percona XtraBackup