I am in the process of reviving the site. I basically put a fresh install on. I have all the associated files. One big mistake I made previously is with one of the security modules. It somehow managed to rename all my tables to 'a0384_' instead of the 'wp_', which sucks! I am unsure what to apart from rename all my tables. It's important that I import my database as the site had quite a few pages.
In terms of the plug-ins and tables, when you import a database with it's tables, do the tables associated with the plug-in automatically detect, if that made sense.
PS: I have backups of the entire site, theme, and DB