紀老師您好:
剛從二林研習完2010SFS主機安裝,學校又添購一台新主機,想趁此將資料移轉過去,只是試了很久,都無法順利轉移,不知那一環節出了錯誤,煩請紀老師解答...
學校目前建置情形如下:
學校公佈欄網址
http://163.23.100.124/sfs3/modules/board/
是古董級的mandrake 10.0(因為好久以前都無法轉移,就不裡它)
記得Mysql是Big5的編碼(版本好像是4.x版)
用過研習資料的方法
mysqldump ...
mysqladmin ...
mysql ...
還是無法正確轉移資料
/etc/my.cnf 一些的設定如下：
mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = key_buffer=256M
set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=1M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=8
set-variable = max_connection=10000
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
log-bin
server-id = 1
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=64M
#set-variable = bdb_max_lock=100000
# Uncomment the following if you are using Innobase tables
#innodb_data_file_path = ibdata1:1000M
#innodb_data_home_dir = /var/lib/mysql/
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50
# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
#default-character-set = big5
collation_server = big5_chinese_ci
#character_set_server = big5
init_connect='SET NAMES big5'
default-character-set = big5
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
default-character-set = big5
請問要如何才能正確轉移資料呢?
彰化縣永興國小資訊組
