- Plesk Onyx for Windows
It is required to change IP address in A records for a bunch of domains in Plesk database.
How to perform mass update for DNS queries in Plesk database?
For example it is required to change IP address in A records for all the domains with the name starting with "mssql.".
Log in to Plesk server using RDP.
Make a backup of Plesk database:
C:\> plesk db dump psa > C:\psa_dump.sql
Access Plesk database.
Execute the following query:
MYSQL_WIN: update dns_recs set val='203.0.113.2', displayVal='203.0.113.2' where type="A" and host like 'mssql.%' and val='203.0.113.3';
To apply the changes execute the following command:
C:\> plesk repair dns