WordPress URL Replacer – Replace URLs in SQL Database Dumps Online

Migrate WordPress to a new domain in seconds with this free online WordPress URL Replacer tool. Paste your SQL database dump or upload a .sql file, enter the old URL and new URL, and download the updated file instantly. Fully handles PHP serialized data in wp_options, postmeta, widgets, and menus — automatically recalculates byte-counts so WordPress can unserialize the data correctly. Also replaces GUIDs in the guid column. Nothing is ever sent to a server: all SQL processing runs entirely in your browser, keeping your database contents private. Perfect for WordPress site migrations, moving from localhost to production, staging-to-live deployments, and HTTP-to-HTTPS upgrades.

URL Replacement Settings

Options

SQL Input
Paste your SQL dump below
🔒 All processing happens in your browser — nothing is sent to any server

Quick-fill examples

How to Use the WordPress URL Replacer

How to replace URLs in a WordPress SQL database dump:

  1. Enter the Old URL — the domain you want to replace (e.g. https://old-site.com).
  2. Enter the New URL — your new domain or environment (e.g. https://new-site.com).
  3. Enable Fix serialized data to automatically recalculate PHP byte-counts — required for tables like wp_options, postmeta, widgets, and active theme settings.
  4. Enable Replace GUIDs to also update the WordPress guid column in your SQL dump.
  5. Paste your SQL dump directly into the text area, or upload a .sql file (drag & drop supported).
  6. Click Replace & Download — the corrected SQL database file downloads to your device instantly.

Why do WordPress SQL migrations need serialized data repair?

  • WordPress stores configuration, widget data, and theme options as PHP serialized strings in the database. For example: s:22:"https://old-site.com"; — where 22 is the byte-length of the string.
  • A simple search-and-replace on the raw SQL file will silently corrupt these records if the byte-count is not updated after the URL change — resulting in broken widgets, missing menus, and white screen errors.
  • This online tool automatically recalculates every byte-count after each replacement, producing a valid serialized SQL database dump ready to import.

WordPress URL replace tips:

  • Do not include a trailing slash in the old or new URL (https://site.com, not https://site.com/).
  • Always keep a backup of your original SQL dump before importing the replaced file into your database.
  • Use the HTTP → HTTPS quick-fill for easy SSL migration without touching your database manually.
  • For very large SQL files (>50 MB) prefer the Upload File tab over paste mode for better performance.
  • All SQL processing runs entirely in your browser — your database dump is never sent to any server.