g4 -> g5 이전 시 php로 데이터를 넘기는 방법(?)

g5 이전 하는데 아무리 해도 데이터가 넘어가지도 않고.. 넘어가도 여분필드 10개 이상 되는것도 많아서

그냥 g5 설치하고 g5에서 a링크 걸어서 g4 db 그냥 끌어온거 여기다 남깁니다.

테이블 하나씩 지정해서 넘겨야 합니다..  여분필드도 컬럼 계산해서 할려고 했는데 이것저것 안되거

투성이라서 그냥 걍 단순하게 처리했습니다... 여분필드 10개 이상인 분들은 더 추가해서 사용하세요

도움이 될 지는 모르겠네요...

아래 소스 입니다.

<?php
 include_once("../../../common.php"); // include_once("../../../_common.php"); 이게 왜 안되는지 모르겠음..
 
     $dbc = mysql_connect('g4 서버 ip:3306', 'g4', 'db비밀번호')
         or die("안됨" );
         mysql_query('set names euckr');  
         mysql_select_db('g4',$dbc);
 
  $sql ="select * from g4_write_데꾸올녀석 테이블명 ";
     $result = mysql_query($sql);
 
      for ($i=0; $row=mysql_fetch_array($result); $i++) {
    
     
  // euc-kr utf-8 변경
  
               $row[wr_id] = iconv("euc-kr", "UTF-8", $row[wr_id]);
         $row[wr_num] = iconv("euc-kr", "UTF-8", $row[wr_num]);
                     $row[wr_reply] = iconv("euc-kr", "UTF-8", $row[wr_reply]);
      $row[wr_parent] = iconv("euc-kr", "UTF-8", $row[wr_parent]);
      $row[wr_is_comment] = iconv("euc-kr", "UTF-8", $row[wr_is_comment]);
      $row[wr_comment] = iconv("euc-kr", "UTF-8", $row[wr_comment]);
      $row[wr_comment_reply] = iconv("euc-kr", "UTF-8", $row[wr_comment_reply]);
       $row[ca_name] = iconv("euc-kr", "UTF-8", $row['ca_name']);
        
                     $row[wr_option]= iconv("euc-kr", "UTF-8", $row[wr_option]);
                     $row[wr_subject] = iconv("euc-kr", "UTF-8", $row[wr_subject]);
                     $row[wr_content] = iconv("euc-kr", "UTF-8", $row[wr_content]);
                     $row[wr_link1] = iconv("euc-kr", "UTF-8", $row[wr_link1]);
                     $row[wr_link2] = iconv("euc-kr", "UTF-8", $row[wr_link2]);
                     $row[wr_link1_hit] = iconv("euc-kr", "UTF-8", $row[wr_link1_hit]);
                     $row[wr_link2_hit] = iconv("euc-kr", "UTF-8", $row[wr_link2_hit]);
                     $row[wr_hit] = iconv("euc-kr", "UTF-8", $row[wr_hit]);
                   //  $row[wr_good] = "";
                   //  $row[wr_nogood] = "";
                     $row[mb_id] = iconv("euc-kr", "UTF-8", $row[mb_id]);
                     $row[wr_password] = iconv("euc-kr", "UTF-8", $row[wr_password]);
                     $row[wr_name] = iconv("euc-kr", "UTF-8", $row[wr_name]);
                     $row[wr_email] = iconv("euc-kr", "UTF-8", $row[wr_email]);
                     $row[wr_homepage] = iconv("euc-kr", "UTF-8", $row[wr_homepage]);
                     $row[wr_datetime] = iconv("euc-kr", "UTF-8", $row[wr_datetime]);
                     $row[wr_file] = "";
      $row[wr_last] = iconv("euc-kr", "UTF-8", $row[wr_last]);
                     $row[wr_ip] = iconv("euc-kr", "UTF-8", $row[wr_ip]);
     // $row[wr_facebook_user] = "";
    //  $row[wr_twitter_user] = "";
                     $row[wr_1] = iconv("euc-kr", "UTF-8", $row[wr_1]);
                     $row[wr_2] = iconv("euc-kr", "UTF-8", $row[wr_2]);
                     $row[wr_3] = iconv("euc-kr", "UTF-8", $row[wr_3]);
                     $row[wr_4] = iconv("euc-kr", "UTF-8", $row[wr_4]);
                     $row[wr_5] = iconv("euc-kr", "UTF-8", $row[wr_5]);
                     $row[wr_6] = iconv("euc-kr", "UTF-8", $row[wr_6]);
                     $row[wr_7] = iconv("euc-kr", "UTF-8", $row[wr_7]);
                     $row[wr_8] = iconv("euc-kr", "UTF-8", $row[wr_8]);
                     $row[wr_9] = iconv("euc-kr", "UTF-8", $row[wr_9]);
                     $row[wr_10] = iconv("euc-kr", "UTF-8", $row[wr_10]);
      
    //글 입력하기
 $new_sql = "insert into g5_write_새로입력할테이블명
                set  wr_id =            '$row[wr_id]',
         wr_num =           '$row[wr_num]',
                     wr_reply =         '$row[wr_reply]',
      wr_parent =        '$row[wr_parent]',
      wr_is_comment =    '$row[wr_is_comment]',
      wr_comment =       '$row[wr_comment]',
      wr_comment_reply = '$row[wr_comment_reply]',
      ca_name =          '$row[ca_name]',
                     wr_option =        '$row[wr_option]',
                     wr_subject =       '$row[wr_subject]',
                     wr_content =       '$row[wr_content]',
                     wr_link1 =         '$row[wr_link1]',
                     wr_link2 =         '$row[wr_link2]',
                     wr_link1_hit =     '$row[wr_link1_hit]',
                     wr_link2_hit = '    $row[wr_link2_hit]',
                     wr_hit =           '$row[wr_hit]',
                     wr_good =          '$row[wr_good]',
                     wr_nogood =        '$row[wr_nogood]',
                     mb_id =            '$row[mb_id]',
                     wr_password =      '$row[wr_password]',
                     wr_name =          '$row[wr_name]',
                     wr_email =         '$row[wr_email]',
                     wr_homepage =      '$row[wr_homepage]',
                     wr_datetime =      '$row[wr_datetime]',
                     wr_file =          '$row[wr_file]',
      wr_last =          '$row[wr_last]',
                     wr_ip =            '$row[wr_ip]',
      wr_facebook_user = '$row[wr_facebook_user]',
      wr_twitter_user =  '$row[wr_twitter_user]',
                     wr_1 =             '$row[wr_1]',
                     wr_2 =             '$row[wr_2]',
                     wr_3 =             '$row[wr_3]',
                     wr_4 =             '$row[wr_4]',
                     wr_5 =             '$row[wr_5]',
                     wr_6 =             '$row[wr_6]',
                     wr_7 =             '$row[wr_7]',
                     wr_8 =             '$row[wr_8]',
                     wr_9 =             '$row[wr_9]',
                     wr_10 =            '$row[wr_10]'  ";

               //mysql_query($new_sql,$dbc) or die( mysql_error($dbc) );
                sql_query($new_sql);
  
                   }
  //echo $i."번째 줄 저장 된거 같은데????</br>";     
       //  mysql_close($dbc);      
?>

<script language='JavaScript'>

 alert("이동완료");

self.close() ;

</script>