What is the recommended approach to populating a DB schema for running integration tests?

[Joshua Stringfellow]

Bitbucket Pipelines recommends using services like mysql for testing, etc.

Is there a straightforward way of importing a schema and/or data into a mysql service?

Typically you can provide a shell or sql script in the `/docker-entrypoint-initdb.d` folder and the mysql container will run that on startup, setting up the DB.

I can't see a straightforward way of doing that with Bitbucket Pipelines, am I missing something?

If not, what is the expected approach for populating the database, DIY?