On Mon, 21 Aug 2006 08:16:19 +0200 "GamCo - Mail List" <[EMAIL PROTECTED]> 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)? -- Dominic Cleal [EMAIL PROTECTED] -- ## List details at http://www.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://www.exim.org/eximwiki/
