Manage WordPress via WP-CLI with these Shortcuts, scripts, functions, aliases.

1-wp-cli-shortcuts

update text inside a post 
(we work with 3rd party vendors, their urls occasionally change; 
or we changed a campaign's name used in google analytics) and limit it to ONLY published posts. 
(sometimes, our marketing team wants to what see how content was EXACTLY in the past). wp-cli's search-replace command by default make edits in revisions. 

(in this command, 'before' is what you want to get rid of and 'after' is what you want to replace 'before' with. 

`wp db query "UPDATE $(wp db tables "*_posts") SET post_content = REPLACE(post_content, 'before', 'after') WHERE post_status = 'publish';"`


now available as one command (thanks to Alain Schlesser!)

Note the command is CASE-SENSITIVE.

example2.md

Commands: These are all unix-based; (I put these into my .bashrc of ~/ my dev environments and then run source ~/.bashrc to ensure they are used) (for reference, in unix, $1 is the first argument)

• Install a plugin and immediately activate it:

plugme() { wp plugin install $1 --activate }

For example plugme classic-editor would immediately install the plugin and activate it on your site.

---

• Change the activation status of an plugin in a wordpress installation. Very helpful for troubleshooting and want to determine if a behaviour is repeatable when a plugin is active or inactive. e.g. deplugme query-monitor will deactivate an activated/active query-monitor plugin type it once more; and the plugin will be reactivated.

deplugme() { wp plugin toggle $1 }

---

• Deactivates and uninstalls a plugin (helpful when I want to get rid of a plugin after I try it out, dislike it, want to get rid of it)

unplugme() { wp plugin uninstall $1 --deactivate }

---

• switch to another theme:

totheme() { wp theme activate $1 }

so, entering totheme twentytwentyfive will change the active theme to twentytwentyfive

---

• delete and trash a post (argument is the post_id)

trash() { wp post delete $1 --force }

---

• empty the trash, specify the post_type b/c if you don't, wp-cli will only delete post types 'posts'

trashempty() { wp post delete $(wp post list --post_type=page,post,your_custom_post_type --post_status=trash --format=ids) }

---

alias recentedits="wp post list --post_type=post,page,name_of_your_custom_post_type --orderby=modified --order=DESC --fields=ID,post_title,post_date,post_modified --posts_per_page=10"

typing recentedits will return the list of last 10 recently edited pieces of content on your website

gistfile1.md

#not quite wp-cli but very handy:

find all posts/pages on your WP install that do not contain any WordPress blocks;

select post_name, post_type, id from wp_posts WHERE post_content NOT LIKE '%<!-- wp:%' AND post_status = 'publish' AND post_type in ('post','page');

my-wp-backup.sh

#!/bin/bash
# save as my-wp-backup.sh
# then chmod+x my-wp-backup.sh
# daily backup of your database. 
# assumes you have shell access to your website and that your wp installation is in ~/public_html
# names dates as ISO 8601; 
# e.g. 2018-12-01 is December 01, 2018

today="$(date +%Y-%m-%d)"
echo "today" ${today}

# note, if you use cpanel, you may need to specify your paths to PHP and to the wp-cli executable 
# ask me for more details if you need them
cd $HOME/public_html && wp db export ../sql_backup/${today}-production.sql && cd ../sql_backup && tar -cvzf ${today}-production.sql.tar.gz ${today}-production.sql && rm -f ${today}-production.sql