From 7c2d0642c43b75d1e17d88ecd4d3e895aaaf2032 Mon Sep 17 00:00:00 2001 From: root Date: Mon, 22 Feb 2021 20:01:41 +0100 Subject: add default charset --- backup_db.sh | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/backup_db.sh b/backup_db.sh index b5eaa29..d35f921 100755 --- a/backup_db.sh +++ b/backup_db.sh @@ -128,7 +128,7 @@ databases=$($nice -n 19 $mysql -u root -N -e "show databases;" | $grep -v "^info for database in $databases do # dump database - $nice -n 19 $mysqldump -u root "$database" > "$database.sql" + $nice -n 19 $mysqldump --default-character-set=utf8mb4 -u root "$database" > "$database.sql" backup_db "$database" "$backupdirsingle" "$usesamerepo" -- cgit v1.2.3