📄️ wp db check
Check all WordPress database tables for errors and corruption using WP-CLI's wp db check command.
📄️ wp db optimize
Optimize all WordPress database tables to reclaim wasted space and improve query performance using WP-CLI.
📄️ wp search-replace (Advanced)
Advanced techniques for wp search-replace in WP-CLI: regex, serialized object recursion, multisite, column targeting, and safe export patterns.
📄️ wp search-replace
Search and replace strings across the WordPress database using WP-CLI. Safely handles serialized data that manual SQL UPDATE cannot.
📄️ wp db create
Create the WordPress database defined in wp-config.php using WP-CLI without needing to access the MySQL shell.
📄️ wp db repair
Repair corrupted or crashed WordPress database tables using WP-CLI's wp db repair command.
📄️ wp db drop
Drop (permanently delete) the WordPress database defined in wp-config.php using WP-CLI.
📄️ wp db export
Export the WordPress database to a SQL dump file using WP-CLI. Supports table filtering, compression, and custom mysqldump options.
📄️ wp db import
Import a SQL dump file into the WordPress database using WP-CLI. Used for migrations, restores, and environment setup.
📄️ wp db query
Execute a raw SQL query directly against the WordPress database using WP-CLI. Supports SELECT, UPDATE, DELETE, and complex SQL operations.
📄️ wp db reset
Drop all WordPress database tables and recreate an empty database structure using WP-CLI. Used before re-importing or reinstalling.
📄️ wp db size
Display the size of the WordPress database and individual tables using WP-CLI. Useful for disk space auditing and identifying bloat.
📄️ wp db tables
List all tables in the WordPress database using WP-CLI. Supports filtering by scope and output format.