Hari Keselamatan ICT - OWASP Day Kuala Lumpur Malaysia 2011

Output Mysql select To File

I need this MySQL sql select command so that I can dump the select command into a file. This command is used by myself for migrating Dbmail users inside MySQL to OpenLDAP.

mysql

mysql> use dbmail;
mysql> select * into outfile "/tmp/dbmailusers.txt" from dbmail_users;

More examples :-

http://www.tech-recipes.com/mysql_tips1475.html


Popular Posts