<div>
mysqldump's export file can be simply put into mysql command line:<br />
mysql [connnection options] &nbsp;&lt; mysqldumpfile.dmp<br />
<br />
there is nothing AFAIK from mysql directly to generate files for mysqlimport as such.
</div>


mysqldump's export file can be simply put into mysql command line:
mysql [connnection options]  < mysqldumpfile.dmp

there is nothing AFAIK from mysql directly to generate files for mysqlimport as such.

<div>
I'm not interested in using mysqldump. I already know how to export/import via that utility. I wish to know how to export/import using the mysqlimport utility. Specifically, how do I export data that can be imported via mysqlimport?
</div>


I'm not interested in using mysqldump. I already know how to export/import via that utility. I wish to know how to export/import using the mysqlimport utility. Specifically, how do I export data that can be imported via mysqlimport?

<div>
That's exactly what I needed to know. Thanks!
</div>


That's exactly what I needed to know. Thanks!

<div>
<div class="content wysiwyg-content">
How do you create files to import to mysqlimport? mysqldump create SQL of a given table/db, but mysqlimport needs some other form of data. How can I export from the mysql command-line in a format that can then be imported using mysqlimport?<br />
<br />
Thanks,<br />
Dan
</div>
</div>


How do you create files to import to mysqlimport? mysqldump create SQL of a given table/db, but mysqlimport needs some other form of data. How can I export from the mysql command-line in a format that can then be imported using mysqlimport?

Thanks,
Dan

Opposite of mysqlimport

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.