The dbtool from kotm

dbtool's Introduction

Database Optimize & Repair Tool for phpBB

A phpBB extension that will allow you to check, optimize and repair phpBB's MySQL database tables from a phpMyAdmin-like interface in the Administration Control Panel.

Features

Optimize, Repair and Check tables directly from the ACP
Select individual or all tables independently
Displays table size and table overhead values
Option to safely disable board during the optimize/repair process
Actions are logged to the Admin log
Nice javascript interactions

Minimum equirements

phpBB 3.1.0 or phpBB 3.2.0
PHP 5.3.3 or higher
MySQL 4.0.1 or higher (using MyISAM, InnoDB or Archive table types)

Install

Download the latest validated release.
Unzip the downloaded release and copy it to the ext directory of your phpBB board.
Navigate in the ACP to Customise -> Manage extensions.
Find Database Optimize & Repair Tool under Disabled Extensions and click Enable.

Usage

After installation, you can find the Optimize & Repair Tool in:

ACP -> Maintenance -> Database -> Optimize & Repair.

Use this extension at your own risk! There have been cases with certain shared web hosts where a database table could crash for a very large forum. This extension will perform the same functions on your database as phpMyAdmin, so if you have been using phpMyAdmin on your database with no problems, then it should be safe to use this extension. It is always safest to run a backup of your database before performing any Optimize or Repair functions just in case anything goes wrong.

Note: InnoDB table types do not support the Repair option.

Uninstall

Navigate in the ACP to Customise -> Manage extensions.
Click the Disable link for Database Optimize & Repair Tool.
To permanently uninstall, click Delete Data, then delete the dbtool folder from phpBB/ext/vse/.