← All tools
Database Table Prefix Changer
Rewrite a MySQL dump's table prefix (e.g. wp_ to wp2024_) safely, touching only backtick-quoted identifiers.
⚡ 199 points per successful run · Balance: 0 · Buy points
SQL Dump
Result
Paste a SQL dump and set the old/new prefixes.
How to Use
Paste a MySQL SQL dump, then enter the old and new table prefixes (e.g. wp_ → wp2024_). The tool only rewrites backtick-quoted SQL identifiers that start with the old prefix — `wp_posts`, `wp_options`, and so on, wherever they appear in CREATE TABLE, INSERT INTO, ALTER TABLE, or DROP TABLE IF EXISTS statements. Because MySQL never uses backticks for row data — actual VALUES are single-quoted strings — this can't accidentally rewrite the prefix text if it happens to appear inside real data. You get a replacement count and the fully rewritten SQL to copy or download.