I have a serious problem.
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.

my.cnf is here;

[client]
default-character-set=utf8
#password	= your_password
port		= 3306
socket		= /opt/lampp/var/mysql/mysql.sock

[mysqld]
lower_case_table_names=1
default-character-set=utf8 
init_connect=SET collation_connection = utf8_general_ci 
init_connect=SET NAMES utf8 
default-character-set=utf8 
character-set-server=utf8 
collation-server=utf8_general_ci 
skip-name-resolve 

port		= 3306
socket		= /opt/lampp/var/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

default-storage-engine=innodb
server-id	= 1

innodb_data_home_dir = /opt/lampp/var/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /opt/lampp/var/mysql/
innodb_log_arch_dir = /opt/lampp/var/mysql/
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
socket		= /opt/lampp/var/mysql/mysql.sock
default-character-set=utf8 
no-auto-rehash
safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

Please let me know how to solve this problem.

Thanks in advance.

    Write a Reply...