Tag: mysql

All the articles with the tag "mysql".

• Upgrading MySQL in a Container

  Updated:3 Jul, 2020

  Upgrading MySQL 5.5 to 5.7 in a docker container set caused me some trouble. Setting the tag to 5.7.30 was all well and good but when I fired up the contai

• SQL Format

  Updated:5 Aug, 2019

  We've all got SQL that needs tidying up. https://poorsql.com/ or https://sqlformat.org/ or http://sqlformat.darold.net/ It wont fix your syntax but it will

• MySQL CSV Import

  Updated:24 Jul, 2019

  A little while ago I wrote a php routine to import CSV files that contain a lot of data into a MySQL table. It works, but it takes it's time doing so. I wa

• MySQL Repository Key Expired - 8C718D3B5072E1F5

  1 May, 2019

  Updates on my Stretch servers were failing due to an expired key. I tried the usual retrievals for keys using: $ sudo apt-key adv --keyserver keys.gnupg.ne

• DBeaver - SQL GUI

  6 Nov, 2018

  I've used a few SQL GUI's over the years, SQuirreL, DBVisualizer, HeidiSQL, MySQL Workbench, but the one that stands out recently is DBeaver . It's got a c

• MariaDB Apparmor and No login

  Updated:23 Feb, 2018

  As I've been messing around with Sphinx I discovered that MariaDB actually includes the SphinxSE plugin out of the box. So I figured I'd ditch my MySQL ins

• Mysql Broken After Apt Upgrade

  Updated:18 Jan, 2018

  My local install of mysql-community-server decided to fail today after applying some updates. I'm running Debian buster/sid so these kind of things are to be expected. But this was a totally new one to me.

• Bye, bye, Percona

  25 May, 2017

  For quite a few years we'd been running Percona on our Nagios server with no issues. So no reason to change, until sometime over the past few days the repo

• MySQL Enterprise

  Updated:26 Feb, 2017

  Today’s a MySQL day. After the shocker that is Microsoft Licensing I decided to seriously look at what MySQL has to offer the enterprise. I read their white paper and thought somethings sounds too good to be true. So I spent half an hour on the phone with someone in their enterprise team.

• MySQL Apt-Get Update Fails

  Updated:22 Feb, 2017

  Apt-get update fails because the PGP keys for the repository have expired. $ sudo apt-get update W: An error occurred during the signature verification. Th