서버 이전시 mysql 4 to 5 password 함수 안맞아서 php 에러 날때

password 함수가 맞지않을때

 

my.cnf 혹은 html안에 common.php 수정

 

 @mysql_query('set old_passwords=0'); 

 

 

예)

$dirname = dirname(__FILE__).'/';

$dbconfig_file = "dbconfig.php";

if (file_exists("$g4[path]/$dbconfig_file"))

{

    if (is_dir("$g4[path]/install")) die("<meta http-equiv='content-type' content='text/html; charset=$g4[charset]'><script type='text/javascript'> alert('install ?~T?~I?좊

━瑜???젣?~X?ъ~U??~U?~A ?ㅽ~V~I?⑸~K~H??'); </script>");

    include_once("$g4[path]/$dbconfig_file");

    $connect_db = sql_connect($mysql_host, $mysql_user, $mysql_password);

    $select_db = sql_select_db($mysql_db, $connect_db);

        @mysql_query('set old_passwords=0');

    if (!$select_db)

        die("<meta http-equiv='content-type' content='text/html; charset=$g4[charset]'><script type='text/javascript'> alert('DB ?~Q?~M ?ㅻ쪟'); </script>");

}

else

{

    echo "<meta http-equiv='content-type' content='text/html; charset=$g4[charset]'>";

    echo <<<HEREDOC

    <script type="text/javascript">

    alert("DB ?ㅼ젙 ?~L?쇱~]?議댁~^ы~U~X吏~@ ?~J?듬~K~H??\\n\\n?~D濡~\洹몃~^??ㅼ튂 ?~D ?ㅽ~V~I?~X?~\湲?諛~T?~M?~H??");

    location.href = "./install/";

    </script>

HEREDOC;

    exit;

 

 

 

mysql db 관련 

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line

에러

 

 

 

MySQL 4.x는 TYPE=MyISAM

MySQL 5.x는 ENGINE=MyISAM 

 

해당 덤프 파일 vi로 열고

: $s/TYPE=MyISAM/ENGINE=MyISAM/g