Below are various solutions that may help when working with large network sites.
Filtering large sets of tables are not working properly. Not all of the tables are being filtered.
How can I export only users with roles for current website?
The table wp_users is exported and users have to manually be removed
Option 2The second solution involves following these steps:
- Filter the user table and use_meta when creating the package
- Export users and usermeta with a specific query
- Import users and usermeta tables into new database manually
- Run the installation and select as database action “Connect and Do Nothing (Advanced)”.