• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Exporting Dedicated IP in custom format

A

alex.bumbacea

Guest
Hello,

Few days ago i needed to get all dedicated ips and the domains assigned to it in a custom format. I tried to make the connections in the pas db, but i wasn't able to print the dedicated ips with multiple domains on them since ip_addresses.default_domain_id is 0 for that ones. Could you please provide help in this matter?

Thank you,

Alexandru Bumbacea
 
For to tell. This is the task i run under mysql

SELECT name, ip_address FROM domains
INNER JOIN ip_addresses ON
ip_addresses.default_domain_id=domains.id
WHERE type='exclusive'
LIMIT 0, 10;
 
Back
Top