[arch-general] upgrading mysql to mariadb

[David Benfell]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,

I had managed not to see this:
https://www.archlinux.org/news/mariadb-replaces-mysql-in-repositories/

But it turned up on one of my feeds today, so I went to work. All went
well until the final step, the upgrade:

Phase 3/3: Running 'mysql_fix_privilege_tables'...
ERROR 1064 (42000) at line 87: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near '(6) NOT NULL, user_host MEDIUMTEXT NOT NULL,
thread_id INTEGER NOT NULL, server_' at line 1
ERROR 1243 (HY000) at line 88: Unknown prepared statement handler
(stmt) given to EXECUTE
ERROR 1243 (HY000) at line 89: Unknown prepared statement handler
(stmt) given to DEALLOCATE PREPARE
ERROR 1064 (42000) at line 95: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near '(6) NOT NULL, user_host MEDIUMTEXT NOT NULL,
query_time TIME(6) NOT NULL, lock_t' at line 1
ERROR 1243 (HY000) at line 96: Unknown prepared statement handler
(stmt) given to EXECUTE
ERROR 1243 (HY000) at line 97: Unknown prepared statement handler
(stmt) given to DEALLOCATE PREPARE
ERROR 1064 (42000) at line 343: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near '(6) NOT NULL,
ERROR 1064 (42000) at line 354: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near '(6) NOT NULL,
ERROR 1548 (HY000) at line 1136: Cannot load from mysql.proc. The
table is probably corrupted
ERROR 1548 (HY000) at line 1137: Cannot load from mysql.proc. The
table is probably corrupted
ERROR 1548 (HY000) at line 1150: Cannot load from mysql.proc. The
table is probably corrupted
FATAL ERROR: Upgrade failed

I haven't checked thoroughly, but it appears my sites are all up. So I
really don't know what to make of this.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.19 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIcBAEBAgAGBQJRVhBJAAoJELJhbl/uPb4S7bwQAJHMeHYNO1I1PLD6/C9zvj+4
tNT7Z2qYAHyodnTY7ZzPs0726PX4OPPztPT4k28Bstl3CW4GSMyi9m2zliDJiJk+
q2mhfxNKkP3lAMH5Yq1Nzku86DEuibJtuzfSNm0HkNLGh9MnL/rL32nQRwaYT+XZ
1A8tBQtqNPUOvNLG6m1GoHqptwfuaWud72QWQ+iI3o8sqi2+rBeS9t0Lje3C3RVY
8R7XPk0ilOOwzItgC27zYWTJ8BuK//UsJ/cF4ZS1pcFk2+WvB9X7kwjKvFj0PP97
qqEjfnWwf6zspoCzKBg7rJQulh2VB4dGHaWljxWrDXyUn8DSoQ1Oyfz3GYHch0+l
vetXks11NhVDEzxiJ1rtBQsAtPrXjOunTXAU2b9kuIt5aMbQVgUrfyavqSBFUa6j
6LZVAT7dkmCYVZIHwDkuwBRmc02x1TrigzpUlv8sqNEnd/MDsgX0IvhXBhJAF5j0
DueF8m7TGl8wl1UgVvpNNmJ/cfiJWC3+k3cmKLG+ldvoHzPVgBSbR1zeFKsqD5N3
lcU8VOGosxf2GpBNAIyXT8LYMdwg1FXvX8zkf3wyyUc+LhgbxWhRpGsUM2Kc5m+K
X9UenI/SXJjrFBfRU31S+/voWQPCVPHb9RzHDM6oJyAsb7lDc6I/nRITDjXCu9U2
bzg/liGHVI39/2CYQpeO
=4+EX
-----END PGP SIGNATURE-----