Monthly Archives

MySQL Permissions Required to Export Procedures

Sat, 28/01/2023 - 16:42 -- James Oakley
MySQL Logo

If you run an application that includes a database, you want to be taking backups regularly. Your backup needs to include tables, views and triggers. It must also include any stored procedures / routines you are using. Otherwise, when you restore from backup, your procedures will be missing.

This article is not about Microsoft SQL Server. This concerns MySQL and its forks MariaDB and Percona.

I've found lots of people asking this question on the web, but not many of the posts I've found have a working answer.

Blog Category: 

Cats and Anti-Freeze: A Parable

Thu, 26/01/2023 - 10:49 -- James Oakley

Where the North Sea meets the Atlantic lies a small country, the United Isles of Great Britannia (GB for short)

It is often reported that New Zealand has more sheep than people. GB has more cats than people – they are a nation of cat-lovers. As a result, a thriving industry in veterinary medicine has developed.

Blog Category: 

Mind your Language: Church of England Sexuality Debates

Thu, 19/01/2023 - 09:28 -- James Oakley

Yesterday, the Church of England published a press release summarising the proposals being brought by the college of Bishops at the end of the 6-year consultation process on same-sex marriage. This included a series of national conversations (tautologically, "shared conversations"), which took place at the General Synod and locally, and a course and set of resources branded "Living in Love and Faith".

S&P500 Part 2: Does last year's performance tell you anything about next year

Mon, 02/01/2023 - 17:14 -- James Oakley

The second of two blog posts looking at how the S&P 500 performance one year impacts what happens in the following year. The first post just looked at how many years saw the index decline or increase. In this follow-up post, I look at the actual figures: By how much did it go up or down? Does this more detailed analysis show any patterns that we previously dismissed?

Blog Category: 
Additional Terms