phpbb-extension dbtool {🖫 8, ⚐ 7, ★ 5}

vse/dbtool

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.

Thursday, June 28, 2018
by VSEphpbb
Repository
2 Watchers
5 Stars
8 Installations

PHP
0 Dependents
0 Suggesters
6 Forks
0 Open issues
7 Versions
0 % Grown

The README.md

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., _(*1)

, _(*2)

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 click Enable.

Usage

After installation, you can find the Optimize & Repair Tool in:, _(*3)

ACP -> Maintenance -> Database -> Optimize & Repair., _(*4)

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., _(*5)

Note: InnoDB table types do not support the Repair option., _(*6)

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., _(*7)

To check, optimize or repair all tables:, _(*8)

$ php bin/phpbbcli.php db:tool, _(*9)

To check, optimize or repair a specific table:, _(*10)

$ php bin/phpbbcli.php db:tool table_name, _(*11)

To disable the board during an operation, use the --disable-board or -D option:, _(*12)

$ php bin/phpbbcli.php db:tool --disable-board, _(*13)

For help with the Optimize & Repair Tool command:, _(*14)

$ php bin/phpbbcli.php db:tool --help, _(*15)

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/.

License

GNU General Public License v2, _(*16)

The Versions

28/06 2018

dev-master

9999999-dev https://github.com/VSEphpbb/dbtool

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.

Sources Download

GPL-2.0 GPL-2.0-only

The Requires

php >=5.3.3
composer/installers ~1.0

by Matt Friedman

by Matt Friedman (VSE)

database extension mysql phpbb optimize phpmyadmin repair

28/06 2018

1.1.3

1.1.3.0 https://github.com/VSEphpbb/dbtool

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.

Sources Download

GPL-2.0-only

The Requires

php >=5.3.3
composer/installers ~1.0

by Matt Friedman

database extension mysql phpbb optimize phpmyadmin repair

11/01 2017

1.1.2

1.1.2.0 https://github.com/VSEphpbb/dbtool

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.

Sources Download

GPL-2.0

The Requires

php >=5.3.3
composer/installers ~1.0

by Matt Friedman (VSE)

database extension mysql phpbb optimize phpmyadmin repair

01/05 2016

1.1.1

1.1.1.0 https://github.com/VSEphpbb/dbtool

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.

Sources Download

GPL-2.0

The Requires

php >=5.3.3
composer/installers ~1.0

by Matt Friedman (VSE)

database extension mysql phpbb optimize phpmyadmin repair

11/12 2014

1.1.0

1.1.0.0 https://github.com/VSEphpbb/dbtool

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

Sources Download

GPL-2.0