How do I migrate a WordPress database?
Michael King
Updated on March 12, 2026
How do I migrate a WordPress database?
Here’s a quick step by step guide.
- Step 1: Install the plugin on the WordPress install you want to clone WordPress to.
- Step 2: Fill in the find and replace fields within WP Migrate DB.
- Step 3: Export the database.
- Step 4: Import the database into your new site.
Can you export WordPress database?
WordPress databases can be exported through phpMyAdmin. WordPress uses PHP to access, change and store data. During installation, WordPress asks you to provide host, username, password, and database name, which is stored in wp-config.
How do I move contents from one WordPress site to another?
How to Migrate Your WordPress Site Manually
- Step 1: Choose a New WordPress Host.
- Step 2: Back Up Your Site’s Files.
- Step 3: Back Up Your WordPress Database.
- Step 4: Export Your WordPress Database.
- Step 5: Create a New SQL Database and Import the Contents of Your Old One.
- Step 6: Upload Your Site’s Files to the New Web Host.
How do I sync my WordPress database?
To sync the database, follow these steps:
- Install the WordPress plugin, Database Sync.
- In the Live site, go to Tools > Database Sync.
- Add the token in the Tools > Database Sync of the Local stage site.
- Click the Sync button to start synchronizing these two sites.
How do I migrate a database?
In order to migrate the database, there are two steps:
- Step One—Perform a MySQL Dump. Before transferring the database file to the new VPS, we first need to back it up on the original virtual server by using the mysqldump command.
- Step Two—Copy the Database. SCP helps you copy the database.
- Step Three—Import the Database.
Is BackupBuddy free?
All current BackupBuddy, Plugin Suite and Toolkit customers will find the BackupBuddy 8.0 update available now for free. There are 3 easy ways to update: From the WordPress dashboard (for licensed sites) – Update BackupBuddy directly from the WordPress > Updates page in your WordPress dashboard.
How do I export my local WordPress database?
Export Local WordPress Database Simply go to and click on your WordPress database. Next, click on the ‘Export’ button from the top menu bar. In the ‘Export method:’ option, you can choose ‘Quick’ or ‘Custom’. Custom will provide you with more options to export your database.
How do I export my WordPress database to excel?
To export WordPress data to CSV, Excel, or XML, go to WP All Export › New Export and select the type of data you’d like to export….How to Export WordPress to CSV, Excel, and XML
- Step 1: Select a WordPress Post Type to Export.
- Step 2: Customize Your WordPress CSV/XML Export.
- Step 3: Confirm and Run Your Export.
How do I transfer a WordPress site from one domain to another?
There are three steps:
- Register the new domain name and point it at your site.
- Configure the WordPress settings to use the new domain name.
- Edit the database or set up redirects so that internal links to your old domain name are replaced by links to the new one.
How do I move a WordPress site without plugins?
Transfer WordPress Website Without Plugins
- Now reload the page and download the “wp-admin. zip” folder.
- Go back to the cPanel, select phpMyAdmin and click on “Export”.
- Choose “Custom” as the export method, then select your database and scroll below to hit the go button.
What is WP merge?
WPMerge is a tool in your development workflow and needs be installed and activated before you make changes to your dev site. Your dev site needs to be a fresh clone of production before you start.
How do I move my WordPress site to staging?
Moving a Managed WordPress site from staging to production in 5…
- Pull your production site to the staging environment.
- Configure, develop and test your staging site.
- Import new content into the staging site.
- Push your staging site to production.
- Test the production site.