#7 Suggest InnoDB for MySQL

[Klaus M. Brantl]

Hi,

if you use the mydnsimport-utility on a regular basis (even if you shouldn't) the SQL-DELETE could lead to improper DNS-responses.
The cheapest solution we've come up was a small patch on the import.c to disable autocommit.
Problem is: you need to have InnoDB running. That said, I suggest
const char *mydns_dbengine = "InnoDB";
in conf.c.
Most MySQL-Setups I know just ignore InnoDB and work with MyISAM on the creating-process. And the change of autocommit won't harm ether.

So the only part we haven't tested is if the patch harms the PostgreSQL-Setup - maybe someone'll add some conditions here too.

kind regards
Klaus

[Klaus M. Brantl]

against current trunk-version import.c