How to perform a partial data import of a specific project from a MySQL production database?

Question

MySQL

In the production database, there is a certain project (projects table), from which, in order to conduct tests, you need to copy the real analytical data associated with it. There are more than 7 interrelated tables.
The test environment has its own projects and data. In an empty project, you need to create data from production, maintaining relationships between tables.
Which import methods are applicable in this case?

Answer 1

I'll answer how I solved the problem:
Studying the solutions took half a working day. Another 1 working day was spent on writing the program and debugging.

Answer 2

go to phpMyAdmin, export the database, then import it into another. If this method does not work, please describe why.