OSDN Git Service

Specify DB_CHARSET as default-character-set for wp-db-import
authorWeston Ruter <weston@x-team.com>
Fri, 6 Sep 2013 00:05:45 +0000 (17:05 -0700)
committerWeston Ruter <weston@x-team.com>
Fri, 6 Sep 2013 00:05:45 +0000 (17:05 -0700)
commit1c3f9e5b5a00a9ba976572e736b47c8f28808d9a
treebd905d2e49d62bafad62aa99271b451c9292f08d
parent59f72ed557b536fe95ffc2ff78483f1505ae6f94
Specify DB_CHARSET as default-character-set for wp-db-import

A DB export followed by a DB import of the same file was resulting in
corrupted UTF-8 characters. The script was being run in the
varying-vagrant-vagrants environment which has latin1 as the default
charset:

mysql> show variables like "character_set_%";
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | latin1                     |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
php/commands/db.php