db-command
db-command copied to clipboard
wp-cli
Performs basic database operations using credentials stored in wp-config.php.
In my workflow I rsync and use wp cli via SSH to import/export the database and then do a search-replace to update the URLs, etc... While it works perfectly I...
## Feature Request - [X] Yes, I reviewed the [contribution guidelines](https://make.wordpress.org/cli/handbook/contributing/). **Describe your use case and the problem you are facing** The `db query` command currently formats the results in...
The way options to the underlying `mysql*` tools are currently handled is extremely inconsistent. This is a first try at making everything more consistent and ensuring that all tools can...
When using the `wp db search` command to search only in a given table (eg. `wp_posts`), I'd like the output to only contain IDs so I can export them elsewhere...
## Bug Report - [x] Yes, I reviewed the [contribution guidelines](https://make.wordpress.org/cli/handbook/contributing/). - [x] Yes, more specifically, I reviewed the guidelines on [how to write clear bug reports](https://make.wordpress.org/cli/handbook/bug-reports/). ### Describe the...
One of the most common tasks database administrators need to do is create user accounts for applications with full privileges to the application's database. I propose that we make that...
Hi, I tried to run `wp db optimize --quiet ` and `wp db repair --quiet ` but they both produce informational messages.
Query command run through `assoc_args_to_str` get double quotes truncated and fail to execute. Using single quotes in the query prevent error. `Warning: Failed to get current character set of the...
Closes #158 Related https://github.com/wp-cli/wp-cli/issues/5859
**Describe the current, buggy behavior** Several `wp db *` commands don't work with sqlite. SQLite is in [testing fase](https://make.wordpress.org/core/2022/12/20/help-us-test-the-sqlite-implementation/) **Describe how other contributors can replicate this bug** - Install a...
