MyBB Community Forums

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"

Hmmm 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.

(2012-11-21, 08:02 PM)niere8 Wrote: [ -> ]I don't have old database on a forum, I have only file "backup_4etcetcetcetc.sql.gz"

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.