accidentally deleted an admin user

navindra

Hi, I was trying to delete a test post as an admin user but instead I deleted the admin user itself by accident.

Is there a way to restore a deleted user? I do have another admin user.

Thank you!

clarkwinkelmann

There is no restore feature in Flarum.

If you have a database backup, you could restore it.

You can create a new admin user with the same name, though Flarum doesn't have any way to re-assign their old remaining posts to them (Author Change extension could be used to manually re-assign some posts).

navindra

clarkwinkelmann Thanks! If I go the restore route, could I restore just the user and not impact any of the other data? Would I only need to restore the row in the users table?

Posts have a "Delete forever" feature, would have been nice if user deletion had the same protection.

clarkwinkelmann

navindra unless you have some advanced MySQL tools, this will be tricky.

If you delete only the users table and restore a new version on top, you need to make sure to disable integrity constraints during the operation or MySQL will delete a lot of other records from other tables and those will be lost.

And just restoring the users (even manually re-creating the rows in the database) won't fix the relation between users and posts, if you want to restore those as well, you will almost certainly need to restore the entire database.

You could manually re-create the user and manually re-assign posts to the user, either with the same user ID as before or a new ID, it doesn't really matter at that point because the integrity constraints will have removed all traces of the old ID from the database.

navindra

clarkwinkelmann Exactly the information I needed, thank you very much for the detailed answer!