How to copy prod database to test environment?

How to copy production database to test environment? I would like to test my website functionally, but for that I need the current database. I do not want to flip the database through phpmyadmin or temporarily change parameters, just after running the phpunit command, I want it to happen automatically.

In app/config/config_test.yml I have set up my test database.

But maybe this should not be tested? How do you deal with functional testing with testing things that depend on the database?