How to import individual mysql tables from a large dump?

Question

MySQL

there is a 42gb dump, I need to import several tables from it, since the deployed database takes about 200gb, if I import the entire database, the server will crash

Answer 1

try to pull the table out of the dump and then roll it into the database, it’s generally
good to switch to table-by- table dumps

Answer 2

Well, cut the dump into separate pieces in a table way.
If you are under linux, then grep + sed are your friends and helpers.
As an example solution
https://stackoverflow.com/questions/5683367/how-to...