手搓版客户端 清空重建 web

(
set -e

test -s /home/web.sql

mariadb -e 'DROP DATABASE IF EXISTS web;
CREATE DATABASE web CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;'

mariadb --default-character-set=utf8mb4 web < /home/web.sql

mariadb -e "SELECT COUNT(*) AS remaining_bad_columns
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA='web'
AND CHARACTER_SET_NAME NOT IN ('utf8mb4','ascii');"
)