I would like to move users from one forum to another, but only saving their reputations, passwords and logins ofc, any idea how to do it?
Backup only the mybb_users table.
I've done this, but in old forums, I'm using some plugins with additional user tables, like myps etc, so I want to import only passwords and reputation, leaving all the rest as default
Delete those fields then.
delete them in the backup?, so leaving for example:
INSERT INTO `mybb_users` (`uid`, `username`, `password`, `salt`, `loginkey`, `email`)
and then just insert users properties?
Can't you just copy the whole table and then delete the extra fields in the copy?
have around 2000 users, would be difficult to delete their fields separately
You don't need to delete them separately. You can run an SQL query such as:
ALTER TABLE `mybb_users` DROP COLUMN `example`;
would this delete the table or what's in the table?
The column that's in the table, obviously.
I wouldn't give you an SQL query to delete the whole table...