WP-DB-Backup - Version 1.3

Version Description

Release Info

Developer	skippy
Plugin	WP-DB-Backup
Version	1.3
Comparing to
See all releases

Version 1.3

Files changed (2) hide show

wp-db-backup.php +487 -0
wp-db-backup.txt +86 -0

wp-db-backup.php ADDED Viewed

	@@ -0,0 +1,487 @@


1	+ <?php
2	+ /*
3	+ Plugin Name: WordPress Database Backup
4	+ Plugin URI: http://www.skippy.net/plugins/
5	+ Description: On-demand backup of your WordPress database.
6	+ Author: Scott Merrill
7	+ Version: 1.3
8	+ Author URI: http://www.skippy.net/
9	+
10	+ Much of this was modified from Mark Ghosh's One Click Backup, which
11	+ in turn was derived from phpMyAdmin.
12	+
13	+ */
14	+
15	+ add_action('admin_menu', 'add_wp_backup_menu');
16	+ add_action('wp_cron_daily', 'wp_cron_db_backup');
17	+ global $wp_backup_dir, $wp_backup_error;
18	+ $wp_backup_error = '';
19	+ $wp_backup_dir = 'wp-content/backup/';
20	+
21	+ // this needs to live outside of any function so that the
22	+ // download can be sent to the browser
23	+ if (isset($_GET['backup'])) {
24	+ wp_deliver_backup ($_GET['backup'], 'http');
25	+ die();
26	+ }
27	+ if ( (isset($_POST['do_backup'])) && ('backup' == $_POST['do_backup']) ) {
28	+ // should we compress the output?
29	+ if ('gzip' == $_POST['gzip']) {
30	+ $gzip = TRUE;
31	+ } else {
32	+ $gzip = FALSE;
33	+ }
34	+ // are we backing up any other tables?
35	+ $also_backup = array();
36	+ if (isset($_POST['other_tables'])) {
37	+ $also_backup = $_POST['other_tables'];
38	+ }
39	+ $core_tables = $_POST['core_tables'];
40	+ $backup_file = wp_db_backup($gzip, $core_tables, $also_backup);
41	+ if (FALSE !== $backup_file) {
42	+ if ('smtp' == $_POST['deliver']) {
43	+ wp_deliver_backup ($backup_file, $_POST['deliver'], $_POST['backup_recipient']);
44	+ } elseif ('http' == $_POST['deliver']) {
45	+ header('Refresh: 3; ' . get_settings('siteurl') . "/wp-admin/edit.php?page=wp-db-backup.php&backup=$backup_file");
46	+ }
47	+ // we do this to say we're done.
48	+ $_POST['do_backup'] = 'DONE';
49	+ // and we do this to pass the filename, and avoid a global
50	+ $_POST['gzip'] = $backup_file;
51	+ }
52	+ }
53	+
54	+ ///////////////////////////////
55	+ function add_wp_backup_menu() {
56	+ add_management_page('Backup', 'Backup', 9, __FILE__, 'wp_backup_menu');
57	+ }
58	+
59	+ /////////////////////////////////////////////////////////
60	+ function sql_addslashes($a_string = '', $is_like = FALSE)
61	+ {
62	+ /*
63	+ Better addslashes for SQL queries.
64	+ Taken from phpMyAdmin.
65	+ */
66	+ if ($is_like) {
67	+ $a_string = str_replace('\\', '\\\\\\\\', $a_string);
68	+ } else {
69	+ $a_string = str_replace('\\', '\\\\', $a_string);
70	+ }
71	+ $a_string = str_replace('\'', '\\\'', $a_string);
72	+
73	+ return $a_string;
74	+ } // function sql_addslashes($a_string = '', $is_like = FALSE)
75	+
76	+ ///////////////////////////////////////////////////////////
77	+ function backquote($a_name)
78	+ {
79	+ /*
80	+ Add backqouotes to tables and db-names in
81	+ SQL queries. Taken from phpMyAdmin.
82	+ */
83	+ if (!empty($a_name) && $a_name != '*') {
84	+ if (is_array($a_name)) {
85	+ $result = array();
86	+ reset($a_name);
87	+ while(list($key, $val) = each($a_name)) {
88	+ $result[$key] = '`' . $val . '`';
89	+ }
90	+ return $result;
91	+ } else {
92	+ return '`' . $a_name . '`';
93	+ }
94	+ } else {
95	+ return $a_name;
96	+ }
97	+ } // function backquote($a_name, $do_it = TRUE)
98	+
99	+ /////////////////////////////
100	+ function backup_table($table) {
101	+ global $wp_backup_error, $wpdb;
102	+
103	+ /*
104	+ Taken partially from phpMyAdmin and partially from
105	+ Alain Wolf, Zurich - Switzerland
106	+ Website: http://restkultur.ch/personal/wolf/scripts/db_backup/
107	+
108	+ Modified by Scott Merril (http://www.skippy.net/)
109	+ to use the WordPress $wpdb object
110	+ */
111	+
112	+ $sql_statements = '';
113	+
114	+ //
115	+ // Add SQL statement to drop existing table
116	+ $sql_statements .= "\n";
117	+ $sql_statements .= "\n";
118	+ $sql_statements .= "#\n";
119	+ $sql_statements .= "# Delete any existing table " . backquote($table) . "\n";
120	+ $sql_statements .= "#\n";
121	+ $sql_statements .= "\n";
122	+ $sql_statements .= "DROP TABLE IF EXISTS " . backquote($table) . ";\n";
123	+
124	+ //
125	+ //Table structure
126	+ // Comment in SQL-file
127	+ $sql_statements .= "\n";
128	+ $sql_statements .= "\n";
129	+ $sql_statements .= "#\n";
130	+ $sql_statements .= "# Table structure of table " . backquote($table) . "\n";
131	+ $sql_statements .= "#\n";
132	+ $sql_statements .= "\n";
133	+
134	+ $create_table = $wpdb->get_results("SHOW CREATE TABLE $table", ARRAY_N);
135	+ if (FALSE === $create_table) {
136	+ $wp_backup_error .= "Error with SHOW CREATE TABLE for $table.\r\n";
137	+ return "#\n# Error with SHOW CREATE TABLE for $table!\n#\n";
138	+ }
139	+ $sql_statements .= $create_table[0][1] . ' ;';
140	+
141	+ $table_structure = $wpdb->get_results("DESCRIBE $table");
142	+ if (FALSE === $table_structure) {
143	+ $wp_backup_error .= "Error getting table structure of $table\r\n";
144	+ return "#\n# Error getting table structure of $table!\n#\n";
145	+ }
146	+
147	+ $table_data = $wpdb->get_results("SELECT * FROM $table", ARRAY_A);
148	+ if (FALSE === $table_data) {
149	+ $wp_backup_error .= "Error getting table contents from $table\r\n";
150	+ return "#\n# Error getting table contents fom $table!\n#\n";
151	+ }
152	+
153	+ //
154	+ // Comment in SQL-file
155	+ $sql_statements .= "\n";
156	+ $sql_statements .= "\n";
157	+ $sql_statements .= "#\n";
158	+ $sql_statements .= '# Data contents of table ' . backquote($table) . "\n";
159	+ $sql_statements .= "#\n";
160	+
161	+ $ints = array();
162	+ foreach ($table_structure as $struct) {
163	+ if ( (0 === strpos($struct->Type, 'tinyint')) \|\|
164	+ (0 === strpos(strtolower($struct->Type), 'smallint')) \|\|
165	+ (0 === strpos(strtolower($struct->Type), 'mediumint')) \|\|
166	+ (0 === strpos(strtolower($struct->Type), 'int')) \|\|
167	+ (0 === strpos(strtolower($struct->Type), 'bigint')) \|\|
168	+ (0 === strpos(strtolower($struct->Type), 'timestamp')) ) {
169	+ $ints[strtolower($struct->Field)] = "1";
170	+ }
171	+ }
172	+
173	+ $entries = 'INSERT INTO ' . backquote($table) . ' VALUES (';
174	+ // \x08\\x09, not required
175	+ $search = array("\x00", "\x0a", "\x0d", "\x1a");
176	+ $replace = array('\0', '\n', '\r', '\Z');
177	+ foreach ($table_data as $row) {
178	+ $values = array();
179	+ foreach ($row as $key => $value) {
180	+ if ($ints[strtolower($key)]) {
181	+ $values[] = $value;
182	+ } else {
183	+ $values[] = "'" . str_replace($search, $replace, sql_addslashes($value)) . "'";
184	+ }
185	+ }
186	+ $sql_statements .= " \n" . $entries . implode(', ', $values) . ') ;';
187	+ }
188	+ // Create footer/closing comment in SQL-file
189	+ $sql_statements .= "\n";
190	+ $sql_statements .= "#\n";
191	+ $sql_statements .= "# End of data contents of table " . backquote($table) . "\n";
192	+ $sql_statements .= "# --------------------------------------------------------\n";
193	+ $sql_statements .= "\n";
194	+
195	+ return $sql_statements;
196	+
197	+ } // end backup_table()
198	+
199	+ ////////////////////////////
200	+ function wp_db_backup($gzip = FALSE, $core_tables, $other_tables) {
201	+
202	+ global $wp_backup_dir, $wp_backup_error, $table_prefix, $wpdb;
203	+
204	+ $done = array();
205	+
206	+ $datum = date("Ymd_B");
207	+ $wp_backup_filename = DB_NAME . "_$table_prefix$datum.sql";
208	+ if ($gzip) {
209	+ $wp_backup_filename .= '.gz';
210	+ }
211	+
212	+ //Begin new backup of MySql
213	+ $sql = "# WordPress MySQL database backup\n";
214	+ $sql .= "#\n";
215	+ $sql .= "# Generated: " . date("l j. F Y H:i T") . "\n";
216	+ $sql .= "# Hostname: " . DB_HOST . "\n";
217	+ $sql .= "# Database: " . backquote(DB_NAME) . "\n";
218	+ $sql .= "# --------------------------------------------------------\n";
219	+
220	+ foreach ($core_tables as $table) {
221	+ if (in_array($table, $done)) { continue; }
222	+ // Increase script execution time-limit to 15 min for every table.
223	+ if ( !ini_get('safe_mode')) @set_time_limit(15*60);
224	+ //ini_set('memory_limit', '16M');
225	+ // Create the SQL statements
226	+ $tbl = "# --------------------------------------------------------\n";
227	+ $tbl .= "# Table: " . backquote($table) . "\n";
228	+ $tbl .= "# --------------------------------------------------------\n";
229	+ $tbl .= backup_table($table);
230	+ $sql .= $tbl;
231	+ $done[] = $table;
232	+ }
233	+
234	+ if (count($other_tables) > 0) {
235	+ foreach ($other_tables as $other_table) {
236	+ if (in_array($other_table, $done)) { continue; }
237	+ // Increase script execution time-limit to 15 min for every table.
238	+ if ( !ini_get('safe_mode')) @set_time_limit(15*60);
239	+ //ini_set('memory_limit', '16M');
240	+ // Create the SQL statements
241	+ $tbl = "# --------------------------------------------------------\n";
242	+ $tbl .= "# Table: " . backquote($other_table) . "\n";
243	+ $tbl .= "# --------------------------------------------------------\n";
244	+ $tbl .= backup_table($other_table);
245	+ $sql .= $tbl;
246	+ $done[] = $other_table;
247	+ } // foreach
248	+ } // if other_tables...
249	+
250	+ if (is_writable(ABSPATH . $wp_backup_dir)) {
251	+ if ($gzip) {
252	+ $sql = gzencode($sql);
253	+ }
254	+ $cachefp = fopen(ABSPATH . $wp_backup_dir . $wp_backup_filename, "w");
255	+ fwrite($cachefp, $sql);
256	+ fclose($cachefp);
257	+ }
258	+
259	+ if ('' == $wp_backup_error) {
260	+ return $wp_backup_filename;
261	+ } else {
262	+ return FALSE;
263	+ }
264	+
265	+ } //wp_db_backup
266	+
267	+ ///////////////////////////
268	+ function wp_deliver_backup ($filename = '', $delivery = 'http', $recipient = '') {
269	+ global $wp_backup_dir;
270	+
271	+ if ('' == $filename) { return FALSE; }
272	+
273	+ $diskfile = ABSPATH . $wp_backup_dir . $filename;
274	+ if ('http' == $delivery) {
275	+ header('Content-Description: File Transfer');
276	+ header('Content-Type: application/octet-stream');
277	+ header('Content-Length: ' . filesize($diskfile));
278	+ header("Content-Disposition: attachment; filename=$filename");
279	+ readfile($diskfile);
280	+ unlink($diskfile);
281	+ } elseif ('smtp' == $delivery) {
282	+ if (! is_email ($recipient)) {
283	+ $recipient = get_settings('admin_email');
284	+ }
285	+ $randomish = md5(time());
286	+ $boundary = "==WPBACKUP-BY-SKIPPY-$randomish";
287	+ $fp = fopen($diskfile,"rb");
288	+ $file = fread($fp,filesize($diskfile));
289	+ fclose($fp);
290	+ $data = chunk_split(base64_encode($file));
291	+ $headers = "MIME-Version: 1.0\n";
292	+ $headers .= "Content-Type: multipart/mixed; boundary=\"$boundary\"\n";
293	+ $headers .= 'From: ' . get_settings('admin_email') . "\n";
294	+
295	+ $message = __('Attached to this email is', 'wp_backup') . "\n $filename\n". __('Size', 'wp_backup') . ": " . round(filesize($diskfile)/1024) . ' ' . __('kilobytes', 'wp_backup') . "\n";
296	+ // Add a multipart boundary above the plain message
297	+ $message = "This is a multi-part message in MIME format.\n\n" .
298	+ "--{$boundary}\n" .
299	+ "Content-Type: text/plain; charset=\"iso-8859-1\"\n" .
300	+ "Content-Transfer-Encoding: 7bit\n\n" .
301	+ $message . "\n\n";
302	+
303	+ // Add file attachment to the message
304	+ $message .= "--{$boundary}\n" .
305	+ "Content-Type: application/octet-stream;\n" .
306	+ " name=\"{$filename}\"\n" .
307	+ "Content-Disposition: attachment;\n" .
308	+ " filename=\"{$filename}\"\n" .
309	+ "Content-Transfer-Encoding: base64\n\n" .
310	+ $data . "\n\n" .
311	+ "--{$boundary}--\n";
312	+
313	+ mail ($recipient, get_bloginfo('name') . ' ' . __('Database Backup', 'wp_backup'), $message, $headers);
314	+
315	+ unlink($diskfile);
316	+ }
317	+ return;
318	+ }
319	+
320	+ ////////////////////////////
321	+ function wp_backup_menu() {
322	+ global $wp_backup_dir, $wp_backup_error, $table_prefix, $wpdb;
323	+ $feedback = '';
324	+ $gzip = FALSE;
325	+ $WHOOPS = FALSE;
326	+
327	+ // first, did we just do a backup? If so, let's report the status
328	+ if ( (isset($_POST['do_backup'])) && ('DONE' == $_POST['do_backup']) ) {
329	+ $feedback = '<div class="updated"><p>' . __('Backup Successful', 'wp_backup') . '!';
330	+ // we stuff the filename into gzip to avoid another global
331	+ $file = $_POST['gzip'];
332	+ if ('http' == $_POST['deliver']) {
333	+ $feedback .= '<br />' . __('Your backup file', 'wp_backup') . ': <a href="' . get_settings('siteurl') . "/$wp_backup_dir$file\">$file</a> " . __('should begin downloading shortly.', 'wp_backup');
334	+ } elseif ('smtp' == $_POST['deliver']) {
335	+ $feedback .= '<br />' . __('Your backup has been emailed to ', 'wp_backup');
336	+ if (! is_email($_POST['backup_recipient'])) {
337	+ $feedback .= get_settings('admin_email');
338	+ } else {
339	+ $feedback .= $_POST['backup_recipient'];
340	+ }
341	+ } elseif ('none' == $_POST['deliver']) {
342	+ $feedback .= '<br />' . __('Your backup file', 'wp_backup') . ' ' . __('is ready for download; right click and select "Save As"', 'wp_backup') . ':<br /> <a href="' . get_settings('siteurl') . "/$wp_backup_dir$file\">$file</a> : " . filesize(ABSPATH . $wp_backup_dir . $file) . __(' bytes', 'wp_backup');
343	+ }
344	+ $feedback .= '</p></div>';
345	+ } elseif ('' != $wp_backup_error) {
346	+ $feedback = '<div class="updated">' . __('The following errors were reported', 'wp_backup') . ":<br /><pre>$wp_backup_error</pre></div>";
347	+ }
348	+
349	+ // did we just save options for wp-cron?
350	+ if ( (function_exists('wp_cron_db_backup')) && isset($_POST['wp_cron_backup_options']) ) {
351	+ update_option('wp_cron_backup_schedule', intval($_POST['cron_schedule']), FALSE);
352	+ if (is_email($_POST['cron_backup_recipient'])) {
353	+ update_option('wp_cron_backup_recipient', $_POST['cron_backup_recipient'], FALSE);
354	+ }
355	+ $feedback .= '<div class="updated"><p>' . __('Scheduled Backup Options Saved!', 'wp_backup') . '</p></div>';
356	+ }
357	+
358	+ $gzip = FALSE;
359	+ $wp_backup_default_tables = array ($table_prefix . categories,
360	+ $table_prefix . comments,
361	+ $table_prefix . linkcategories,
362	+ $table_prefix . links,
363	+ $table_prefix . options,
364	+ $table_prefix . post2cat,
365	+ $table_prefix . postmeta,
366	+ $table_prefix . posts,
367	+ $table_prefix . users);
368	+
369	+ $other_tables = array();
370	+ $also_backup = array();
371	+
372	+ // let's get other tables in this database
373	+ $all_tables = $wpdb->get_results("SHOW TABLES", ARRAY_N);
374	+ foreach ($all_tables as $table) {
375	+ if (! in_array($table[0], $wp_backup_default_tables)) {
376	+ $other_tables[] = $table[0];
377	+ }
378	+ }
379	+
380	+ if ('' != $feedback) {
381	+ echo $feedback;
382	+ }
383	+
384	+ if (! is_writable(ABSPATH . $wp_backup_dir)) {
385	+ echo '<div class="updated"><p align="center">' . __('WARNING: Your backup directory is <strong>NOT</strong> writable!</strong>', 'wp_backup') . '<br />' . ABSPATH . "$wp_backup_dir</p></div>";
386	+ $WHOOPS = TRUE;
387	+ }
388	+ echo "<div class='wrap'>";
389	+ echo '<h2>' . __('Backup', 'wp_backup') . '</h2>';
390	+ echo '<fieldset class="options"><legend>' . __('Tables', 'wp_backup') . '</legend>';
391	+ echo '<form method="post">';
392	+ echo '<table align="center" cellspacing="5" cellpadding="5"><tr><td width="50%" align="left" class="alternate">';
393	+ echo __('These core WordPress tables will always be backed up', 'wp_backup') . ': <br /><ul>';
394	+ foreach ($wp_backup_default_tables as $table) {
395	+ echo "<input type='hidden' name='core_tables[]' value='$table' /><li>$table</li>";
396	+ }
397	+ echo '</ul></td><td width="50%" align="left">';
398	+ if (count($other_tables) > 0) {
399	+ echo __('You may choose to include any of the following tables', 'wp_backup') . ': <br />';
400	+ foreach ($other_tables as $table) {
401	+ echo "<input type='checkbox' name='other_tables[]' value='$table' />$table<br />";
402	+ }
403	+ }
404	+ echo '</tr></table></fieldset>';
405	+ echo '<fieldset class="options"><legend>' . __('Backup Options', 'wp_backup') . '</legend><table width="100%" align="center" cellpadding="5" cellspacing="5">';
406	+ echo '<tr><td align="center">';
407	+ echo __('Deliver backup file by', 'wp_backup') . ":<br />";
408	+ echo '<input type="radio" name="deliver" value="none" /> ' . __('None', 'wp_backup') . '   &nbsp     <br />';
409	+ echo '<input type="radio" name="deliver" value="smtp" /> ' . __('Email', 'wp_backup') . '        <br />';
410	+ echo '<input type="radio" name="deliver" value="http" /> ' . __('Download', 'wp_backup');
411	+ echo '</td><td align="left">' . __('Email backup to', 'wp_backup') . ':<br /> <input type="text" name="backup_recipient" size="20" value="' . get_settings('admin_email') . '" /></td></tr>';
412	+ echo '<tr class="alternate"><td colspan="2" align="center">';
413	+ if (! $WHOOPS) {
414	+ echo __('Use gzip compression', 'wp_backup') . '? <input type="checkbox" name="gzip" value="gzip" /><br />';
415	+ echo '<input type="hidden" name="do_backup" value="backup" />';
416	+ echo '<input type="submit" name="submit" value="' . __('Backup', 'wp_backup') . '!" / >';
417	+ } else {
418	+ echo __('WARNING: Your backup directory is <strong>NOT</strong> writable!</strong>', 'wp_backup');
419	+ }
420	+ echo '</td></tr></form></table>';
421	+ echo '</fieldset>';
422	+
423	+ // this stuff only displays if wp_cron is installed
424	+ if (function_exists('wp_cron_db_backup')) {
425	+ echo '<fieldset class="options"><legend>' . __('Scheduled', 'wp_backup') . ' ' . __('Backup', 'wp_backup') . '</legend>';
426	+ echo '<p>' . __('Last WP-Cron Daily Execution', 'wp_backup') . ': ' . date('Y-m-d @ h:i', get_option('wp_cron_daily_lastrun')) . '<br />';
427	+ echo __('Next WP-Cron Daily Execution', 'wp_backup') . ': ' . date('Y-m-d @ h:i', (get_option('wp_cron_daily_lastrun') + 86400)) . '</p>';
428	+ echo '<form method="post">';
429	+ echo '<table width="100%" callpadding="5" cellspacing="5">';
430	+ echo '<tr><td align="center">';
431	+ echo __('Schedule: ', 'wp_backup');
432	+ $wp_cron_backup_schedule = get_option('wp_cron_backup_schedule');
433	+ $schedule = array("None" => 0, "Daily" => 1);
434	+ foreach ($schedule as $name => $value) {
435	+ echo ' <input type="radio" name="cron_schedule"';
436	+ if ($wp_cron_backup_schedule == $value) {
437	+ echo ' checked="checked" ';
438	+ }
439	+ echo 'value="' . $value . '" /> ' . __($name, 'wp_backup');
440	+ }
441	+ echo '</td><td align="center">';
442	+ $cron_recipient = get_option('wp_cron_backup_recipient');
443	+ if (! is_email($cron_recipient)) {
444	+ $cron_recipient = get_settings('admin_email');
445	+ }
446	+ echo __('Email backup to', 'wp_backup') . ': <input type="text" name="cron_backup_recipient" size="20" value="' . $cron_recipient . '" />';
447	+ echo '</td></tr>';
448	+ echo '<tr><td colspan="2" align="center"><input type="hidden" name="wp_cron_backup_options" value="SET" /><input type="submit" name="submit" value="' . __('Submit', 'wp_backup') . '" /></td></tr></table></form>';
449	+ echo '</fieldset>';
450	+ }
451	+ // end of wp_cron section
452	+
453	+ echo '</fieldset></div>';
454	+
455	+ }// end wp_backup_menu()
456	+
457	+ /////////////////////////////
458	+ function wp_cron_db_backup() {
459	+
460	+ $schedule = intval(get_option('wp_cron_backup_schedule'));
461	+ if (0 == $schedule) {
462	+ // Scheduled backup is disabled
463	+ return;
464	+ }
465	+
466	+ global $wp_backup_dir, $wp_backup_error, $table_prefix;
467	+ $core_tables = array ($table_prefix . categories,
468	+ $table_prefix . comments,
469	+ $table_prefix . linkcategories,
470	+ $table_prefix . links,
471	+ $table_prefix . options,
472	+ $table_prefix . post2cat,
473	+ $table_prefix . postmeta,
474	+ $table_prefix . posts,
475	+ $table_prefix . users);
476	+
477	+ $recipient = get_option('wp_cron_backup_recipient');
478	+
479	+ $backup_file = wp_db_backup(TRUE, $core_tables);
480	+ if (FALSE !== $backup_file) {
481	+ wp_deliver_backup ($backup_file, 'smtp', $recipient);
482	+ }
483	+
484	+ return;
485	+ } // wp_cron_db_backup
486	+
487	+ ?>

wp-db-backup.txt ADDED Viewed

	@@ -0,0 +1,86 @@


1	+ = WP-DB-Backup =
2	+ tags: mysql, database, backup
3	+ Contributors: Firas, LaughingLizard, MtDewVirus, Podz
4	+
5	+ copyright (c) 2005 Scott Merrill (skippy@skippy.net)
6	+
7	+ WP-DB-Backup allows you to easily backup your core WordPress database tables. You may also optionally backup other tables in the same database.
8	+
9	+ Released under the terms of the GNU GPL, version 2.
10	+ http://www.fsf.org/licensing/licenses/gpl.html
11	+
12	+ NO WARRANTY.
13	+
14	+ == Installation ==
15	+ 1. Create a directory /wp-content/backup/ inside your WordPress directory.
16	+ 2. Make this directory writable by your webserver.
17	+ For example:
18	+ $ cd wordpress/wp-content
19	+ $ mkdir backup
20	+ $ chgrp www-data backup
21	+ $ chmod g+w backup
22	+ 3. Install and activate wp-db-backup.php
23	+
24	+ == Usage ==
25	+ 1) Click the Manage menu in your WordPress admin area.
26	+ 2) Click the Backup sub-menu.
27	+
28	+ The following core WordPress tables will be included in every backup:
29	+ * wp_categories
30	+ * wp_comments
31	+ * wp_linkcategories
32	+ * wp_links
33	+ * wp_options
34	+ * wp_post2cat
35	+ * wp_postmeta
36	+ * wp_posts
37	+ * wp_users
38	+ (Where "wp_" will automatically be replaced by whatever table prefix you use.)
39	+
40	+ 3) The plugin will look for other tables in the same database. You may elect to include other tables in the backup.
41	+ NOTE
42	+ Including other tables in your backup may substantially increase the
43	+ size of the backup, which may in turn cause several problems:
44	+ * PHP may run out of memory
45	+ * PHP may run out of time
46	+ * emailing the backup may fail because it's too big
47	+
48	+ 4) Select how you'd like the backup to be delivered:
49	+ * None : this will create a file in /wp-content/backup/ for you to retreive later
50	+ * Email : this will email the backup file to the address you specify
51	+ * Download : this will send the backup file to your browser to be downloaded
52	+
53	+ 5) Optionally elect to have the backup gzip. This is strongly recommended.
54	+ 6) Click "Backup!" and your database backup will be delivered to you.
55	+
56	+ The filename of the backup file will be of the form
57	+ DB_prefix_date.sql
58	+ DB = the name of your WordPress database, as defined in wp-config.php
59	+ prefix = the table prefix for this WordPress blog, as defined in wp-config.php
60	+ date = CCYYmmdd_B format: 20050711_039
61	+ the "B" is the internet "Swatch" time.
62	+ See the PHP date() function for details.
63	+
64	+ When having the database backup emailed or sent to your browser for immediate download, the backup file will be _deleted_ from the server when the transfer is finished. Only if you select delivery method "None" will the backup file remain on your server.
65	+
66	+ * SECURITY WARNING *
67	+ Your database backup contains sensitive information,
68	+ and should not be left on the server for any extended
69	+ period of time. The "None" delivery method is provided
70	+ as a convenience only. I will not accept any responsibility
71	+ if other people obtain your backup file.
72	+ * SECURITY WARNING *
73	+
74	+ == Advanced ==
75	+ Included with this plugin is a supplemental plugin, wp-cron-db-backup.php, which makes use of my WP-Cron plugin:
76	+ http://www.skippy.net/blog/2005/05/26/plugin-wp-cron/
77	+
78	+ If you also have installed and activated WP-Cron, you will have another set of options available at Manage -> Backup.
79	+
80	+ Here you can schedule automated backups of your core WordPress tables, and have them emailed to the address of your choice.
81	+
82	+ ONLY the core WordPress tables will be backed up
83	+ no plugin tables will be included.
84	+
85	+ This backup will occur once per day. To disable, select "None" for the schedule.
86	+