MyBB Community Forums

I have many old backups of my website which are not labelled by date and I wish to figure out when, or close to when, the backups were taken. I have full SQL dumps and am wondering if anyone knows a decent way of pulling out the most recent date out of the jumble of SQL Statements and show me when the forum was last used (as far as I know MyBB seems to log everything so the chances are a date should exist somewhere).

And yea, I know that I should have labelled backups.

Look at the timestamps on the posts. Then use this: http://www.onlineconversion.com/unix_time.htm

What's the best way to do that? Import the database into MySQL and then sort the field with PHPMyAdmin? Any better ways?

Thanks for the quick reply!

Yeah importing it is usually the easiest way to look at it

If it's backups generated by MyBB itself, the date should be in the first three lines of the dump:

-- MyBB Database Backup
-- Generated: 17th March 2009 at 15:28
-- -------------------------------------

That's a point
PHPMyAdmin dumps have that too.

Thanks for the advice guys, it worked!