Just took a few seconds to alter NS-record with mysql, but....

[Frater]

I had to do a bulk change for NS-servers because it would have been a lot of work.
I did this:

mysql> update dns_recs set val='ns6.xxxx.nl.' where val='ns2.xxxx.net.' and type='NS';
Query OK, 128 rows affected (0.05 sec)
Rows matched: 128  Changed: 128  Warnings: 0

mysql> update dns_recs set displayVal='ns6.xxxx.nl.' where displayVal='ns2.xxxx.net.' and type='NS';
Query OK, 128 rows affected (0.46 sec)
Rows matched: 128  Changed: 128  Warnings: 0

But now I'm trying to find the proper command in Plesk 12 to apply this.
I think I need this:

# /usr/local/psa/bin/repair
Usage: repair.sh command [options]

No way it is giving me any direction when I try something....

 

[IgorG]

# for i in `mysql -uadmin -p\`cat /etc/psa/.psa.shadow\` psa -Ns -e "select name from domains"`; do /usr/local/psa/admin/sbin/dnsmng --update $i; done

 

[Frater]

In the end I did this:

#/bin/sh

mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -sNe "select name from dns_zone;" > /root/domains_list

while read domain ; do
  /usr/local/psa/admin/bin/dnsmng --update $domain
done < /root/domains_list

 

[Frater]

Thanks....