데이터베이스를 사랑하는 사람들의 모임 데이터베이스 사랑넷

데이터베이스 이전 환경은 다음과 같습니다.

원본서버
- mysql 4.1
대상서버
- mysql 4.0

원본서버는 호주에 있는 IDC에 있고
대상서버는 한국에 있습니다.

호주에 있는 서버에는 telnet을 접근할 수가 없습니다.
따라서 phpMyAdmin에서만 데이터를 Export 받을 수 있습니다.
Export를 받으니 한글이 모두 ?로 나오네요
phpMyAdmin에서 "connection collation"을 바꾸면서 한번씩 다 해봤는데 안되네요

아래는 호주 mysql variable 입니다.

Server variables and settings

Variable	Session value / Global value
back log	50
basedir	/
binlog cache size	32,768
bulk insert buffer size	8,388,608
character set client	latin1
character set connection	latin1
character set database	latin1
character set results	latin1
character set server	latin1
character set system	utf8
character sets dir	/usr/share/mysql/charsets/
collation connection	latin1_swedish_ci
collation database	latin1_swedish_ci
collation server	latin1_swedish_ci
concurrent insert	ON
connect timeout	10
datadir	/var/lib/mysql/
date format	%Y-%m-%d
datetime format	%Y-%m-%d %H:%i:%s
default week format	0
delay key write	ON
delayed insert limit	100
delayed insert timeout	300
delayed queue size	1,000
expire logs days	0
flush	OFF
flush time	0
ft boolean syntax	+ -><()~*:""&\|
ft max word len	84
ft min word len	4
ft query expansion limit	20
ft stopword file	(built-in)
group concat max len	1,024
have archive	YES
have bdb	NO
have blackhole engine	NO
have compress	YES
have crypt	YES
have csv	NO
have example engine	NO
have geometry	YES
have innodb	YES
have isam	NO
have ndbcluster	NO
have merge engine	YES
have openssl	NO
have query cache	YES
have raid	NO
have rtree keys	YES
have symlink	YES
init connect
init file
init slave
innodb additional mem pool size	20,971,520
innodb autoextend increment	8
innodb buffer pool awe mem mb	0
innodb buffer pool size	209,715,200
innodb data file path	ibdata1:400M:autoextend
innodb data home dir	/var/lib/mysql
innodb fast shutdown	ON
innodb file io threads	4
innodb file per table	OFF
innodb flush log at trx commit	1
innodb flush method
innodb force recovery	0
innodb lock wait timeout	50
innodb locks unsafe for binlog	OFF
innodb log arch dir	/var/lib/mysql/
innodb log archive	OFF
innodb log buffer size	12,582,912
innodb log file size	5,242,880
innodb log files in group	3
innodb log group home dir	/var/lib/mysql/
innodb max dirty pages pct	90
innodb max purge lag	0
innodb mirrored log groups	1
innodb open files	300
innodb table locks	ON
innodb thread concurrency	8
interactive timeout	200
join buffer size	258,048
key buffer size	838,860,800
key cache age threshold	300
key cache block size	1,024
key cache division limit	100
language	/usr/share/mysql/english/
large files support	ON
lc time names	en_US
license	GPL
local infile	ON
locked in memory	OFF
log	OFF
log bin	OFF
log error
log slave updates	OFF
log slow queries	ON
log update	OFF
log warnings	1
long query time	10
low priority updates	OFF
lower case file system	OFF
lower case table names	0
max allowed packet	4,193,280
max binlog cache size	4,294,967,295
max binlog size	1,073,741,824
max connect errors	6,000
max connections	3,000
max delayed threads	50
max error count	64
max heap table size	16,777,216
max insert delayed threads	50
max join size	18,446,744,073,709,552,000
max length for sort data	1,024
max prepared stmt count	16,382
max relay log size	0
max seeks for key	4,294,967,295
max sort length	1,024
max tmp tables	32
max user connections	0
max write lock count	4,294,967,295
myisam data pointer size	4
myisam max extra sort file size	2,147,483,648
myisam max sort file size	2,147,483,647
myisam recover options	OFF
myisam repair threads	1
myisam sort buffer size	67,108,864
myisam stats method	nulls_unequal
net buffer length	16,384
net read timeout	30
net retry count	10
net write timeout	60
new	OFF
old passwords	OFF
open files limit	15,010
port	3,306
preload buffer size	32,768
prepared stmt count	0
protocol version	10
query alloc block size	8,192
query cache limit	1,048,576
query cache min res unit	4,096
query cache size	369,098,752
query cache type	ON
query cache wlock invalidate	OFF
query prealloc size	8,192
range alloc block size	2,048
read buffer size	2,093,056
read only	OFF
read rnd buffer size	262,144
relay log purge	ON
relay log space limit	0
rpl recovery rank	0
secure auth	OFF
server id	0
skip external locking	ON
skip networking	OFF
skip show database	OFF
slave net timeout	3,600
slave transaction retries	0
slow launch time	2
socket	/var/lib/mysql/mysql.sock
sort buffer size	5,242,872
sql mode
sql notes	ON
sql warnings	ON
storage engine	MyISAM
sync binlog	0
sync frm	ON
sync replication	0
sync replication slave id	0
sync replication timeout	0
system time zone	EST
table cache	640
table type	MyISAM
thread cache size	8
thread stack	196,608
time format	%H:%i:%s
time zone	SYSTEM
tmp table size	134,217,728
tmpdir	/tmp/
transaction alloc block size	8,192
transaction prealloc size	4,096
tx isolation	REPEATABLE-READ
version	4.1.21-standard-log
version comment	MySQL Community Edition - Standard (GPL)
version compile machine	i686
version compile os	pc-linux-gnu
wait timeout	100

다음은 한국 mysql variable 입니다.
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name                   | Value                                                                                                                                                                                                             |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log                        | 50                                                                                                                                                                                                                |
| basedir                         | /usr/local/mysql/                                                                                                                                                                                                 |
| binlog_cache_size               | 32768                                                                                                                                                                                                             |
| bulk_insert_buffer_size         | 8388608                                                                                                                                                                                                           |
| character_set                   | euc_kr                                                                                                                                                                                                            |
| character_sets                  | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert               | ON                                                                                                                                                                                                                |
| connect_timeout                 | 5                                                                                                                                                                                                                 |
| convert_character_set           |                                                                                                                                                                                                                   |
| datadir                         | /data/                                                                                                                                                                                                            |
| default_week_format             | 0                                                                                                                                                                                                                 |
| delay_key_write                 | ON                                                                                                                                                                                                                |
| delayed_insert_limit            | 100                                                                                                                                                                                                               |
| delayed_insert_timeout          | 300                                                                                                                                                                                                               |
| delayed_queue_size              | 1000                                                                                                                                                                                                              |
| flush                           | OFF                                                                                                                                                                                                               |
| flush_time                      | 0                                                                                                                                                                                                                 |
| ft_boolean_syntax               | + -><()~*:""&|                                                                                                                                                                                                    |
| ft_min_word_len                 | 4                                                                                                                                                                                                                 |
| ft_max_word_len                 | 254                                                                                                                                                                                                               |
| ft_max_word_len_for_sort        | 20                                                                                                                                                                                                                |
| ft_stopword_file                | (built-in)                                                                                                                                                                                                        |
| have_bdb                        | NO                                                                                                                                                                                                                |
| have_crypt                      | YES                                                                                                                                                                                                               |
| have_innodb                     | YES                                                                                                                                                                                                               |
| have_isam                       | YES                                                                                                                                                                                                               |
| have_raid                       | NO                                                                                                                                                                                                                |
| have_symlink                    | YES                                                                                                                                                                                                               |
| have_openssl                    | NO                                                                                                                                                                                                                |
| have_query_cache                | YES                                                                                                                                                                                                               |
| init_file                       |                                                                                                                                                                                                                   |
| innodb_additional_mem_pool_size | 1048576                                                                                                                                                                                                           |
| innodb_autoextend_increment     | 8                                                                                                                                                                                                                 |
| innodb_buffer_pool_size         | 8388608                                                                                                                                                                                                           |
| innodb_data_file_path           | ibdata1:10M:autoextend                                                                                                                                                                                            |
| innodb_data_home_dir            |                                                                                                                                                                                                                   |
| innodb_file_io_threads          | 4                                                                                                                                                                                                                 |
| innodb_force_recovery           | 0                                                                                                                                                                                                                 |
| innodb_thread_concurrency       | 8                                                                                                                                                                                                                 |
| innodb_flush_log_at_trx_commit | 1                                                                                                                                                                                                                 |
| innodb_fast_shutdown            | ON                                                                                                                                                                                                                |
| innodb_flush_method             |                                                                                                                                                                                                                   |
| innodb_lock_wait_timeout        | 50                                                                                                                                                                                                                |
| innodb_log_arch_dir             | ./                                                                                                                                                                                                                |
| innodb_log_archive              | OFF                                                                                                                                                                                                               |
| innodb_log_buffer_size          | 1048576                                                                                                                                                                                                           |
| innodb_log_file_size            | 5242880                                                                                                                                                                                                           |
| innodb_log_files_in_group       | 2                                                                                                                                                                                                                 |
| innodb_log_group_home_dir       | ./                                                                                                                                                                                                                |
| innodb_mirrored_log_groups      | 1                                                                                                                                                                                                                 |
| innodb_max_dirty_pages_pct      | 90                                                                                                                                                                                                                |
| innodb_max_purge_lag            | 0                                                                                                                                                                                                                 |
| innodb_table_locks              | ON                                                                                                                                                                                                                |
| interactive_timeout             | 28800                                                                                                                                                                                                             |
| join_buffer_size                | 131072                                                                                                                                                                                                            |
| key_buffer_size                 | 402653184                                                                                                                                                                                                         |
| language                        | /usr/local/mysql/share/mysql/english/                                                                                                                                                                             |
| large_files_support             | ON                                                                                                                                                                                                                |
| license                         | GPL                                                                                                                                                                                                               |
| local_infile                    | ON                                                                                                                                                                                                                |
| locked_in_memory                | OFF                                                                                                                                                                                                               |
| log                             | OFF                                                                                                                                                                                                               |
| log_update                      | OFF                                                                                                                                                                                                               |
| log_bin                         | OFF                                                                                                                                                                                                               |
| log_slave_updates               | OFF                                                                                                                                                                                                               |
| log_slow_queries                | OFF                                                                                                                                                                                                               |
| log_warnings                    | 1                                                                                                                                                                                                                 |
| long_query_time                 | 10                                                                                                                                                                                                                |
| low_priority_updates            | OFF                                                                                                                                                                                                               |
| lower_case_file_system          | OFF                                                                                                                                                                                                               |
| lower_case_table_names          | 0                                                                                                                                                                                                                 |
| max_allowed_packet              | 1047552                                                                                                                                                                                                           |
| max_binlog_cache_size           | 4294967295                                                                                                                                                                                                        |
| max_binlog_size                 | 1073741824                                                                                                                                                                                                        |
| max_connections                 | 150                                                                                                                                                                                                               |
| max_connect_errors              | 1000                                                                                                                                                                                                              |
| max_delayed_threads             | 20                                                                                                                                                                                                                |
| max_insert_delayed_threads      | 20                                                                                                                                                                                                                |
| max_heap_table_size             | 16777216                                                                                                                                                                                                          |
| max_join_size                   | 4294967295                                                                                                                                                                                                        |
| max_relay_log_size              | 0                                                                                                                                                                                                                 |
| max_seeks_for_key               | 4294967295                                                                                                                                                                                                        |
| max_sort_length                 | 1024                                                                                                                                                                                                              |
| max_user_connections            | 0                                                                                                                                                                                                                 |
| max_tmp_tables                  | 32                                                                                                                                                                                                                |
| max_write_lock_count            | 4294967295                                                                                                                                                                                                        |
| myisam_max_extra_sort_file_size | 268435456                                                                                                                                                                                                         |
| myisam_max_sort_file_size       | 2147483647                                                                                                                                                                                                        |
| myisam_repair_threads           | 1                                                                                                                                                                                                                 |
| myisam_recover_options          | OFF                                                                                                                                                                                                               |
| myisam_sort_buffer_size         | 67108864                                                                                                                                                                                                          |
| net_buffer_length               | 16384                                                                                                                                                                                                             |
| net_read_timeout                | 30                                                                                                                                                                                                                |
| net_retry_count                 | 10                                                                                                                                                                                                                |
| net_write_timeout               | 60                                                                                                                                                                                                                |
| new                             | OFF                                                                                                                                                                                                               |
| open_files_limit                | 1184                                                                                                                                                                                                              |
| pid_file                        | /data/c193.nskorea.com.pid                                                                                                                                                                                        |
| log_error                       |                                                                                                                                                                                                                   |
| port                            | 3306                                                                                                                                                                                                              |
| protocol_version                | 10                                                                                                                                                                                                                |
| query_alloc_block_size          | 8192                                                                                                                                                                                                              |
| query_cache_limit               | 1048576                                                                                                                                                                                                           |
| query_cache_size                | 33554432                                                                                                                                                                                                          |
| query_cache_type                | ON                                                                                                                                                                                                                |
| query_cache_wlock_invalidate    | OFF                                                                                                                                                                                                               |
| query_prealloc_size             | 8192                                                                                                                                                                                                              |
| range_alloc_block_size          | 2048                                                                                                                                                                                                              |
| read_buffer_size                | 2093056                                                                                                                                                                                                           |
| read_only                       | OFF                                                                                                                                                                                                               |
| read_rnd_buffer_size            | 262144                                                                                                                                                                                                            |
| rpl_recovery_rank               | 0                                                                                                                                                                                                                 |
| server_id                       | 1                                                                                                                                                                                                                 |
| slave_net_timeout               | 3600                                                                                                                                                                                                              |
| skip_external_locking           | ON                                                                                                                                                                                                                |
| skip_networking                 | OFF                                                                                                                                                                                                               |
| skip_show_database              | OFF                                                                                                                                                                                                               |
| slow_launch_time                | 2                                                                                                                                                                                                                 |
| socket                          | /tmp/mysql.sock                                                                                                                                                                                                   |
| sort_buffer_size                | 2097144                                                                                                                                                                                                           |
| sql_mode                        | 0                                                                                                                                                                                                                 |
| table_cache                     | 512                                                                                                                                                                                                               |
| table_type                      | MYISAM                                                                                                                                                                                                            |
| thread_cache_size               | 8                                                                                                                                                                                                                 |
| thread_stack                    | 126976                                                                                                                                                                                                            |
| tx_isolation                    | REPEATABLE-READ                                                                                                                                                                                                   |
| timezone                        | KST                                                                                                                                                                                                               |
| tmp_table_size                  | 33554432                                                                                                                                                                                                          |
| tmpdir                          | /tmp/                                                                                                                                                                                                             |
| transaction_alloc_block_size    | 8192                                                                                                                                                                                                              |
| transaction_prealloc_size       | 4096                                                                                                                                                                                                              |
| version                         | 4.0.25-standard                                                                                                                                                                                                   |
| version_comment                 | Official MySQL-standard binary                                                                                                                                                                                    |
| version_compile_os              | pc-linux-gnu                                                                                                                                                                                                      |
| wait_timeout                    | 80                                                                                                                                                                                                                |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

이럴 경우 어떻게 dump를 떠야 정상적으로 임포트를 할 수 있을까요?
한번 도와주십시오~~

이 글에 대한 댓글이 총 2건 있습니다.

덤프시 euckr로 덤프를 받으시면 괜찮을것 같슴다

반화넬(반씨아찌)님이 2007-10-01 17:03에 작성한 댓글입니다.

phpMyAdmin에서 euckr로 옵션을 줘서 덤프를 뜰 수 있나요?

잔뇌님이 2007-10-02 09:58에 작성한 댓글입니다. Edit Ｘ

[Top]

No.	제목	작성자	작성일	조회
27059	mysql 처음 접하는 사용자 입니다. 간단한 질문 몇가지.. [1]	김명진	2007-09-29	2372
27058	innodb 덤프후 임포트시.. 속도(3천만건) [3]	김대종	2007-09-29	3034
27057	엑세스 DB작성 과제인데, 너무 어려워요.. 도와주세요~~ [1]	히로짱	2007-09-29	1933
27056	phpMyAdmin에서 Export시에 한글깨짐 [2]	잔뇌	2007-09-28	5580
27055	[mysql]백업질문요 [1]	지우	2007-09-28	2906
27054	트래픽관련문의 [2]	꼬맹이	2007-09-27	1907
27052	log 파일을 다시 db에 넣을 수 있을까요? [1]	권혁주	2007-09-23	1991

작업시간: 0.021초, 이곳 서비스는
PostgreSQL v16.2로 자료를 관리합니다