• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

Question Get Subdomains Databases from CLI?

safemoon

Basic Pleskian
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.

Code:
# 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
 
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).
 
Back
Top