wp/wp-content/plugins/wp-db-backup/README.markdown
author ymh <ymh.work@gmail.com>
Tue, 09 Jun 2015 03:35:32 +0200
changeset 5 5e2f62d02dcd
parent 0 d970ebf37754
child 7 cf61fcea0001
permissions -rw-r--r--
upgrade wordpress + plugins
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
0
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
     1
WP-DB-Backup
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
     2
============
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
     3
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
     4
Contributors: filosofo
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
     5
Donate link: http://austinmatzko.com/wordpress-plugins/wp-db-backup/
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
     6
Tags: mysql, database, backup, cron
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
     7
Requires at least: 2.0.3
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
     8
Tested up to: 3.6.1
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
     9
Stable tag: 2.2.4
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    10
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    11
On-demand backup of your WordPress database.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    12
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    13
Description 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    14
-----------
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    15
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    16
WP-DB-Backup allows you easily to backup your core WordPress database tables.  You may also backup other tables in the same database.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    17
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    18
Released under the terms of the GNU GPL, version 2.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    19
   http://www.fsf.org/licensing/licenses/gpl.html
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    20
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    21
              NO WARRANTY.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    22
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    23
	Copyright (c) 2013 Austin Matzko
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    24
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    25
Installation 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    26
------------
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    27
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    28
1. Extract the wp-db-backup/ folder file to /wp-content/plugins/
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    29
1. Activate the plugin at your blog's Admin -> Plugins screen
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    30
1. The plugin will attempt to create a directory /wp-content/backup-*/ inside your WordPress directory.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    31
1. You may need to make /wp-content writable (at least temporarily) for it to create this directory. 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    32
   For example:
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    33
   `$ cd /wordpress/`
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    34
   `$ chgrp www-data wp-content` (where "`www-data`" is the group your FTP client uses)
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    35
   `$ chmod g+w wp-content`
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    36
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    37
Frequently Asked Questions 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    38
--------------------------
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    39
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    40
How do I restore my database from a backup? 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    41
-------------------------------------------
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    42
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    43
Briefly, use phpMyAdmin, which is included with most hosting control panels. More details and links to further explanations are [here](http://codex.wordpress.org/Restoring_Your_Database_From_Backup).
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    44
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    45
Why can't I schedule automatic backups to be saved to my server? 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    46
----------------------------------------------------------------
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    47
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    48
Although WP-DB-Backup provides the option of saving the backup file to the server, I strongly discourage anyone from leaving backed-up database files on the server. If the server is not perfectly configured, then someone could gain access to your data, and I do not want to make it easy for that to happen.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    49
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    50
My backup stops or hangs without completing. 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    51
--------------------------------------------
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    52
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    53
If you edit the text of wp-db-backup.php in a text editor like Notepad, you’ll see around line 50 the following:
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    54
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    55
`/**
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    56
* Set MOD_EVASIVE_OVERRIDE to true
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    57
* and increase MOD_EVASIVE_DELAY
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    58
* if the backup stops prematurely.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    59
*/
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    60
// define('MOD_EVASIVE_OVERRIDE', false);
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    61
define('MOD_EVASIVE_DELAY', '500');`
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    62
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    63
Do what it says: un-comment MOD_EVASIVE_OVERRIDE and set it to true like so:
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    64
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    65
`define('MOD_EVASIVE_OVERRIDE', true);`
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    66
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    67
That will slow down the plugin, and you can slow it even further by increasing the MOD_EVASIVE_DELAY number from 500.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    68
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    69
Better yet, put the lines that define the `MOD_EVASIVE_OVERRIDE` and `MOD_EVASIVE_DELAY` constants in your wp-config.php file, so your settings don't get erased when you upgrade the plugin.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    70
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    71
What is wp-db-backup.pot for? 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    72
-----------------------------
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    73
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    74
This files is used by non-English users to translate the display into their native language.  Translators are encouraged to send me translated files, which will be made available to others here:
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    75
http://austinmatzko.com/wordpress-plugins/wp-db-backup/i18n/
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    76
http://plugins.trac.wordpress.org/browser/wp-db-backup/i18n/
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    77
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    78
Why are only the core database files backed up by default? 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    79
----------------------------------------------------------
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    80
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    81
Because it's a fairly safe bet that the core WordPress files will be successfully backed up.  Plugins vary wildly in the amount of data that they store.  For instance, it's not uncommon for some statistics plugins to have tens of megabytes worth of visitor statistics.  These are not exactly essential items to restore after a catastrophic failure.  Most poeple can reasonably live without this data in their backups.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    82
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    83
Usage 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    84
-----
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    85
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    86
1. Click the Tools or Manage menu in your WordPress admin area.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    87
1. Click the Backup sub-menu.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    88
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    89
1. The plugin will look for other tables in the same database.  You may elect to include other tables in the backup.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    90
  ** NOTE **
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    91
  Including other tables in your backup may substantially increase the size of the backup file!
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    92
  This may prevent you from emailing the backup file because it's too big.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    93
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    94
1. Select how you'd like the backup to be delivered:
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    95
 * Save to server : this will create a file in /wp-content/backup-*/ for you to retreive later
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    96
 * Download to your computer : this will send the backup file to your browser to be downloaded
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    97
 * Email : this will email the backup file to the address you specify
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    98
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
    99
1. Click "Backup!" and your database backup will be delivered to you.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   100
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   101
The filename of the backup file will be of the form
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   102
   DB_prefix_date.sql
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   103
DB = the name of your WordPress database, as defined in wp-config.php
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   104
prefix = the table prefix for this WordPress blog, as defined in wp-config.php
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   105
date = CCYYmmdd_B format:  20050711_039
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   106
       the "B" is the internet "Swatch" time.  
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   107
       See the PHP date() function for details.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   108
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   109
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 "Save to server" will the backup file remain on your server.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   110
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   111
   *** SECURITY WARNING ***
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   112
   Your database backup contains sensitive information,
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   113
   and should not be left on the server for any extended
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   114
   period of time.  The "Save to server" delivery method is provided
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   115
   as a convenience only.  I will not accept any responsibility
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   116
   if other people obtain your backup file.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   117
   *** SECURITY WARNING ***
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   118
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   119
Changelog 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   120
---------
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   121
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   122
2.2.3  
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   123
-----
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   124
* Nonce check fix for localized WP users from Sergey Biryukov
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   125
* Fix for gzipped files' incorrect size.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   126
* Some styling improvements.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   127
* Fix for JS multiple checkbox selection.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   128
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   129
Upgrade Notice 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   130
--------------
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   131
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   132
2.2.3 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   133
-----
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   134
* Fixes problems users had when using localized WordPress installations.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   135
* Fixes a bug that caused the size of gzipped backup files to be reported incorrectly.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   136
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   137
Advanced 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   138
--------
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   139
If you are using WordPress version 2.1 or newer, you can schedule automated backups to be sent to the email address 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   140
of your choice.
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   141
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   142
Translators 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   143
-----------
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   144
Thanks to following people for providing translation files for WP-DB-Backup:
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   145
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   146
* Abel Cheung
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   147
* Alejandro Urrutia
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   148
* Alexander Kanakaris
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   149
* Angelo Andrea Iorio
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   150
* Calle
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   151
* Daniel Erb
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   152
* Daniel Villoldo
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   153
* Diego Pierotto
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   154
* Eilif Nordseth
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   155
* Eric Lassauge
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   156
* Friedlich
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   157
* Gilles Wittezaele
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   158
* Icemanpro
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   159
* İzzet Emre Erkan
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   160
* Jong-In Kim
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   161
* Kaveh
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   162
* Kessia Pinheiro
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   163
* Kuratkoo
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   164
* Majed Alotaibi
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   165
* Michał Gołuński
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   166
* Michele Spagnuolo
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   167
* Paopao
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   168
* Philippe Galliard
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   169
* Robert Buj
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   170
* Roger
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   171
* Rune Gulbrandsøy
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   172
* Serge Rauber
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   173
* Sergey Biryukov
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   174
* Tai
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   175
* Timm Severin
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   176
* Tzafrir Rehan
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   177
* 吴曦
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   178
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   179
Past Contributors 
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   180
-----------------
d970ebf37754 first import
ymh <ymh.work@gmail.com>
parents:
diff changeset
   181
skippy, Firas, LaughingLizard, MtDewVirus, Podz, Ringmaster