I currently use the PHPUnit class methods setUp() and tearDown() for that.
Create and add test data in the setup, and drop the table in the teardown. Unit tests run in the 'test' environment, so you can give it its own db.php defining a test database to use.