I can see mysql data at web page, but not at sql.
My database is "utf8" and "utf8_genral_ci", but web program's charset is "euc-kr".
The problem is backup and restore.
The command "mysqldump -uroot -p --default-character-set=euc-kr mydb > /my-backup.sql" can produce backup sql, but I could not read and restoring does not works. Also " --default-character-set=utf8" shows same result.
- Code: Select all
mysqldump -uroot -p --default-character-set=euc-kr my-db > my-backup.sql
mysqldump -uroot -p --default-character-set=utf8 my-db > my-backup.sql
my.cnf is here;
[client]
# password = your_password
port = 3306
socket = mysql
default-character-set=utf8
[mysqld]
basedir="I:/apm_packages/xampp/mysql"
tmpdir="I:/apm_packages/xampp/tmp"
datadir="I:/apm_packages/xampp/mysql/data"
language=I:/apm_packages/xampp/mysql/share/korean/
#default-character-set=euckr
port = 3306
socket = mysql
#old-passwords
character-set-server = utf8
collation-server = utf8_general_ci
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
server-id = 1
innodb_data_home_dir = I:/apm_packages/xampp/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = I:/apm_packages/xampp/mysql/data/
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
set-variable = innodb_lock_wait_timeout=50
[mysqldump]
quick
max_allowed_packet=16M
default-character-set=utf8
[mysql]
no-auto-rehash
safe-updates
[isamchk]
key_buffer = 8M
sort_buffer_size = 8M
[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
[WinMySQLadmin]
Server="I:/apm_packages/xampp/mysql/bin/mysqld.exe"
#user=root
#password=
And the result of "show variables like 'c%'"
+--------------------------+----------------------------------+
| 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 | /opt/lampp/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 10 |
+--------------------------+----------------------------------+
