loadsys / cakephp-tablemaintenanceshell
A CakePHP console tool to run common MySQL database maintenance queries
Installs: 2 848
Dependents: 0
Suggesters: 0
Security: 0
Stars: 0
Watchers: 7
Forks: 0
Open Issues: 0
Type:cakephp-plugin
Requires
- php: >=5.3.0
- composer/installers: *
This package is not auto-updated.
Last update: 2024-04-14 04:04:04 UTC
README
A CakePHP v2.x console tool to run common MySQL database maintenance queries, including:
- 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.
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:
checkanalyzeoptimizerepair
The {table} param can be any valid table name, or the special word ALL meaning all tables.
Adding the --quiet or -q flag will suppress output unless an error exists.
Contributing
Reporting Issues
Please use GitHub Isuses for listing any known defects or issues.
Development
When developing this plugin, please fork and issue a PR for any new development.
License
Copyright
Loadsys Solutions 2018