Skip to content

Instantly share code, notes, and snippets.

@dotherightthing

dotherightthing/extracting-a-single-site-from-a-multisite-database.md

Created August 15, 2019 14:43
Show Gist options
  • Save dotherightthing/5be1ba6f8fa4877a5a0041b2b722895f to your computer and use it in GitHub Desktop.
Save dotherightthing/5be1ba6f8fa4877a5a0041b2b722895f to your computer and use it in GitHub Desktop.
Download ZIP
[Extracting a single site from a multisite database] #wordpress
Raw
extracting-a-single-site-from-a-multisite-database.md

Extracting a single site from a multisite database

  1. This is not possible using UpdraftPlus.
  2. Go into SequelPro, locate the tables used by the subsite, Export as SQL
  3. Open the SQL file in a text editor
  4. Find & Replace the table prefix as necessary, to match the single site's wp-config ($table_prefix)
  5. Create a new WordPress site for the standalone single site
  6. Go into SequelPro, File > Import: The SQL file
  7. Also in SequelPro, under the “option_name” column header, change “wp_user_roles” to “YOUR_PREFIX_user_roles“. This fixes the error "Sorry, you are not allowed to access this page" when you visist /wp-admin (https://www.naijatechzone.com/wp-admin-login-error-sorry-you-are-not-allowed-to-access-this-page/)
  8. Use https://interconnectit.com/products/search-and-replace-for-wordpress-databases/ to replace YOUR_OLD_DOMAIN_NAME with YOUR_NEW_DOMAIN_NAME
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment