MyBB Community Forums

Full Version: Find signature of an user in an old database backup?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi, I cancelled signature of an user, how can I find this signature in old database backup? Is it possible? thank you
You can find some user in database under mybb_users, and then take a look in his signature when you click on edit that user.
I don't have old database on a forum, I have only file "backup_4etcetcetcetc.sql.gz" Sad
Hmmm Smile You can make on localhost forum and import that database into that forum and get it. Or make online forum and do the same thing.
(11-21-2012, 08:02 PM)niere8 Wrote: [ -> ]I don't have old database on a forum, I have only file "backup_4etcetcetcetc.sql.gz" Sad

Then unzip it and open the sql file and search for that particular user and his/her signature. Or restore the backup at a new db and then find the signature with this query:

SELECT signature FROM mybb_users WHERE uid = x;

And replace x with the id of that user. Or search for the username if you remember that more than his/her id.