I am getting following error message whenever I am going to do run any DDL statement through PHP code or even through ‘phpMyAdmin’ service of MYSQL.
MySQL said: Error on rename of '.\WEBDICT\dict_common.MYI' to '.\WEBDICT#sql2-40c-ba.MYI' (Errcode: 13).
My code is as follows.
<?
error_reporting (E_ALL);
if(!$link = mysql_connect("localhost","",""))
{
echo("Error Connecting TO MYSQL Server !");
exit;
}
mysql_select_db("webdict", $link) or die ("can not connect to Database $db_name");
$language=strtoupper(trim($HTTP_POST_VARS['language']));
mysql_db_query("webdict","ALTER TABLE dict_common ADD $language VARCHAR(255) ");
echo mysql_errno().": ".mysql_error()."<BR>";
mysql_db_query("WEBDICT", "ALTER TABLE dict_common ADD INDEX ($language)");
mysql_close($link);
?>
<HTML>
<body>
<script language=javascript>
window.location="./language_brow.php";
</script>
</body>
</HTML>
please help me.