WP-CLI - Handy Commands

WP-CLI-Commands

Search and replace
https://wp-cli.org/commands/search-replace/
wp search-replace
wp search-replace 'http://example.dev' 'http://example.com'

Optmize database
https://wp-cli.org/commands/db/optimize/
wp db optimize

Repair database
http://wp-cli.org/commands/db/repair/
wp db repair

WordPress core version
https://wp-cli.org/commands/core/version/
wp core version
wp core install
wp core install --url=<url>
wp core install --admin_user=<username>
wp core install --admin_password=<password>
wp core install --admin_email=<email>
wp core download --latest --force
wp core download --nightly --force

Active plugins
http://wp-cli.org/commands/plugin/list/
wp plugin list
wp plugin list --status=active

Deactivate plugin
http://wp-cli.org/commands/plugin/deactivate/
wp plugin deactivate
wp plugin deactivate hello-dolly

Theme list
http://wp-cli.org/commands/theme/list/
wp theme list --status=active

Activate default theme
http://wp-cli.org/commands/theme/activate/
wp theme activate twentysixteen

Delete comment
http://wp-cli.org/commands/comment/delete/
wp comment delete

wp plugin deactivate --all --skip-theme --skip-plugins

Delete the database in MySQL
https://wp-cli.org/commands/db/drop/
wp db drop

List the MySQL database tables
https://wp-cli.org/commands/db/tables/
wp db tables
wp db export --tables=$(wp db tables --url=subdomain.example.com --format=csv)