Change WordPress Host

Generate a ready-to-run SQL script to swap the old domain for a new one.

Input

Result

Change WordPress Host generates the SQL that replaces an old domain with a new one throughout a WordPress database. You fill in the old domain, the new domain and the table prefix, then paste the generated block into phpMyAdmin or the MySQL command line - no need to remember any UPDATE ... REPLACE syntax.

Moving a WordPress domain is not just editing the home and siteurl options. The old URL is also scattered through post content, through each post guid, and through meta fields written by themes and plugins. Miss one and you get broken images, internal links pointing back at the old domain, or a redirect loop.

The generated block touches exactly the four places that matter: wp_options for home and siteurl, wp_posts for guid and post_content, and wp_postmeta for meta values. The table prefix is configurable, because plenty of installs do not use the default wp_.

This is the situation you hit when pushing a site from localhost to hosting, when switching from a host temporary domain to the real one, or when moving a site from http to https.

What the generated SQL covers

  • Updates home and siteurl

    Fixes the two root options in wp_options - what WordPress uses to decide where it thinks it lives.

  • Rewrites URLs inside post content

    Scans post_content on every post and page, replacing links and image paths that still point at the old domain.

  • Fixes post guids

    Updates the guid column so backups and import/export tools stop referencing the old domain.

  • Sweeps the meta table

    Replaces URLs in wp_postmeta, which is where themes and page builders keep most of their configuration.

  • Custom table prefix

    Point it at your actual prefix instead of assuming the default wp_.

How to change a WordPress domain

  1. Back up the database first

    Export a full dump before running anything. UPDATE statements cannot be undone, and the backup is your only way back.

  2. Enter the old domain

    Type the address exactly as it is stored in the database, including http or https and with no trailing slash.

  3. Enter the new domain

    Type the destination address in the same format. If you are also moving to https, that is part of what gets replaced.

  4. Enter the table prefix

    The default is wp. Check $table_prefix in wp-config.php if you are not sure.

  5. Run the SQL block

    Copy the block, paste it into the SQL tab in phpMyAdmin or into the MySQL command line, and execute it.

  6. Clear caches and verify

    Flush plugin and CDN caches, then open a few posts to confirm images and internal links resolve.

WordPress domain change FAQ

Can running this SQL break my site?

The statements only swap the old domain string for the new one across four WordPress tables, but an UPDATE cannot be undone. Always export a database backup before you run it.

Why is updating home and siteurl not enough?

Because the old URL also lives inside post content, in post guids, and in theme and plugin meta fields. Change only those two options and the front page loads while images stay broken and internal links still point at the old domain.

Should the old domain include http or https?

Yes - enter it exactly as it is stored in the database. If you are moving from http to https at the same time, that prefix is precisely what needs replacing.

What if my table prefix is not wp_?

Enter your real prefix in the field and the tool generates the statements against those table names. The value is on the $table_prefix line in wp-config.php.

Is what I type sent anywhere?

No. The SQL is assembled in your browser; the tool makes no server call and keeps nothing you enter.

What should I do after running it?

Flush plugin and CDN caches, go to Settings > Permalinks and press Save to regenerate the rewrite rules, and check a few posts with images to confirm no old URLs remain.

Related tools

Commonly used together when migrating a site: