1. 게시물 DB 정보 옮기기

insert into 'g4 게시판테이블' (
wr_id, wr_num, wr_reply, wr_parent, wr_comment, wr_subject, wr_content,
wr_link1, wr_link2, wr_link1_hit, wr_link2_hit, wr_hit, wr_good, wr_nogood,
mb_id, wr_password, wr_name, wr_email, wr_homepage, wr_datetime, wr_ip, wr_last,
wr_1, wr_2, wr_3, wr_4, wr_5
)
(
select
wr_id, wr_num, wr_reply, wr_parent_id, wr_comment, wr_subject, wr_content,
wr_link1, wr_link2, wr_link1_hit, wr_link2_hit, wr_hit, wr_good, wr_nogood,
mb_id, wr_passwd, wr_name, wr_email, wr_homepage, wr_datetime, wr_ip, wr_update_datetime,
wr_1, wr_2, wr_3, wr_4, wr_5
from 'g3 게시판테이블'

)

 

2. 첨부파일 DB정보 옮기기

insert into g4_board_file (
bo_table, wr_id, bf_no, bf_file, bf_source, bf_datetime
)
(
SELECT
'g4게시판의 bo_table', wr_id, '0', wr_file1, wr_file1_source, wr_datetime
from 'g3 게시판테이블'

)

 

insert into g4_board_file (
bo_table, wr_id, bf_no, bf_file, bf_source, bf_datetime
)
(
SELECT
'g4게시판의 bo_table', wr_id, '1', wr_file2, wr_file2_source, wr_datetime
from 'g3 게시판테이블'
)

 

3. bf_source 가 비어 있으면, 첨부파일 없으므로

delete from g4_board_file where bf_source = ''

 

4. data/file 폴더로 첨부된 파일들 복사하기

 

5. g4_board 에 bo_count_write 숫자 조정하기