php数据库备份和恢复

1）在php.ini里把disable_functions = proc_open, popen, exec, system, shell_exec, passthru里的exec去掉。

 

 

2）$dbname="granarydb"; 

     $filename  = $_SERVER{'DOCUMENT_ROOT'}.'/DataBase/'.date("Ymd-His")."-".$dbname;

     $strcmd= "mysqldump   -hlocalhost   -uroot   -p111111   granarydb   >".$filename.".sql";

     exec($strcmd);

 

3）

 

   $filename = $_SERVER{'DOCUMENT_ROOT'}.'/DataBase/'.$_POST['filename'];

    $strcmd = "mysql -hlocalhost -uroot -p111111 granarydb  < ".$filename;

   exec($strcmd);

 

 

http://www.putdb.com/main?action=webbuilder/application/portal/portal.xwl