Product:
Search Type:

[How To] How to execute SQL queries for Plesk database without connecting to database engine

Article ID: 5248
Last Review: May,07 2008
APPLIES TO:
  • Plesk 8.x for Windows

More information

Since Plesk 8.1, Plesk is shipped with utility which can be used for executing simple queries in Plesk database, independent on Plesk database engine.


Utility is called 'dbclient.exe'. It is located at the directory %plesk_bin%.

 

Here are examples of usage:

 

SELECT


"%plesk_bin%\dbclient.exe" --direct-sql --sql="select * from misc where val='test'"

INSERT

"%plesk_bin%\dbclient.exe" --direct-sql --sql="insert into misc values ('test','test')"

UPDATE

"%plesk_bin%\dbclient.exe" --direct-sql --sql="update misc set param='test1' where val='test' "

DELETE

"%plesk_bin%\dbclient.exe" --direct-sql --sql="delete from misc where val='test'"

 

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields