Skip to content

Instantly share code, notes, and snippets.

@austinginder

austinginder/mutlisite-to-single.sql

Last active April 11, 2017 22:46
Show Gist options
  • Save austinginder/a54ec0d9d64159fb4edd to your computer and use it in GitHub Desktop.
Save austinginder/a54ec0d9d64159fb4edd to your computer and use it in GitHub Desktop.
Download ZIP
Multisite export to single install
Raw
mutlisite-to-single.sql
# Delete all orphans user meta in WordPress
DELETE FROM wp_usermeta
WHERE NOT EXISTS (
SELECT * FROM wp_users
WHERE wp_usermeta.user_id = wp_users.ID
);
# Remove multisite only columns in users
alter table wp_users drop column spam;
alter table wp_users drop column deleted;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment