Update TTL value of all domains in windows Plesk server

MAKE SURE TO TAKE THE BACKUP OF 'psa' DATABASE.

Start > run >cmd

cd %plesk_bin%
C:\Program Files\SWsoft\Plesk\admin\bin\cd ..
C:\Program Files\SWsoft\Plesk\admin\cd ..
C:\Program Files\SWsoft\Plesk\cd MySQL\bin

C:\Program Files\SWsoft\Plesk\MySQL\bin\


C:\Program Files\SWsoft\Plesk\MySQL\bin>mysql -uadmin -p -P8306
Enter password: ***********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1817 to server version: 4.1.22-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use psa;
Database changed

mysql> desc dns_zone;
+---------------+------------------------------------+------+-----+-------------
--+----------------+
| Field | Type | Null | Key | Default
| Extra |
+---------------+------------------------------------+------+-----+-------------
--+----------------+
| id | int(10) unsigned | | PRI | NULL
| auto_increment |
| name | varchar(255) | | |
| |
| displayName | varchar(255) | | |
| |
| email | varchar(255) | YES | | NULL
| |
| status | int(10) unsigned | | | 0
| |
| type | enum('slave','master') | | | master
| |
| ttl | int(10) unsigned | | | 86400
| |
| ttl_unit | int(10) unsigned | | | 1
| |
| refresh | int(10) unsigned | | | 10800
| |
| refresh_unit | int(10) unsigned | | | 1
| |
| retry | int(10) unsigned | | | 3600
| |
| retry_unit | int(10) unsigned | | | 1
| |
| expire | int(10) unsigned | | | 604800
| |
| expire_unit | int(10) unsigned | | | 1
| |
| minimum | int(10) unsigned | | | 86400
| |
| minimum_unit | int(10) unsigned | | | 1
| |
| serial_format | enum('UNIXTIMESTAMP','YYYYMMDDNN') | | | UNIXTIMESTAM
P | |
| serial | varchar(12) | | | 0
| |
+---------------+------------------------------------+------+-----+-------------
--+----------------+
18 rows in set (0.00 sec)


mysql> update dns_zone set ttl="180" where ttl="86400";

Query OK, 55 rows affected (0.05 sec)
Rows matched: 55 Changed: 55 Warnings: 0

mysql> update dns_zone set ttl_unit="180" where ttl_unit="86400";


Query OK, 32 rows affected (0.03 sec)
Rows matched: 32 Changed: 32 Warnings: 0

mysql> select ttl from dns_zone;

finally Run
----------------

C:\Program Files\SWsoft\Plesk\admin\bin>"%plesk_bin%\dnsmng" update *



Also please go thru the following link.

http://kb.parallels.com/en/1114

Please run the query given in the link only after describing the table. DO NOT BLINDLY APPLY THE QUERY GIVEN IN LINK.

MAKE SURE TO TAKE THE BACKUP OF 'psa' DATABASE.