<div>
Thanks a lot. How to import this generated file into local MySQL database.
</div>


Thanks a lot. How to import this generated file into local MySQL database.

<div>
<div class="content wysiwyg-content">
Hi: There!<br />
<br />
I have an urgent question related to MySQL, I have a table in Production database. It has millions recodes since it is history table. But at this moment, I only need part of the table. I make a SQL query. How to export/dump this query result so that I could put recodes/rows into local development environment for debug?
</div>
</div>


Hi: There!

I have an urgent question related to MySQL, I have a table in Production database. It has millions recodes since it is history table. But at this moment, I only need part of the table. I make a SQL query. How to export/dump this query result so that I could put recodes/rows into local development environment for debug?

export part of table from production to local DB (MySQL)

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.