Is it possible to form an SQL query from the data in the table?

Question

MySQL

The point is. There is a DB. it has 3 tables. At 42, 11 and 106 lines. they are connected. I want to recreate the database, but I don't want to lose data. And re-drive buzz zero. Is it possible to do something so that a large SQL query (or several queries) will be generated to fill similar tables with current data in a new database? I've tried exporting to see what happens. But the app is crashing.

Answer 1

If the table is transferred one-to-one, then mysqldump.
If any transformations are needed, then SELECT ... INTO OUTFILE / LOAD DATA INFILE

Answer 2

This can be done in a bunch of different ways.