12 March 2008

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


Google

My Blog List