If WP-CLI is available this plugin adds 2 new commands.
wp dbsnap
creates a snapshot of your database. No fuss, no muss…
wp dbsnapback
restores the snapshot. That simple…
If you need 2 different checkpoints you can name them
wp dbsnap db-before-i-do-something-sketchy
wp dbsnapback db-before-i-do-something-sketchy