php备份整个MySQL数据库，或者指定表

php类实现完整备份数据库，或者备份数据库中指定表的功能：

1. class Backup
2. {
3. /**
4. * @var stores the options
5. */
6. var $config;
8. /**
9. * @var stores the final sql dump
10. */
11. var $dump;
13. /**
14. * @var stores the table structure + inserts for every table
15. */
16. var $struktur = array();
18. /**
19. * @var zip file name
20. */
21. var $datei;
23. /**
24. * this function is the constructor and phrase the options
25. * and connect to the database
26. * @return
27. */
28. public function Backup($options)
29. {
30. // write options
31. foreach($options AS $name => $value)
32. {
33. $this->config[$name] = $value;
34. }
36. // check mysql connection
37. mysql_connect($this->config['mysql'][0], $this->config['mysql'][1], $this->config['mysql'][2]) or die(mysql_error());
38. mysql_select_db($this->config['mysql'][3]) or die(mysql_error());
39. }
41. /**
42. * this function start the backup progress its the core function
43. * @return
44. */
45. public function backupDB()
46. {
47. // start backup
48. if(isset($_POST['backup']))
49. {
50. // check if tables are selected
51. if(empty($_POST['table']))
52. {
53. die("Please select a table.");
54. }
56. /** start backup **/
57. $tables = array();
58. $insert = array();
59. $sql_statement = '';
61. // lock tables
62. foreach($_POST['table'] AS $table)
63. {
64. mysql_query("LOCK TABLE $table WRITE");
66. // Read table structure
67. $res = mysql_query('SHOW CREATE TABLE '.$table.'');
68. $createtable = mysql_result($res, 0, 1);
69. $str = "\n\n".$createtable."\n\n";
71. array_push($tables, $str);
73. // Read table "inserts"
74. $sql = 'SELECT * FROM '.$table;
75. $query = mysql_query($sql) or die(mysql_error());
76. $feld_anzahl = mysql_num_fields($query);
78. $sql_statement = '--
79. -- Data Table `$table`
80. --
82. ';
84. // start reading progress
85. while($ds = mysql_fetch_object($query)){
86. $sql_statement .= 'INSERT INTO `'.$table.'` (';
88. for ($i = 0;$i <$feld_anzahl;$i++){
89. if ($i ==$feld_anzahl-1){
90. $sql_statement .= mysql_field_name($query,$i);
91. } else {
92. $sql_statement .= mysql_field_name($query,$i).', ';
93. }
94. }
96. $sql_statement .= ') VALUES (';
98. for ($i = 0;$i <$feld_anzahl;$i++){
99. $name = mysql_field_name($query,$i);
100. if (empty($ds->$name)){
101. $ds->$name = 'NULL';
102. }
103. if ($i ==$feld_anzahl-1){
104. $sql_statement .= '"'.$ds->$name.'"';
105. } else {
106. $sql_statement .= '"'.$ds->$name.'", ';
107. }
108. }
109. $sql_statement .= ");\n";
110. }
112. // insert "Inserts" into an array if not exists
113. if(!in_array($sql_statement, $insert))
114. {
115. array_push($insert, $sql_statement);
116. unset($sql_statement);
117. }
119. unset($sql_statement);
121. }
123. // put table structure and inserts together in one var
124. $this->struktur = array_combine($tables, $insert);
126. // create full dump
127. $this->createDUMP($this->struktur);
129. // create zip file
130. $this->createZIP();
132. /** end backup **/
134. // send an email with the sql dump
135. if(isset($this->config['email']) && !empty($this->config['email']))
136. {
137. $this->sendEmail();
138. }
140. // output
141. echo '

     Backup war erfolgreich

     datei.'">Download Backup
142. 
     
143. 
     ';
144. }
145. }
147. /**
148. * this function generate an email with attachment
149. * @return
150. */
151. protected function sendEmail()
152. {
153. // start sending emails
154. foreach($this->config['email'] AS $email)
155. {
156. $to = $email;
158. $from = $this->config['email'][0];
160. $message_body = "This email contains the database backup as a zip file.";
162. $msep = strtoupper (md5 (uniqid (time ())));
164. // set email header (only text)
165. $header =
166. "From: $from\r\n" .
167. "MIME-Version: 1.0\r\n" .
168. "Content-Type: multipart/mixed; boundary="$msep"\r\n\r\n" .
169. "--$msep\r\n" .
170. "Content-Type: text/plain\r\n" .
171. "Content-Transfer-Encoding: 8bit\r\n\r\n" .
172. $message_body . "\r\n";
174. // file name
175. $dateiname = $this->datei;
177. // get filesize of zip file
178. $dateigroesse = filesize ($dateiname);
180. // open file to read
181. $f = fopen ($dateiname, "r");
182. // save content
183. $attached_file = fread ($f, $dateigroesse);
184. // close file
185. fclose ($f);
187. // create attachment
188. $attachment = chunk_split (base64_encode ($attached_file));
190. // set attachment header
191. $header .=
192. "--" . $msep . "\r\n" .
193. "Content-Type: application/zip; name='Backup'\r\n" .
194. "Content-Transfer-Encoding: base64\r\n" .
195. "Content-Disposition: attachment; filename='Backup.zip'\r\n" .
196. "Content-Description: Mysql Datenbank Backup im Anhang\r\n\r\n" .
197. $attachment . "\r\n";
199. // mark end of attachment
200. $header .= "--$msep--";
202. // eMail Subject
203. $subject = "Database Backup";
205. // send email to emails^^
206. if(mail($to, $subject, '', $header) == FALSE)
207. {
208. die("The email could not be sent. Please check the email address.");
209. }
211. echo "

     Email was successfully sent.

     ";
212. }
213. }
215. /**
216. * this function create the zip file with the database dump and save it on the ftp server
217. * @return
218. */
219. protected function createZIP()
220. {
222. // Set permissions to 777
223. chmod($this->config['folder'], 0777);
225. // create zip file
226. $zip = new ZipArchive();
227. // Create file name
228. $this->datei = $this->config['folder'].$this->config['mysql'][3]."_".date("j_F_Y_g:i_a").".zip";
230. // Checking if file could be created
231. if ($zip->open($this->datei, ZIPARCHIVE::CREATE)!==TRUE) {
232. exit("cannot open <".$this->datei.">\n");
233. }
235. // add mysql dump to zip file
236. $zip->addFromString("dump.sql", $this->dump);
237. // close file
238. $zip->close();
240. // Check whether file has been created
241. if(!file_exists($this->datei))
242. {
243. die("The ZIP file could not be created.");
244. }
246. echo "

     The zip was created.

     ";
247. }
249. /**
250. * this function create the full sql dump
251. * @param object $dump
252. * @return
253. */
254. protected function createDUMP($dump)
255. {
256. $date = date("F j, Y, g:i a");
258. $header = <<-- SQL Dump
259. --
260. -- Host: {$_SERVER['HTTP_HOST']}
261. -- Erstellungszeit: {$date}
263. --
264. -- Datenbank: `{$this->config['mysql'][3]}`
265. --
267. -- --------------------------------------------------------
269. HEADER;
270. foreach($dump AS $name => $value)
271. {
272. $sql .= $name.$value;
273. }
274. $this->dump = $header.$sql;
275. }
277. /**
278. * this function displays the output form to select tables
279. * @return
280. */
281. public function outputForm()
282. {
283. // select all tables from database
284. $result = mysql_list_tables($this->config['mysql'][3]);
286. $buffer = '
287. Select some tables
     ';
289. echo $buffer;
290. }
291. }
292. ?>

2. //You can add as many email addresses as you like
3. $options = array('email' => array('email1', 'email2'),
4. 'folder' => './backup/',
5. 'mysql' => array('localhost', 'root', '****', 'database'));
7. $b = new Backup($options);
9. // if submit form start backup
10. if(isset($_POST['backup']))
11. {
12. // start backup
13. $b->backupDB();
14. }
16. // display tables
17. $b->outputForm();
19. ?>