Use php to ZIP and export the backup database

In some open-source PHP systems, we often see Methods for backing up and exporting databases. In fact, the code is not complicated. The following describes the two methods, taking WINDOWS as an example, one is that the directory folder must have the permission to execute scripts, and each one has no permission. the code is as follows: 1) Java code 1. & lt ;?... SyntaxHighlighter. all ();

In some open-source PHP systems, we often see Methods for backing up and exporting databases. In fact, the code is not complex. below
Take WINDOWS as an example. There are two methods: One is that the directory folder must have the permission to execute scripts,
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 has no related 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 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.?>

 

From jackyrong