How to Use the WordPress Migration Query Tool
This tool is intended to help you change a domain in WordPress database in a matter of minutes. All you need to do is to provide:
- previous website domain,
- new website domain,
- the database prefix which is in use for your WordPress installation.
After that – generate the migration query and run it in your WordPress database.
If you faced any difficulties moving your WordPress site from one domain to another, or just want to make sure that everything is configured nice and safe for SEO, or maybe you need any kind of custom development, me and my team are here for you.
How to use SQL generator tool for WordPress Multisite
You can use this tool for websites with WordPress multisite network installed, though you will need to keep some things in mind:
- You need to generate and run the SQL queries for every subsite separately, just provide the database prefix for a subsite like
wp_2_,wp_3_etc. - There are also some tables where you will need to change the domain maually, the tables are:
wp_blogs,wp_siteandwp_sitemeta, more about multisite SQL queries you can read in this tutorial.
How to Run SQL Query in WordPress
In order to change WordPress URL in MySQL database we need to run the queries we generated before for this specific database.
First thing first, you need to open a database you need, preferably in phpMyAdmin tool, you can find it in your hosting panel, but depending on the hosting you’re using it can be in different places.
Then just select a database and run our WordPress migration query on the “SQL” tab:
This was the easiest tool I’ve ever used. You deserve way more props. This saved me like 10 minutes.
Thank you! I am glad it helped you!
This is sick! Thank you 🤘🏽
I spent a few hours trying to find the snippet I saved before I found your tool. Thank you so much for this!
You’re welcome!
Yes, but that doesn’t modify all the rows that have serialized data. That’s the big problem.
I don’t think it can be achieved with an SQL request though ;)
Thank you so much for this. Save so much time.