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

Openldap with Mysql Backend

Spending my whole day trying to configure Openldap with Mysql as the backend. Stuck with numbers of configuration examples that each have it's own way and then around this hour (0020), while casual searching with Google, at the bottom of the Google search page. I found this link.

http://www.flatmtn.com/article/setting-ldap-back-sql

Detail explanation what need to be done, what to configure and how to do it.


Moral of the story. After 1730 is not a good time to do configuration, after whole day looking at the configuration files and eating a lot of kuaci, you mind blur already. Better go home, go for jogging, take a bath and doing nothing.