Change IP address in DNS for all at once

Hello,

I have to migrate server to new provider and I will have new IPs.
Is possible by some way change all IP adresses at once?
For example in MySQL or by some script in zone files?

I have hundreds of DNS record with that IP address.


For example: I need change from IP 94.23.xx.xx to IP 87.52.xx.xx

Thank you very much.

 

Run this for each changed IP

Code:

UPDATE dbispconfig.dns_rr SET data = '87.52.xx.yy' WHERE dns_rr.data ='94.23.xx.yy';

Afterwards user the resync-tool for the dns-zones.

 

Thank you very much!

How can I run DNS reset tool - what is exact command?

 

tools -> resync

 

Ok, I understand now.

Thank you!