|
PCCS MySQLDatabase Admin Tool version 1.3.4
|
/installscript/ -> backup.php
1 <?php
2 //** Generated by PCCS-MyAppGen 3 ///////////////////////////////////////////////////////////////////////////////////// 4 // coder: cthorn 5 //////////////////////////////////////////////////////////////////////////// 6 // 7 // 8 if ($argv[0] ==""):
9 print "<CENTER>";
10 print "This Page allows you to make a backup of your database App";
11 print "<br>";
12 print "<A HREF=backup.php?action=backup>BACKUP APPLICATION</A>";
13 print "</CENTER>";
14
15
16 endif;
17 $dbname = "eitsdb"; //your Application Database Name
18 $_time = date("His");
19 $_date = date("Ymd");
20 $dump_filename = "$_date$_time_$dbname.sql";
21 $_admtool = "/usr/local/bin/mysqldump";
22 $_gzip = "/bin/tar";
23 $dump_filename = "$_date$_time_$dbname.sql";
24 // 25 // Below are the paramaters for mysqldump 26 $par1 = '--opt';
27 $par2 = '-uroot';
28 $db_dump = "$_admtool $par1 $par2 $dbname > ./$dump_filename";
29 $gz_dump = "$_gzip -czf ./$dump_filename.tar.gz ./$dump_filename";
30
31 if ($action == "backup"):
32 header("Content-type: application/gzip");
33 header("Content-Disposition: attachment; filename=$dump_filename.tar.gz");
34
35 exec("$db_dump");
36 exec("$gz_dump");
37 readfile("$dump_filename.tar.gz");
38 unlink("$dump_filename.tar.gz");
39 endif;
40
41 // 42 ////////////////////////////////////////////////////////////////////////// 43 ?>
|