DE

↑ ↓ select, Enter open, Esc close

Show the document root of all domains in Plesk

harmless rootPleskdebian, ubuntu
root@server
plesk db "SELECT d.name, h.www_root FROM domains d JOIN hosting h ON h.dom_id = d.id ORDER BY d.name"

Shows the full document root path for each domain. Useful because subdomains and additional domains are often not located in the expected httpdocs. Ideal before malware scans or scripts that should run across all websites.

Also searched as

  • where are the files of my domain plesk
  • find httpdocs path of a domain
  • find document root plesk

Related one-liners

All in Plesk

Check the Plesk database for inconsistencies

#plesk repair db -n
harmlessPlesk

Find the system user of each domain in Plesk

#plesk db "SELECT d.name, s.login FROM domains d JOIN hosting h ON h.dom_id = d.id JOIN sys_users s ON s.id = h.sys_user_id ORDER BY d.name"
harmlessPlesk

List all databases with their domain in Plesk

#plesk db "SELECT d.name AS domain, db.name AS datenbank, db.type FROM data_bases db JOIN domains d ON d.id = db.dom_id ORDER BY d.name, db.name"
harmlessPlesk

List all email addresses on a Plesk server

#plesk db "SELECT CONCAT(m.mail_name, '@', d.name) AS adresse, m.postbox FROM mail m JOIN domains d ON d.id = m.dom_id ORDER BY d.name, m.mail_name"
harmlessPlesk

Read hosting type and status of all domains from the Plesk database

#plesk db "SELECT name, htype, status FROM domains ORDER BY name"
harmlessPlesk

Back up a single domain with Plesk tools

#plesk bin pleskbackup --domains-name example.com --output-file=/root/backup-example.com.tar
cautionPlesk

Read first, then run.

The commands on myline.de act directly on servers, files and databases. A wrong path or placeholder can delete data irreversibly or make a server unreachable.

  • All commands are provided without warranty and are not tested on every system.
  • Understand what a command does before running it, and check every placeholder.
  • Make a backup first and, if possible, try it on a test system.
  • You run commands at your own risk. Liability for damages is excluded to the extent permitted by law.