Database Prefix Rename SQL Builder

Generate safe MySQL queries to rename table prefixes and update internal role capabilities in options and usermeta.

1. Table Prefix Configuration

Current Table Prefix

New Table Prefix (Must end with underscore, e.g. wp_x7k_)

2. Core Tables to Rename

Core Tables (posts, postmeta, options, users, usermeta, etc.) WooCommerce Tables (woocommerce_order_items, wc_orders, etc.) Update Internal Role & Capability Keys (Critical!)

⚠️ Important: Always create a full database backup before running rename queries. After executing the SQL, update $table_prefix = 'new_prefix_'; in your wp-config.php.

SQL Queries (phpMyAdmin / MySQL CLI)

Generating SQL rename queries...

← Explore Other Tools Browse Code Snippets →

Database Prefix Rename SQL Builder

1. Table Prefix Configuration

2. Core Tables to Rename

Engineered for WordPress Developers