On Mon, 21 Aug 2006 08:16:19 +0200
"GamCo - Mail List" <maillist@???> wrote:
> Hi Dominic
>
> Thanks for the reply. Would you be able to point me to a guide on
> creating the flat files from the DB ?
A really simple script could just log into the database and create
files in the format you prefer. For example, using the Vexim database
layout, you could generate a file suitable for use with lsearch by
something similar to this:
mysql -s --skip-column-names -e 'select concat(localpart,"@",domains.domain,": ",smtp) from users,domains where users.domain_id=domains.domain_id' vexim > /etc/exim/user_table
Which will obviously depend on your particular database structure.
As others have said though, it does sound like you have other issues
without resorting to dumping to plain text files. How many queries per
second is the server processing? Are queries optimised and are indexes
placed in the correct places (EXPLAIN SELECT)?
