Mass ftp backup editing?

[klyde]

Hello,

I have thousands of domains on my plesk and I need to change the FTP backup setting for each of them because I have change the backup server.

Is there a way to change for all my domains, in 1 time for the backup, the address + login + pass + folder?

Because it's the same for all domains.

Thanks

 

[Monica@]

Hi.

Plesk stores all the configuration in the database. The ftp backup configuration is written in the table BackupsSettings.
Enter the Plesk database with
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

View the contents of BackupsSettings table. In the column "value" you will see the current ftp server, the username and password. From there I believe it is possible to change this settings by a mysql query. For the syntax it's better to see the MySQL reference guide.