Hundred of Thousands of database records and how to safely delete them?
Forget about accessing the database manually, you will just break things.

For mass-deletion create a VBO-based view.

Same thing for export, you will want to export whole entities, not tables.