WP CLI

Install

wget https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar
chmod +x wp-cli.phar
sudo mv wp-cli.phar /usr/local/bin/wp
# wp --info

Open the .zshrcfile and add the following line to the bottom of the file:

autoload bashcompinit
bashcompinit
source /home/$USER/wp-completion.bash

Or execute the commands below:

echo "autoload bashcompinit" >> ~/.zshrc 
echo "bashcompinit" >> ~/.zshrc 
echo "source /home/$USER/wp-completion.bash" >> ~/.zshrc 

Then reload your ZSH

source ~/.zshrc

Docker Container + Bash auto-completion

Dockerfile

...

RUN wget https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar
RUN chmod +x wp-cli.phar
RUN mv wp-cli.phar /usr/local/bin/wp

...

Option

Get current site URL

#!/bin/bash
echo "[ Check current siteurl ]"
currentSiteUrl=$(wp option get siteurl)

if [["$currentSiteUrl" != 'https://yoursiteurl.com']]; then
  if [[ "$WPAPP_ENV_HOST" != "$currentSiteUrl" ]]; then
    wp --allow-root search-replace $currentSiteUrl $WPAPP_ENV_HOST 'wp_*options'
  fi
  #define( 'WP_HOME', 'http://yoursiteurl.com' );
  #define( 'WP_SITEURL', ‘http://yoursiteurl.com' );
fi

Cache

  add          Adds a value to the object cache.
  decr         Decrements a value in the object cache.
  delete       Removes a value from the object cache.
  flush        Flushes the object cache.
  get          Gets a value from the object cache.
  incr         Increments a value in the object cache.
  replace      Replaces a value in the object cache, if the value already exists.
  set          Sets a value to the object cache, regardless of whether it already exists.
  type         Attempts to determine which object cache is being used.
  
# Example
  
wp cache flush

User

# List users
wp user list --field=ID

# Create User
wp user create bob [e-mail] --role=author

### Success: Created user 12.
### Password: b58moeu@9&Nzg!#FKn1pROU%

# With root privileges
wp user --allow-root create admin [e-mail] --role=administrator --user_pass=Abcd123456

# Create User With password
wp user create admin [e-mail] --role=administrator --user_pass=Abcd123456

# Delete User
wp user delete 123

# Update User
wp user update 123 --display_name=Mary --user_pass=marypass

Search and replace

Only for specific tables

wp --allow-root search-replace https://mysite http://mysite 'wp_*options' --dry-run

Production multisite to a local database

wp search-replace example.com example.test 'wp_*options' wp_blogs

Example 2:

#!/bin/bash
if $(wp --url=http://example.com core is-installed --network); then
    wp search-replace --url=http://example.com 'http://example.com' 'http://example.test' --recurse-objects --network --skip-columns=guid --skip-tables=wp_users
else
    wp search-replace 'http://example.com' 'http://example.test' --recurse-objects --skip-columns=guid --skip-tables=wp_users
fi

Restore database

wp db import my_wordpress_db.sql

Backup database

wp db export my_wordpress_db.sql

Deactivate plugin

wp plugin deactivate better-wp-security --allow-root