1. root/webadmin 유저등록/패스워드 설정
update user set password=password('패스워드') where user='root' ;
insert into user (host,user,password) values('localhost','webadmin',password('패스워드'));
insert into db values('localhost','search','root','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y');
insert into db values('localhost','search','webadmin','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y');
flush privileges;
mysqladmin -u root -p reload
key_buffer_size = 200M (5%) <---- kcm.kr 에 적용
query_cache_size= 200M (5%)
2. mysqldump 원격백업하기
mysql> grant all privileges on *.* to root@'접속허용할ip' identified by '접속허용할db패스워드';
mysqldump -h접속할IP -u root -p search
gy_taja_admins gy_taja_bible gy_taja_churchs gy_taja_comments gy_taja_documents gy_taja_faq gy_taja_files gy_taja_members gy_taja_my_recite gy_taja_my_upload gy_taja_parking gy_taja_phrase gy_taja_recite gy_taja_recite_stat_month gy_taja_slide_banner gy_taja_stat_day gy_taja_stat_month gy_taja_tags gy_taja_theme > gy_taja.sql
mysqldump -h접속할IP -u root -p search
nidr_board_ad01 nidr_board_building nidr_board_festival nidr_board_free nidr_board_job nidr_board_market nidr_board_musicbook nidr_board_notice nidr_board_picture nidr_board_qt nidr_board_speaker nidr_board_taja nidr_board_worldinfo nidr_board_yehwa nidr_board_yumer nidrboard_admin nidrboard_banner nidrboard_cate nidrboard_center > nidr.sql
mysqldump -h접속할IP -u root -p search
LINKER_BAN LINKER_BAN1 LINKER_BANWORD LINKER_CAT LINKER_COM LINKER_LINK LINKER_MAIL LINKER_ONEADD LINKER_WAIT LINKER_WAIT2 LINKER_WORD > linker.sql
mysqldump -h접속할IP -u root -p search
bible_comedit bible_comment bible_theme chad_address dic_edit dic_idup dic_index dic_temp dic_data doc_open doc_temp doc_data extra_data extra_tesy > bible.sql
mysqldump -h접속할IP -u root -p search
history icon_image kword_input mio_data mio_temp newzip pay_result req_kword text_msg user_img user_info user_point > user.sql
mysql -u root -p search < gy_taja.sql
mysql -u root -p search < nidr.sql
mysql -u root -p search < linker.sql
mysql -u root -p search < bible.sql
mysql -u root -p search < user.sql
3. 백업에러 테이블 (binary 복구)
mysqldump -u root -p search LINKER_TWORD > LINKER_TWORD.sql
mysqldump -u root -p search bible_data > bible_data.sql
mysql -u root -p search < LINKER_TWORD.sql
ERROR 1062 (23000) at line 32: Duplicate entry '' for key 2
mysql -u root -p search < bible_data.sql
ERROR 1060 (42S21) at line 18: Duplicate column name 'part1'
4. inodb 테이블
gy_taja_comments.frm gy_taja_documents.frm gy_taja_faq.frm
mysqldump_복구.txt