From 36b447818723ae25d79c3b8250e892ae0fe9af74 Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Wed, 1 Mar 2023 07:45:18 +0100
Subject: Databases

---
 issues/database-not-responding.gmi        | 2 +-
 issues/systems/mariadb/move-to-innodb.gmi | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/issues/database-not-responding.gmi b/issues/database-not-responding.gmi
index 8cb5656..5531e31 100644
--- a/issues/database-not-responding.gmi
+++ b/issues/database-not-responding.gmi
@@ -306,7 +306,7 @@ show open tables where in_use > 1;
 | Database  | Table          | In_use | Name_locked |
 +-----------+----------------+--------+-------------+
 | db_webqtl | ProbeFreeze    |    182 |           0 |
-| db_webqtl | ProbeSet       |      3 |           0 |
+| db_webqtl | ProbeSet       |      3 |           0 | <- text, still latin1
 | db_webqtl | ProbeSetXRef   |      3 |           0 |
 | db_webqtl | PublishFreeze  |      7 |           0 |
 | db_webqtl | Species        |     94 |           0 |
diff --git a/issues/systems/mariadb/move-to-innodb.gmi b/issues/systems/mariadb/move-to-innodb.gmi
index 13fecce..72520c5 100644
--- a/issues/systems/mariadb/move-to-innodb.gmi
+++ b/issues/systems/mariadb/move-to-innodb.gmi
@@ -1027,8 +1027,8 @@ So:
 
 ```
 show create table TempData;
-ALTER TABLE TempData CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
 ALTER TABLE TempData ENGINE = InnoDB;
+ALTER TABLE TempData CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
 alter table TempData add primary key (Id);
 show create table TempData;
 ```
-- 
cgit v1.2.3