What Drupal tables to export from broken site
Not at the database table level, no.  There's a contributed module in Drupal called "Features" that lets you export content types, fields, views and some other configuration into a custom created module, but you would need a functioning site to begin using it.