Restore deleted user

by Simba   Last Updated February 22, 2018 14:10 PM

I have a Joomla system (v3.8) which is running well.

Unfortunately, however, one of our administrator user record has accidentally been deleted. I need to restore it because we're now getting errors on pages on the site stating that this userID is missing, so there is obviously some cross-linked data that references it; probably the owner/creator of various content records. The user should have been deactivated rather than being deleted.

I have backups, but other DB changes have occurred in the interim that I don't want to lose, so I don't want to just restore the whole thing.

I've got a backed up copy up and running on a test box, and the user record is there, so it hasn't been lost.

What is the best way to go about restoring the record? Can I just grab the record from MySQL in the backup system and insert it verbatim back into live? Will this work? Is there any other linked data that I will need to restore as well?

Also, is there any way for me to prevent this mistake from happening again? We already had it in our user guide that user accounts should be deactivated and not deleted, but that was obviously ignored; is there a way to enforce it in Joomla not to delete users?

Related Questions

Admin interface menu not showing

Updated June 21, 2017 09:10 AM

making component,data not saving

Updated November 14, 2017 00:10 AM

Adding Multiple Users in Joomla

Updated February 20, 2016 01:04 AM