MyBB Community Forums

Full Version: No answer?... Export then Import 'mybb_banned' to and make work at new /forum ?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
.
After export 'mybb_banned' from one database and import to another, does not show additional '# of Users' at ACP>Home/UserGroups, but shows list at ACP>Home>Banning,  but doesnt show 'User' names on the list... shows only "Banned by akm on mm-dd-yyy permanently" for all (2500) imported user names [update, attached scrnshot].
Import error, or ACP setup problem, or... ?

[update]
Also tried to register one of the 'imported' banned users (from the original /forum with same name/email) at the new /forum, and nothing stopped the registration process.
The previously (at original /forum) banned user was right there (at ACP) for the admin to activate.
.
Any chance of an answer to this question ?
Or, another place/way to ask ?
Confused
Hi,

The banned table points to the users table, so you would need to export the users table too. However, you'll likely only want the banned users, so you'd need to export only those users.

You could get a list of all of these users using a query like the following:

SELECT * FROM `mybb_users` u WHERE u.uid IN (SELECT uid FROM `mybb_banned`);

If you run this query in phpMyAdmin, you can export the users from the results. Doing so may cause conflicts with user IDs if you already have any users on the new board though.