loadsys/cakephp-tablemaintenanceshell

A CakePHP console tool to run common MySQL database maintenance queries

CakePHP-TableMaintenanceShell

A CakePHP v2.x console tool to run common MySQL database maintenance queries, including:, _(*1)

• CHECK
• ANALYZE
• OPTIMIZE
• REPAIR

Tables are locked with a READ lock for the check action, or WRITE locks for all other actions. This is to mimic the behavior of mysqlcheck as described here., _(*2)

Requirements

• CakePHP 2.x
• PHP 5.3+

Installation

$ composer require loadsys/cakephp-tablemaintenanceshell

Usage

Console/cake TableMaintenance.table_maintenance run {action} {table|ALL}

The {action} param can be any one of:, _(*3)

• check
• analyze
• optimize
• repair

The {table} param can be any valid table name, or the special word ALL meaning all tables., _(*4)

Adding the --quiet or -q flag will suppress output unless an error exists., _(*5)

Contributing

Reporting Issues

Please use GitHub Isuses for listing any known defects or issues., _(*6)

Development

When developing this plugin, please fork and issue a PR for any new development., _(*7)

License

MIT, _(*8)

Copyright

Loadsys Solutions 2018, _(*9)