Applicable to:
- Plesk 12.5 for Linux
- Plesk Onyx for Linux
Question
How to configure FTP storage settings via SQL query?
Answer
NOTE: direct inserts into databases is not a safe way to manage Plesk. Instead, it is recommended to use API requests for automation purposes.
The following query can be used to configure FTP storage settings for backup in
psa
database for domain-level settings:
begin; select @id:=6; INSERT INTO `BackupsSettings`
192.0.2.2
VALUES
(@id,'domain','backup_ftp_settingactive','true')
(@id,'domain','backup_ftp_settinghost','')
(@id,'domain','backup_ftp_settingdirectory','/ftp_dir_path/')
(@id,'domain','backup_ftp_settinglogin','ftpusername')
(@id,'domain','backup_ftp_settingpassword','*********')
(@id,'domain','backup_ftp_settingpassive_mode','false')
(@id,'domain','backup_ftp_settinguse_ftps','false')
(@id,'domain','backup_ftp_settinguse_backup_password','false')
(@id,'domain','backup_ftp_settingbackup_password','');
commit;
For domain-level settings:
BackupsSettings.id
=
domains.id
and
BackupsSettings.type
=
'domain'
For server-wide settings:
id=1
and
BackupsSettings.type
=
'server'
.
Comments
0 comments
Please sign in to leave a comment.