diff options
| author | emkael <emkael@tlen.pl> | 2021-06-12 21:02:14 +0200 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2021-06-12 21:05:32 +0200 |
| commit | 3f91822784bb5650dee2d46daac9b1a21dd6b545 (patch) | |
| tree | 0b7dffbf833eb49b116188a8cb180ee75b48bfc0 /dumps | |
| parent | 4e94ecfd0430522496a9ef8e55b7782d86ef815c (diff) | |
Encoding fixes for SQL dumps
Diffstat (limited to 'dumps')
| -rwxr-xr-x | dumps/load-dumps.sh | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/dumps/load-dumps.sh b/dumps/load-dumps.sh index a94f500..a365c16 100755 --- a/dumps/load-dumps.sh +++ b/dumps/load-dumps.sh @@ -2,7 +2,7 @@ pushd $(dirname $0) >> /dev/null grep -v '^#' .mapping | while read DB DUMP do - grep -v 'CREATE DATABASE' $DUMP | grep -vi '^Use ' | mysql ${LIGA_MYSQL_CONNECTION_OPTS} $DB + grep -v 'CREATE DATABASE' $DUMP | grep -vi '^Use ' | sed 's/SET NAMES cp1250/SET NAMES utf8mb4/g' | mysql ${LIGA_MYSQL_CONNECTION_OPTS} $DB if [[ $(mysql ${LIGA_MYSQL_CONNECTION_OPTS} $DB -N -e "SELECT language FROM params;") == *"english.language"* ]] then <logoh.en.sql mysql ${LIGA_MYSQL_CONNECTION_OPTS} $DB |