list of dbs for users

[anand]

Hi,

I am looking for help on getting list of databases for a setup of cpanel users. Basically we want to create a small internal app, which takes a particular list of users, goes in each account, get a list of their respective databases, and back them up.

I know we can backup all databases, its much easier, but we to only backup for a set of users, and these users keep on adding more dbs to the server, so the only way it will work flawlessly is via the api.

Any help would be appreciated.

Thanks

[cPanelMatt]

This should be done rather easily via the API2 MysqlFE::listdbs call. To call this you would use a URL like:

/xml-api/cpanel?cpanel_xmlapi_module=MysqlFE&cpanel_xmlapi_func=listdbs&cpanel_xmlapi_user=$username

. At this point, it should return an XML list of the databases that belong to that user and you can kick off a "dump" process from there.

There are a few libraries that can assist you with this, please see http://github.com/CpanelInc for a listing of them (perl and PHP)

Please let me know if you have any more questions/problems that we can assist you with.

[anand]

Great, let me try it out.

Thanks

[anand]

Got it working like the way we wanted. Thanks for help.