VestaCP api delete database

[xinaidao]

Hello guys.

I need, through an api, to create and delete mysql database.
From what I've been seeing in the documentation, it is possible to create a database via api as shown in the link https://vestacp.com/docs/api/#add_database

My question is whether it is possible to delete the mysql database through this same api. Would anyone know anything about that?
Thank you all

[grayfolk]

Hello guys.

I need, through an api, to create and delete mysql database.
From what I've been seeing in the documentation, it is possible to create a database via api as shown in the link https://vestacp.com/docs/api/#add_database

My question is whether it is possible to delete the mysql database through this same api. Would anyone know anything about that?
Thank you all

Sure, this is possible. I think you can use this code:

Code: Select all

<?php
// Server credentials
$vst_hostname = 'server.vestacp.com';
$vst_username = 'admin';
$vst_password = 'p4ssw0rd';
$vst_returncode = 'yes';
$vst_command = 'v-delete-database';

$username = 'demo';
$db_name = 'demo_wordpress';

// Prepare POST query
$postvars = array[
    'user' => $vst_username,
    'password' => $vst_password,
    'returncode' => $vst_returncode,
    'cmd' => $vst_command,
    'arg1' => $username,
    'arg2' => $db_name
];
$postdata = http_build_query($postvars);

Note: when you create database it will be created with username prefix: demo_wordpress in this case. For delete database you should use db name with prefix.

Also, see scripts in /usr/local/vesta/bin folder - you can use all those commands via API.

[xinaidao]

Grayflolk,

thank you so much