What can we do to increase security and prevent Bitcointalk suffering something similar in future?
Don't post anything sensitive here, and I mean "private" parts of the site as well, like your PMs or your e-mail address or anything like that. Keep in mind that deleted posts and PMs may not be actually deleted from the database.
And trust that theymos has a reasonably recent backup to recover the site, which he probably does.