Database

The following options are included in the Database section of the Advanced & Troubleshooting Settings page.

Screen_Shot_2017-06-21_at_4.00.15_PM.png

Database method strategy

[Default:  PHP-based] - Normally use PHP-based which supports chunking (as of BackupBuddy v5) to support larger databases.  Commandline-based database dumps use mysqldump which is very fast and efficient but cannot be broken into smaller steps if it is too large which could result in timeouts on larger servers.  

Skip database dump on backup

[Default:  disabled] - Warning:  This prevents BackupBuddy from backing up the database during any kind of backup.  This is for troubleshooting/advanced usage only to work around being unable to backup the database.  

Break out big table dumps into steps

[Default:  enabled] - When enabled, BackupBuddy will dump some of the commonly larger tables in separate steps.  Note this only applies to command-line based dumps as PHP-based dumps automatically support chunking with resume on table and/or row as needed.  

Use separate files per table (when possible)

[Default:  enabled] - When enabled, BackupBuddy will dump individual tables to their own database file (eg. wp_woptions.squl, wp_posts.sql, etc.) when possible based on other criteria such as the dump method and whether breaking out big tables is enabled.  

Compatibility mode max rows per select

[Default:  *blank*] 0 When BackupBuddy is using compatibility mode MySQL dumping (via PHP), BackupBuddy selects data from the database.  Reducing this number has BackupBuddy grab smaller portions from the database at a time.  Leave blank to use the built-in default (around 2000 rows per select).  

Skip max command line length check

[Default:  disabled] - Warning:  BackupBuddy attempts to determine your system's maximum command line length to ensure that database operation commands do not get inadvertently cut off.  On some systems, it is not possible to reliably detect this information which could result in falling back into compatibility mode even though the system is capable of running in normal operational modes.  This option instructs BackupBuddy to skip the command line length check.  

Have more questions? Submit a request
Powered by Zendesk