BackupBuddy Settings: Database Defaults

From IThemes Codex
(Difference between revisions)
Jump to: navigation, search
(Default database tables to backup)
 
(35 intermediate revisions by one user not shown)
Line 1: Line 1:
 +
The '''Database Defaults''' section of the [[BackupBuddy:_General_Settings|General Settings]] tab allows you to set the default base of database tables to backup, plus specific inclusions and exclusions of tables beyond the <code>wp_</code> base.
 +
 +
<br />
 +
 +
[[File:database-defaults.png|800px|link=]]
 +
 +
<br />
 +
 +
__NOTOC__
 +
 +
==Understanding WordPress Database Tables==
 +
 +
For more information on WordPress database tables, visit the [http://codex.wordpress.org/Database_Description WordPress Codex Database Description page] for an outline and description of the database tables created during a standard installation of WordPress.
 +
 
=Default database tables to backup=
 
=Default database tables to backup=
[Default: This WordPress' tables prefix (<code>wp_</code>)] - This setting determines the default set of database tables to backup.  If this WordPress' tables is selected, then only tables with the same prefix (for example <code>wp_</code> for this installation) will be backed up by default.  If all are selected, then all tables will be backed up by default. Additional inclusions & exclusions may be defined in the inclusions and exclusions picker.
+
This setting determines the default set of database tables to backup.  If this WordPress' tables is selected, then only tables with the same prefix (for example <code>wp_</code> for this installation) will be backed up by default.  If all are selected, then all tables will be backed up by default. Additional inclusions & exclusions may be defined in the inclusions and exclusions picker.
  
 
Choose from:
 
Choose from:
  
*This WordPress' tables (prefix <code>wp_</code>)  
+
*'''This WordPress' tables (prefix <code>wp_</code>)''' - [Default] Default WordPress tables with the <code>wp_</code> prefix.
*All tables in database (including non-WordPress)
+
*'''All tables in database (including non-WordPress)''' - When this option is enabled, ALL tables and data in the database will be backed up, even database content not related to WordPress, its content or plugins (based on prefix). This is useful if you have other software installed on your hosting that stores data in your database.
  
 +
==Inclusions / Exclusions beyond base==
 +
Using the picker on the left, choose additional databases tables to include OR exclude IN ADDITION to the DEFAULTS determined by the '''Default database tables to backup''' option. You may override defaults with exclusions.
 +
 +
'''Note:''' Excluding tables may result in an incomplete or broken backup, so exercise caution.
 +
 +
<div class="exchange-home-list">
 
=See also=
 
=See also=
 
*[[BackupBuddy_Settings:_Introduction|Introduction]]
 
*[[BackupBuddy_Settings:_Introduction|Introduction]]
Line 20: Line 40:
 
**[[BackupBuddy_Settings:_Database|Database]]
 
**[[BackupBuddy_Settings:_Database|Database]]
 
**[[BackupBuddy_Settings:_Zip|Zip]]
 
**[[BackupBuddy_Settings:_Zip|Zip]]
 +
*[[BackupBuddy:_Import/Export_Plugin_Settings|Import/Export Plugin Settings]]
 +
</div>
 +
 +
<div class="exchange-home-list">
 +
=Additional Links=
 +
From the WordPress Codex:
 +
*[http://codex.wordpress.org/Database_Description Database Description]
 +
**[http://codex.wordpress.org/Database_Description#Database_Diagram Database Diagram]
 +
**[http://codex.wordpress.org/Database_Description#Table_Overview Table Overview]
 +
**[http://codex.wordpress.org/Database_Description#Table_Details Table Details]
 +
</div>
  
 
<br />
 
<br />
[[:BackupBuddy_Test|← Back to BackupBuddy Codex Home]]
+
[[:BackupBuddy|← Back to BackupBuddy Codex Home]]

Latest revision as of 15:30, August 13, 2013

The Database Defaults section of the General Settings tab allows you to set the default base of database tables to backup, plus specific inclusions and exclusions of tables beyond the wp_ base.


Database-defaults.png



Understanding WordPress Database Tables

For more information on WordPress database tables, visit the WordPress Codex Database Description page for an outline and description of the database tables created during a standard installation of WordPress.

Default database tables to backup

This setting determines the default set of database tables to backup. If this WordPress' tables is selected, then only tables with the same prefix (for example wp_ for this installation) will be backed up by default. If all are selected, then all tables will be backed up by default. Additional inclusions & exclusions may be defined in the inclusions and exclusions picker.

Choose from:

  • This WordPress' tables (prefix wp_) - [Default] Default WordPress tables with the wp_ prefix.
  • All tables in database (including non-WordPress) - When this option is enabled, ALL tables and data in the database will be backed up, even database content not related to WordPress, its content or plugins (based on prefix). This is useful if you have other software installed on your hosting that stores data in your database.

Inclusions / Exclusions beyond base

Using the picker on the left, choose additional databases tables to include OR exclude IN ADDITION to the DEFAULTS determined by the Default database tables to backup option. You may override defaults with exclusions.

Note: Excluding tables may result in an incomplete or broken backup, so exercise caution.

Additional Links

From the WordPress Codex:


← Back to BackupBuddy Codex Home

Personal tools
Namespaces
Variants
Actions
iThemes Codex
Codex Navigation
Toolbox