Download the PHP package vse/dbtool without Composer
On this page you can find all versions of the php package vse/dbtool. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Package dbtool
Short Description A phpBB extension that allows you to check, optimize and repair phpBB's MySQL database tables from a phpMyAdmin-like interface in the Administration Control Panel or from the CLI.
License GPL-2.0-only
Homepage https://github.com/VSEphpbb/dbtool
Informations about the package dbtool
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 or from the CLI.
Features
- Optimize, Repair and Check tables directly from the ACP or the CLI
- Select individual tables or all tables at once
- Displays table size and table overhead values in the ACP
- Option to safely disable board during the optimize/repair process
- Results are logged to the Admin log
- Enhanced javascript interactions
Minimum Requirements
- phpBB 3.2.0
- PHP 5.4 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 clickEnable
.
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.
CLI Usage
The Optimize & Repair Tool can also be run from the command line interface in
phpBB using the db:tool
command. The tool will prompt you to choose an operation:
Optimize, Repair, or Check.
To check, optimize or repair all tables:
$ php bin/phpbbcli.php db:tool
To check, optimize or repair a specific table:
$ php bin/phpbbcli.php db:tool table_name
To disable the board during an operation, use the --disable-board
or -D
option:
$ php bin/phpbbcli.php db:tool --disable-board
For help with the Optimize & Repair Tool command:
$ php bin/phpbbcli.php db:tool --help
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 thedbtool
folder fromphpBB/ext/vse/
.
License
© 2013 - Matt Friedman