This WP-CLI plugin makes the process of moving sites from single WordPress sites to a Multisite instance (or vice-versa) much easier. It exports everything into a zip package which can be used to automatically import it within the desired Multisite installation.
MIT License
329
stars
47
forks
source link
MySql foreign keys: add CONSTRAINT and REFERENCES regex to search and replace db prefix list #56
The plugin doesn't correctly handle mysql foreign keys.
Adding this two regex fixes the problem (in a database.sql file we can find, for foreign keys, a line like this: CONSTRAINTwp_2251_ab_staff_services_ibfk_1FOREIGN KEY (staff_id) REFERENCESwp_2251_ab_staff(id) ON DELETE CASCADE ON UPDATE CASCADE,).
nicholasio
commented
6 years ago
The plugin doesn't correctly handle mysql foreign keys. Adding this two regex fixes the problem (in a database.sql file we can find, for foreign keys, a line like this:
CONSTRAINTwp_2251_ab_staff_services_ibfk_1FOREIGN KEY (staff_id) REFERENCESwp_2251_ab_staff(id) ON DELETE CASCADE ON UPDATE CASCADE,).