I have a running site (Site A).
I want to re-write the site fully to improve everything but, when I’m finished, I don’t want to have to get everyone to sign up to the new site.
I wondered if I could create an entirely new site on a different domain (Site B) with a clean install of WordPress – and then when I’m finished developing the site copy over the following tables from Site A to Site B:
wp_options
wp_users
wp_usermeta
And would all my existing users then have full access to Site B (the new site) ?
Or is there more to it than this?
Thanks
3 Answers
Migrate DB Pro can help with this, make sure to migrate any plugin tables and the WP_Users and WP_Usermeta tables if your users make posts and you want that content to remain assigned an available make sure to keep WP_Posts and WP_Postmeta table as well.
Also keep in mind that WP uses an EAV (Entity Attribute Value) architecture for pretty much everything User and Content related so if you have a ton of users it will take time or possibly crash.
I run a site with 100K registered users and I have no problems with this process using MigrateDBPro but I know that larger sites would have problems.