How to take a small snapshot of the database (MySQL) from the combat server?

Question

MySQL

DD.
There is a combat server with 20-30 tables and GB of data in them, some tables have 300-400 thousand records.
You need to raise the site on the local with more or less up-to-date data. Those. for example:
SELECT * FROM all_tables ORDER BY `id` DESC LIMIT $limit
Is there any ready-made solution where you can specify database access, record limits, and which script will look at what tables there are and dump from all tables by $limit - records?

Answer 1

mysqldump, here is an example for your task
stackoverflow.com/questions/135835/limiting-the-nu... -