Change domain expiration date for all domains

[BankHoliday]

Hello,

Is there a way to change the domain expiry date for all domains at once.
I know how to do it one domain at a time but I have many domains.

I just want to eset them all to expire never.

Any help would be gratefully appreciated.

Thanks BH

 

[IgorG]

You can do it with something like

for i in `mysql -uadmin -p\`cat /etc/psa/.psa.shadow\` psa -Ns -e "select name from domains"`; do /usr/local/psa/bin/domain_pref -u $i -expiration -1;done

 

[BankHoliday]

Thanks IgorG, that worked a treat.
Your help is much appreciated.
B