file:function.inc.php
Line 421 add:
// UTF8 support
$res=mysql_query("set CHARACTER SET utf8");
Line 447 modify:
// Remove view, avoid view export problem.
$res=mysql_query("show table status where Comment != 'VIEW'");
After
$out.="USE `".$db."`;\n";
add:
// Avoid constraints check problem
$out.="SET FOREIGN_KEY_CHECKS=0;\n";
$out.="SET AUTOCOMMIT=0;\n";
$out.="START TRANSACTION;";
Before
// an error occurred! Try to delete file and return error status
add:
// Avoid constraints check problem
$out .= "\nSET FOREIGN_KEY_CHECKS=1;\n";
$out .= "\nCOMMIT;\n";
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
file:function.inc.php
Line 421 add:
// UTF8 support
$res=mysql_query("set CHARACTER SET utf8");
Line 447 modify:
// Remove view, avoid view export problem.
$res=mysql_query("show table status where Comment != 'VIEW'");
After
$out.="USE `".$db."`;\n";
add:
// Avoid constraints check problem
$out.="SET FOREIGN_KEY_CHECKS=0;\n";
$out.="SET AUTOCOMMIT=0;\n";
$out.="START TRANSACTION;";
Before
// an error occurred! Try to delete file and return error status
add:
// Avoid constraints check problem
$out .= "\nSET FOREIGN_KEY_CHECKS=1;\n";
$out .= "\nCOMMIT;\n";
negative, no data in the exported sql file, what's wrong with it?