How to quickly test on a production database?

Question

MySQL

I develop locally, but after that I need to test on data from a real database. I have to dump it, transfer it to my server, and then deploy it on my own. And then it happens to impose more migrations. All this takes 15-20 minutes, and sometimes I quickly damage the data in the database and need to repeat everything again. The database weighs 1.5GB and is not going to decrease.
I thought about making a master slave and immediately switching to the slave, but if I mess up the base, then I have to wait until the slave pulls everything up again.
How can I instantly switch to a production database copy?

Answer 1

Cannot be tested on a live database. Generally it is impossible.