I'm doing some local testing and I was wondering if for backing up only one specific database it'd be enough to just keep a copy of that database's directory & files (from the xampp\mysql\data\ directory) and just restore that whenever I wanted to test with the original database contents again? Basically, I'm wondering if only copying the database files and overwriting all changed files with the original ones when I want to get the initial database contents back would work?
It'd save some time not having to dump and re-import the database every time, but I thought I'd ask here in case this wouldn't work for some reason.