💡 WP-CLI is the command-line interface for WordPress that lets you manage your WordPress site, themes, and plugins from the terminal.
Here you can find most useful WP-CLI commands and tutorials.
For some operations such as database export, WP-CLI uses PHP exec() function which is disabled on most shared hosting servers. So if you do wp db export and no file was created, make sure to check your error_log file and if you notice this error: PHP Fatal Error: Uncaught Error: Call to undefined function exec() … Read full article →
Here are a few WP-CLI tricks and tips that might be useful: Aliases Use aliases to make commands shorter and easier to remember. You can use the –alias=<alias> flag when defining a command to specify a shorter alias for the command. For example, if you use a command wp my-command: you could define a command … Read full article →
Here are a few useful one-liners that you can use to quickly remove all WooCommerce products from your store. Another approach: PRO TIP:If you are considering deleting items in WooCommerce, please be aware that this action cannot be undone. Once you have deleted an item, it will be permanently gone from your store. Before taking … Read full article →
Tab completion is a useful time-saving feature of command line interfaces. To enable tab completion for WP-CLI We need to edit the ~/.bash_profile file. Step 1. In your home directory download WP-CLI tab completion file Step 2. Edit your ~/.bash_profile and add the following line: source ~/wp-completion.bash Save and exit. Step 3. Source the profile … Read full article →
IF you use the same commands often you can save them as aliases so that you have them always available. For example, the following commands will check if WP core, installed plugins and themes have updates available: You can combine the commands into a one-liner: and you can create an alias for this command: so … Read full article →
This small script uses a for loop to delete one post ID at a time, it will go through the database and list all media files uploaded in the provided data range that are not used inside posts. Change the date range according to your needs.
When migrating from WordPress CMS to another CMS there are a couple of ways to easily export all your posts and media files: In this guide we will be using the WPGraphQL plugin and Netlify to deploy a Gatsby website. Step 1. Fork the gatsbyjs/gatsby-starter-wordpress-blog repo on Github Step 2. Edit the gatsby-config.js file and … Read full article →
The principle of WPCLI is to add install it on the server, add it to path so that it can be accessed from any folder and then enter the installation folder of the website for which you want to run commands. The basic use of WP-CLI is: wp [COMMAND], e.g. wp config list will show … Read full article →
When cleaning websites that have large databases, regular text editors can’t even open the database dumps (Notepad++ supports files up to 2GB in size). So to run a search and replace on large database dumps I suggest using regex-replace line-by-line in PHP, or setting up WPCLI and running regex search & replace. Here is a … Read full article →
This simple query allows you to transfer all posts from one user to another. SQL query This will assign all posts from author ID=14 to the user with ID=1 (admin). WP-CLI This will remove the user [email protected] and assign all his posts to user with ID=1 (admin).