Use PHP to implement backup database ZIP and export_PHP tutorial

In some PHP open source systems, we often see the method of backing up the database and exporting it. In fact, the code is not complicated, as follows
Let’s briefly explain, taking WINDOWS as an example, there are two methods. One is that the directory folder must have permission to execute scripts,
Each one has no permission, the code is as follows:

1)

Java code
1. 2. 
3. $username = "root";
4. $password = "";
5. $hostname = "localhost";
6. $dbname = "test";
7. 
8.
9. $dumpfname = $dbname . "_" . date("Y-m-d_H-i-s").".sql";
10. $command = "C:\xampp\mysql\bin\mysqldump --add-drop-table --host=$hostname
11. --user=$username ";
12. if ($password)
13. $ Command. = "-Password =". $ Password. "" ";
14. $command.= $dbname;
15. $command.= " > " . $dumpfname;
16. system($command);
17. 
18. // zip data file
19. $zipfname = $dbname . "_" . date("Y-m-d_H-i-s").".zip";
20. $zip = new ZipArchive();
21. if($zip->open($zipfname,ZIPARCHIVE::CREATE))
22. { 
23. $zip->addFile($dumpfname,$dumpfname);
24. $zip->close();
25. } 
26. 
27. // read zip file and send it to standard output
28. if (file_exists($zipfname)) {
29. header('Content-Description: File Transfer');
30. header('Content-Type: application/octet-stream');
31. header('Content-Disposition: attachment; filename='.basename($zipfname));
32. flush();
33. readfile($zipfname);
34. exit;
35. } 
36. ?>

Method 2: The folder does not have relevant permissions
Java code
1. 2. ob_start();
3. 
4. $username = "root";
5. $password = "";
6. $hostname = "localhost";
7. $dbname = "test";
8. 
9. $command = "C:\xampp\mysql\bin\mysqldump --add-drop-table --host=$hostname
10.        --user=$username ";                                        11. if ($password)
12. $ Command. = "-Password =". $ Password. "" ";
13. $command.= $dbname;
14. system($command);
15. 
16. $dump = ob_get_contents();
17. ob_end_clean();
18. 
19.
20. //No more ZIP
21. header('Content-Description: File Transfer');
22. header('Content-Type: application/octet-stream');
23. header('Content-Disposition: attachment; filename='.basename($dbname . "_" .  
24. date("Y-m-d_H-i-s").".sql"));
25. flush();
26. echo $dump;
27. exit();]]>
28. ?>

Excerpted from jackyrong

http://www.bkjia.com/PHPjc/478285.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/478285.htmlTechArticleIn some PHP open source systems, we often see methods of backing up the database and exporting it. In fact, the code is not complicated. Let’s briefly explain, taking WINDOWS as an example, there are two types of methods, one is the directory...