How to deploy a project from an existing MySQL database?

Question

MySQL

Hello!
There is a PROM database MySQL, there is a test database sqllite3. There was an idea to use MySQL on a test server, deploying it from a PROM database backup.
To do this:
I took a backup from the prom database;
installed MariaDB on a test server;
created an empty database;
exported a dump file there;
The site has started, but not all pages open, when I try to open several pages or when I try to create a superuser, I get errors like (1054, "Unknown column '' in 'field list'")
Maybe I'm doing something wrong and there are other ways to achieve the goal, for example, to create an empty database, roll all the migrations and then somehow export the data from the current database?

Answer 1

The documentation has a whole section dedicated to this - Integrating Django with a legacy database