UpdraftPlus adds the ability to migrate WooCommerce database constraints
Better migration for WooCommerce stores
Section titled Better migration for WooCommerce storesWith UpdraftPlus Migrator, you can clone or migrate your entire website to a different URL in just a few minutes.
Users who use Updraft Migrator to transfer sites that include a WooCommerce store have found in the past that there have been some issues with database constraints (relationships between database tables and how they work with each other). This resulted in the database tables not being updated if the database table prefix was changed between the old and new sites.
These issues resulted in users having problems with file downloads. If a user had a WooCommerce business that featured a digital download product (such as a song or plugin for example) and migrated their site to a new location with a change to the database table prefix (the bit before the table name, which defaults to wp_
), these downloads stopped working due to the relationships between the product and the digital files being broken
Updraft Migrator has taken steps to fix this problem by looking through the database before it is imported. If Migrator finds any relationships using the old table name prefix, it makes sure the relationship is able to work with the new table name prefix. As well as WooCommerce, this feature was designed to work for any plugin table or custom table.
As a result, we believe UpdraftPlus is first backup plugin (find out how to backup your site here) to offer this ability to migrate Woo database constraints.
Get Migrator by upgrading to UpdraftPlus Premium today.
About the author

TeamUpdraft
Our team consists of WordPress developers, marketers, and industry experts committed to providing you with the resources and skills you need to succeed online. Whether you’re just starting out or seeking advanced strategies, we’re here to enhance your WordPress journey and support you at every stage.
Categories
UpdraftPlus
Get all our premium features. Direct site-to-site migration, incremental backups, back up automatically before updates and a whole lot more.
From just $70 for the year.
More stories
-
IDrive now supported in UpdraftPlus as S3 storage
UpdraftPlus now supports IDrive as an S3-compatible backup storage option. Discover what this means and why IDrive is a great storage option.
-
WP-Optimize release v4.2.3: Power up your site’s performance with key fixes and tweaks
Learn what’s new in WP-Optimize 4.2.3, including caching and image fixes.
-
TeamUpdraft joins the Codeable Partners Network
We’ve joined the Codeable Partners Network- learn what this means for our users.
-
MEGA now supported in UpdraftPlus as S3 storage
UpdraftPlus now supports MEGA as an S3-compatible backup storage option. Discover what this means and why MEGA is a great new choice.