Question Get Subdomains Databases from CLI?

[safemoon]

Server operating system version

Ubuntu 20.04.6 LTS

Plesk version and microupdate number

18.0.60

Hi,

How can i get the database names from a subdomain? I noticed that the subdomain databases are assigned to the parent domains dom_id in the domains and data_bases tables.

in my shell script the following line returns always no results because the subdomains id is not the correct one, the data_bases table uses the parents domain id in the dom_id field.

# Function to get subdomains of a specific domain
get_subdomains() {
    local DOMAIN=$1
    plesk db -Ne "SELECT name FROM domains WHERE parentDomainId=(SELECT id FROM domains WHERE name='$DOMAIN')"
}
SUBDOMAINS=$(get_subdomains "$DOMAIN")
for SUBDOMAIN in $SUBDOMAINS; do
DB_NAMES=$(plesk db -Ne "SELECT name FROM data_bases WHERE dom_id=(SELECT id FROM domains WHERE name='$SUBDOMAIN')")
echo $DB_NAMES
done

 

[Kaspar@Plesk]

Database belong to a subscription, not to a particular domain. I don't think it's possible to match databases to a particular domain (unless the there is only the subscription domain).