How do you deploy the database?

Question

PHP

Describe how you deploy the database.
1. If the structure has not changed and only new data is rolled out.
2. If yes, the structure has changed. (UPD: In this case, migrations will be used first, I understand that, but how will the data itself arrive at the combat base?)
Or criticize my today's approach.
home project. Figachi in one face, in PHP.
I do it by hand now. I dump the QA database, upload this dump to the database that staging uses, if everything went well, in the nginx config I swap staging and prod, so that staging becomes production, and production becomes staging.
I want to automate this process.

Answer 1

https://www.google.com/search?q=php+db+migrations

Answer 2

Migrations if you use a framework