Admin CP Database Tools
The pages in this section allow administrators with the appropriate permissions to create backups of the MyBB database, and to manage them. Also there is an option to optimize the database.
Contents |
[edit] Backup Database
This page will allow administrators to create a database dump.
[edit] Table Selection
First select the tables to be exported. The three links to the left are shortcuts to quickly select all the tables, none of the tables, or the MyBB core tables.
[edit] Backup Options
Administrators may choose various settings for the backup
[edit] Export File Type
This is the format that the database dump will be in.
- GZip Compressed
- MyBB will compress the dump before saving it or letting administrators download it. This may cause problems with larger forums as a significant amount of memory and execution time may be required to compress the dump.
- Plain Text
- Not compressed, but it the size of the backup will be larger than if compressed.
[edit] Save Backup
MyBB can save the backup to a folder on the host, or allow administrators to download it immediately
- Backup Directory
- For this to work, the admin/backups directory must be writable by the server. If it isn't, a yellow bar at the top of the page will read "Your backups directory (within the Admin CP directory) is not writable. You cannot save backups on the server."
- Download
- This will output the backup to the current administrator's browser as a download.
[edit] Backup Contents
This specifies is to be exported within the tables selected above.
- Structure and Data
- This will backup both the structure of the table, and the data within in (Default & Recommended)
- Structure
- This will only backup the structure of the table, and none of the content. This is not used regularly and does not constitute a true "backup"
- Data
- This exports only the data of the table.
[edit] Analyze and Optimize Selected Tables
It doesn't hurt to optimize the table before the export occurs, but this can be disabled if needed.
[edit] Perform a Sequential Backup
[edit] Start the Backup
Click on Perform Backup to start the backup process.
[edit] Existing Backups
This page allows administrators to download and manage existing backups stored on the server.
By clicking on the filename administrators can download the file. Administrators can delete the backup by clicking [delete] on the right of the backup.
[edit] Optimize Database
This page allows administrators to optimize tables in the MyBB database.
First select the tables to be optimized. The three links to the left are shortcuts to quickly select all the tables, none of the tables, or the MyBB core tables.
Then click on "Optimize Database Tables" to complete the operation.
It doesn't hurt to run this operation every few weeks or so. It keeps the database in order :)