James's Weblog

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: 

Fact checking Bloomberg: Does an SP500 loss make another next year less likely

Mon, 26/12/2022 - 17:47 -- James Oakley
Stock chart showing successive down candles

A Bloomberg article at the end of 2022 made the claim that after a negative year for the S&P 500, the following year is relatively unlikely to follow suit. This post looks at the statistics to see whether such a claim holds true. We also look at other claims they made about what happens when you do get two bad years in a row: is the second year worse than the first, and will a third bad one follow?

Blog Category: 

Questions from Christian Youth

Wed, 16/11/2022 - 09:43 -- James Oakley

Yesterday evening, I had the joy of being invited to our church midweek youth ministry. The teenagers had been given the chance to write down questions they'd like to ask one of their pastors, and I was invited along to tackle those questions and any others that came up during the course of the evening.

Blog Category: 

Stopping BitDefender reverting your Hosts file

Fri, 14/10/2022 - 12:31 -- James Oakley
Bitdefender

Currently, my anti-virus software of choice is Bitdefender.

There's a file on a Windows computer called the "hosts file", that most people have no need to change. It lives at c:\windows\system32\drivers\etc\hosts. (Linux-based systems have a hosts file too, at /etc/hosts.) In fact, unless you have a need to change it, and know what you're doing, leave well alone.

Blog Category: 

Preserving window sizes for individual message in Microsoft Outlook

Sat, 17/09/2022 - 09:08 -- James Oakley
Microsoft Outlook Icon

This is one of those posts where I stick something on here to help me find it again, and because I won't be the only person trying to solve this.

The Problem: Size and Position of Individual Messages

Microsoft Outlook (msoutlook) is an email client, part of the Microsoft Office suite, and available as part of the Office 365 subscription. Do not confuse this with their online Outlook email service, which is the successor of Hotmail.

Blog Category: 

Pages

Subscribe to James's Weblog
Additional Terms