Download

WP-DB-Backup

By Austin Matzko

Description

WP-DB-Backup allows you easily to backup your core WordPress database tables. You may also backup other tables in the same database.

Released under the terms of the GNU GPL, version 2.
http://www.fsf.org/licensing/licenses/gpl.html

          NO WARRANTY.

Copyright (c) 2018 Austin Matzko

Source Code on GitHub

Usage

  1. Click the Tools or Manage menu in your WordPress admin area.

  2. Click the Backup sub-menu.

  3. The plugin will look for other tables in the same database. You may elect to include other tables in the backup.
    ** NOTE **
    Including other tables in your backup may substantially increase the size of the backup file!
    This may prevent you from emailing the backup file because it’s too big.

  4. Select how you’d like the backup to be delivered:

* Download to your computer : this will send the backup file to your browser to be downloaded
* Email : this will email the backup file to the address you specify

  1. Click “Backup!” and your database backup will be delivered to you.

The filename of the backup file will be of the form
DB_prefix_date.sql
DB = the name of your WordPress database, as defined in wp-config.php
prefix = the table prefix for this WordPress blog, as defined in wp-config.php
date = CCYYmmdd_B format: 20050711_039
the “B” is the internet “Swatch” time.
See the PHP date() function for details.

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.

Advanced

If you are using WordPress version 2.1 or newer, you can schedule automated backups to be sent to the email address
of your choice.

Translators

Thanks to following people for providing translation files for WP-DB-Backup:
* Abel Cheung
* Alejandro Urrutia
* Alexander Kanakaris
* Angelo Andrea Iorio
* Calle
* Daniel Erb
* Daniel Villoldo
* Diego Pierotto
* Eilif Nordseth
* Eric Lassauge
* Friedlich
* Gilles Wittezaele
* Icemanpro
* İzzet Emre Erkan
* Jong-In Kim
* Kaveh
* Kessia Pinheiro
* Kuratkoo
* Majed Alotaibi
* Michał Gołuński
* Michele Spagnuolo
* Paopao
* Philippe Galliard
* Robert Buj
* Roger
* Rune Gulbrandsøy
* Serge Rauber
* Sergey Biryukov
* Tai
* Timm Severin
* Tzafrir Rehan
* 吴曦

Past Contributors

skippy, Firas, LaughingLizard, MtDewVirus, Podz, Ringmaster

Installation

  1. Extract the wp-db-backup/ folder file to /wp-content/plugins/
  2. Activate the plugin at your blog’s Admin -> Plugins screen
  3. The plugin will attempt to create a directory /wp-content/backup-*/ inside your WordPress directory.
  4. You may need to make /wp-content writable (at least temporarily) for it to create this directory.
    For example:
    $ cd /wordpress/
    $ chgrp www-data wp-content (where “www-data” is the group your FTP client uses)
    $ chmod g+w wp-content

FAQ

Installation Instructions
  1. Extract the wp-db-backup/ folder file to /wp-content/plugins/
  2. Activate the plugin at your blog’s Admin -> Plugins screen
  3. The plugin will attempt to create a directory /wp-content/backup-*/ inside your WordPress directory.
  4. You may need to make /wp-content writable (at least temporarily) for it to create this directory.
    For example:
    $ cd /wordpress/
    $ chgrp www-data wp-content (where “www-data” is the group your FTP client uses)
    $ chmod g+w wp-content
How do I restore my database from a backup?

Briefly, use phpMyAdmin, which is included with most hosting control panels. More details and links to further explanations are here.

My backup stops or hangs without completing.

If you edit the text of wp-db-backup.php in a text editor like Notepad, you’ll see around line 50 the following:

/**
* Set MOD_EVASIVE_OVERRIDE to true
* and increase MOD_EVASIVE_DELAY
* if the backup stops prematurely.
*/
// define('MOD_EVASIVE_OVERRIDE', false);
define('MOD_EVASIVE_DELAY', '500');

Do what it says: un-comment MOD_EVASIVE_OVERRIDE and set it to true like so:

define('MOD_EVASIVE_OVERRIDE', true);

That will slow down the plugin, and you can slow it even further by increasing the MOD_EVASIVE_DELAY number from 500.

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.

What is wp-db-backup.pot for?

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:
http://austinmatzko.com/wordpress-plugins/wp-db-backup/i18n/
https://plugins.trac.wordpress.org/browser/wp-db-backup/i18n/

Why are only the core database files backed up by default?

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.

Reviews

Has PHP errors

This is the first thing i see on all my pages:
Notice: Undefined index: wp_db_temp_dir in /var/www/html/wp-content/plugins/wp-db-backup/wp-db-backup.php on line 112

Install, activate, setup and forget … until needed

This is an excellent database plugin. I have daily host-level backups, and once a month I take a full cPanel backup, but as a belt and braces approach I now have daily database backups being sent to an email address, and filtered to a backup folder. Hope I never need them, but if I do I will be relieved to see these archived.

Happy with the way the plugin works

I’ve been using this plugin for a few years.

No problems whatsoever.

Yes, it might be a security issue to store the database on the server, so at least be aware of that.

Other than this, the plugin is great.

WooHoo! He’s back

Thanks Austin.
Your no-nonsense, it just works, plugin has been on all my sites for ages. Thank you for updating it (I thought you’d wandered off).

Read all 64 reviews

Contributors & Developers

“WP-DB-Backup” is open source software. The following people have contributed to this plugin.

Contributors

“WP-DB-Backup” has been translated into 13 locales. Thank you to the translators for their contributions.

Translate “WP-DB-Backup” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

2.3.0

  • Remove backup directory use

2.2.4

  • Remove deprecated functionality
  • Do not attempt to delete non-existent files

2.2.3

  • Nonce check fix for localized WP users from Sergey Biryukov
  • Fix for gzipped files’ incorrect size.
  • Some styling improvements.
  • Fix for JS multiple checkbox selection.

Meta

Ratings

See all

Contributors

Support

Issues resolved in last two months:

0 out of 1

View support forum

Donate

Would you like to support the advancement of this plugin?

Donate to this plugin