diff options
author | Sytse Sijbrandij <sytse@gitlab.com> | 2014-10-15 09:18:49 +0200 |
---|---|---|
committer | Sytse Sijbrandij <sytse@gitlab.com> | 2014-10-15 09:18:49 +0200 |
commit | bf01c789c77b8826cc6606e51a902db90aadac70 (patch) | |
tree | e854613aa63bbb8375a779b7bc098139c32b0b0d | |
parent | e3bd17a7ba5238c147a79d0770e8503fd913610c (diff) | |
parent | 0901345d1b4a83f37f281a6229aa115775a3d5c9 (diff) | |
download | gitlab-ce-bf01c789c77b8826cc6606e51a902db90aadac70.tar.gz |
Merge pull request #8041 from bbodenmiller/patch-4
make sure tables are UTF8 capable
-rw-r--r-- | doc/update/7.3-to-7.4.md | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/doc/update/7.3-to-7.4.md b/doc/update/7.3-to-7.4.md index 2e1b993aeb8..ba3be5e53b6 100644 --- a/doc/update/7.3-to-7.4.md +++ b/doc/update/7.3-to-7.4.md @@ -26,6 +26,15 @@ SELECT CONCAT('ALTER TABLE gitlabhq_production.', table_name, ' ENGINE=InnoDB;') # If previous query returned results, copy & run all outputed SQL statements +# Convert all tables to correct character set +SET foreign_key_checks = 0; +SELECT CONCAT('ALTER TABLE gitlabhq_production.', table_name, ' CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') AS 'Copy & run these SQL statements:' FROM information_schema.tables WHERE table_schema = 'gitlabhq_production' AND `TABLE_COLLATION` <> 'utf8_unicode_ci' AND `TABLE_TYPE` = 'BASE TABLE'; + +# If previous query returned results, copy & run all outputed SQL statements + +# turn foreign key checks back on +SET foreign_key_checks = 1; + # Find MySQL users mysql> SELECT user FROM mysql.user WHERE user LIKE '%git%'; |