MySQL

MySQL Backups

Your data are valuable. If, God forbid, some disaster befalls your database then you should have a plan in place for how to recover your data. In this post I describe a simple strategy for backing up a MySQL database. This might not be the best approach, but it has worked for me.

Quick Wordpress Install with Docker

I’ve just put together a Wordpress site for my older daughter. It’s hosted on DigitalOcean and all of the infrastructure is handled with Docker. This post describes the steps in the (easy) install process.

Setting Up Time Zones in MySQL

I’m in the process of setting up a Zinnia blog on one of my Django sites. After putting all of the necessary plumbing in place I got the following message on first visiting the blog URL: Database returned an invalid value in QuerySet.datetimes(). Are time zone definitions for your database and pytz installed? The solution to this is to copy your system’s time zone information across to the database.

Increasing MySQL Packet Maximum Size

In the process of uploading a massive CSV file to my Django application my session data are getting pretty big. As a the result I’m getting these errors: (1153, "Got a packet bigger than 'max_allowed_packet' bytes") and (2006, 'MySQL server has gone away'). The second error is potentially unrelated. After some research it became apparent that the source of the problem is my max_allowed_packet setting.