The mysql database schema in dnsadmin makes that possible with an sql query.
update records set val='new ip' where val='old ip' and type=M; Which means: For any MX record that is currently using 'old ip' change it to use 'new ip' You can also update just one domain select domain_id from domains where domain='my domain'; update records set val='new ip' where domain_id='the id from above' and type='M' Then the dnsdata program will output the MySQL dns information to tinydns data format. Or use dnszone to output to bind zone format (note: you'll need to modify some hard coded values in dnszone). Ken Jones On Wednesday 16 July 2003 10:14 pm, Alan Murrell wrote: > Hello, > > I couldn't find an archive list, nor the answer to > this in the FAQ. > > I very much like the idea of having the DNS records > kept in a MySQL database, but I am not sure if my > reason for doing so would work. > > If the data is kept in the database, as well as the > zone files, could I make the changes directly in the > database, and then have them show up in the zone > files? > > For example, if I have many domains with their MX > pointing to a specific IP address, and that IP address > changes, it's a pain to change each individual zone > file (yes, I know I could probably whip up a shell > script that makes the replacements via 'sed'). > However, the changes would be easier if I could make > an SQL query that would change all occurrances of the > MX IP address from the old to the new. > > Any thoughts? Comments? > > TIA. > > Alan Murrell <[EMAIL PROTECTED]> > > ______________________________________________________________________ > Post your free ad now! http://personals.yahoo.ca
