MySQL_GetDBInfo


Definition

Retrieve a list of the MySQL databases in a Web hosting account.

Usage

Use this command to retrieve a list of the MySQL databases in a Web hosting account.

Availability

All resellers have access to this command.

Implementation on eNom.com

Log on to resellertest.enom.com with Login ID resellid, password resellpw.

https://resellertest.enom.com/wsg/packagemanager.asp?

In the resellwebid row, click access.

In the menu, click MySQL / PHP.

The Manage MySQL Databases table is populated by the MySQL_GetDBInfo command.

Constraints

The query must meet the following requirements:

  • The login ID and password must be valid.
  • The Web hosting account must belong to this domain name account.

Input parameters

Build the query string using this syntax:

https://resellertest.enom.com/interface.asp?
command=nameofcommand&uid=yourloginid&pw=yourpassword
&paramname=paramvalue&nextparamname=nextparamvalue

 

Parameter Status Description Max Size
UID Required Account login ID 20
PW Required Account password 20
HostAccount Required Web hosting account name 14
ResponseType Optional Format of response. Options are Text (default), HTML, or XML. 4

 

Returned parameters and values

Parameter Description
AccountStatusID Status of this Web hosting account: 1 Host account is active 2 Account disabled for exceeding allowed monthly bandwidth 3 Account disabled for exceeding the 3000GB bandwidth limit 4, 5, 6, 7 Account disabled; contact customer service
MySQLCount Number of MySQL databases in this Web hosting account
MySQLAllowed Total number of MySQL databases permitted in this Web hosting account
DBName Name of this database
DBStatus Status of this database
DBDateCreated Date this database was created
DBMaxSize Maximum size permitted for this database
DBCurrentSize Current size of this database
Command Name of command executed
ErrCount The number of errors if any occurred. If greater than 0 check the Err(1 to ErrCount) values.
Err(x) Error messages explaining the failure. These can be presented as is back to the client
Done True indicates this entire response has reached you successfully

 

Notes

  • The default response format is plain text. To receive the response in HTML or XML format, send ResponseType=HTML or ResponseType=XML in your request.
  • Check the return parameter ErrCount. If greater than 0 the transaction failed. The parameterErr(ErrCount) can be presented to the client. Otherwise process the returned parameters as defined above.

Example