php 导出mysql 结构_导出结构和数据(如phpmyadmin)

在这里,您可以找到一个全面的解决方案来转储MySQL结构和数据,比如在PMA中(不使用exec、passthru等):

它是Dszymczuk项目的一个分支,有我的增强功能。

用法很简单

//MySQL connection parameters

$dbhost = 'localhost';

$dbuser = 'dbuser';

$dbpsw = 'pass';

$dbname = 'dbname';

//Connects to mysql server

$connessione = @mysql_connect($dbhost,$dbuser,$dbpsw);

//Set encoding

mysql_query("SET CHARSET utf8");

mysql_query("SET NAMES 'utf8' COLLATE 'utf8_general_ci'");

//Includes class

require_once('FKMySQLDump.php');

//Creates a new instance of FKMySQLDump: it exports without compress and base-16 file

$dumper = new FKMySQLDump($dbname,'fk_dump.sql',false,false);

$params = array(

//'skip_structure' => TRUE,

//'skip_data' => TRUE,

);

//Make dump

$dumper->doFKDump($params);

?>

像魅力一样工作:—)