list all databases associated with a reseller !!

furquan · Aug 23, 2010

Hello All :

I have a requirement from a reseller and he needs to know all the DB's associated with all his hosted accounts. he has some 100 account and i cannot go browsing each panel for the info.

How is it possible to get it via CLI or any available script ?

Any assistance please !!!

sirdopes · Aug 24, 2010

This can easily be done in bash. I am sure there are better ways but I would use something like the following:

for i in `grep OWNER=owername /var/cpanel/users/* -l | cut -d '/' -f 5`; do ls /var/lib/mysql/ | grep $i_ ; done

That should print out a list of all of the databases assuming that you are not using the new cpanel feature where the databases do not start with the user_.

furquan · Aug 24, 2010

Thanks sirdopes :

I'll have this run and will see how it goes

Forums

The Community Forums

Interact with an entire community of cPanel & WHM users!

list all databases associated with a reseller !!

furquan Well-Known Member

sirdopes Well-Known Member
PartnerNOC

furquan Well-Known Member

List all Mail Forwarders

In Progress [CPANEL-22101] Account list in Transfer Tool empty when migrating from Plesk

Horde not listing mailboxes from default account login

Problem when creating or listing mail accounts

Process List sort order triangle icon is upside down

Share This Page

Useful Searches

The Community Forums

Interact with an entire community of cPanel & WHM users!

list all databases associated with a reseller !!

furquan Well-Known Member

sirdopes Well-Known Member PartnerNOC

furquan Well-Known Member

List all Mail Forwarders

In Progress [CPANEL-22101] Account list in Transfer Tool empty when migrating from Plesk

Horde not listing mailboxes from default account login

Problem when creating or listing mail accounts

Process List sort order triangle icon is upside down

Share This Page

sirdopes Well-Known Member
PartnerNOC