How to fix WP CLI db import export commands when run from macOS - Pilothouse-App/Pilothouse GitHub Wiki

When using Pilothouse, the WP-CLI db import/export commands do not work out-of-the-box when WP-CLI is run from the host, since they use the mysql and mysqldump CLI commands internally, and those utilities are not available on the macOS host by default.

While you can always run WP-CLI db commands inside the Docker containers, using pilothouse wp db import/export, that's not as convenient as running WP-CLI directly from the host.

The good news is that you can install the mysql-client package using Homebrew, and that will provide the needed mysql and mysqldump CLI commands on macOS without installing the full MySQL server package on the host.