Database Manager - RestoreDatabase

Version: 1

HCnix Build: 3.00 and later

API Build: 1.00 and later

 

Database Manager- RestoreDatabase  restores database from a specified filename. This web service call can be made as http://your-domain.com/HCnixAPI/DatabaseManager.php?op=RestoreDatabase.

 

Input Parameters

 

Output Parameters

 

       N/A

 

Sample Optional Parameters

 

<Parameters>

<Parameter Name = "Language">French</Parameter>

</Parameters>

 

Sample SOAP Request

 

 

POST /HCnixAPI/DatabaseManager.php HTTP/1.1

Host: your-domain.com

Content-Type: text/xml; charset=utf-8

Content-Length: length

SOAPAction: "http://tempuri.org/RestoreDatabase"

<?xml version="1.0" encoding="utf-8"?>

<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

  <soap:Body>

    <RestoreDatabase xmlns="http://tempuri.org/">

      <HostUserName>host</HostUserName>

      <HostPassword>host123</HostPassword>

      <OwnerName>david</OwnerName>

      <DatabaseName>MyDatabase</DatabaseName>

      <BackupFilePath>C:\Webspace\david\john\MyDomain.com\db\MyDatabase<\BackupFilePath>

      <OptionalParam>xml</OptionalParam>

    </RestoreDatabase>

  </soap:Body>

</soap:Envelope>

 

 

Sample HTTP Request

 

 

POST /HCnixAPI/DatabaseManager.php/RestoreDatabase HTTP/1.1

Host: your-domain.com

Content-Type: application/x-www-form-urlencoded

Content-Length: length

HostUserName=host&HostPassword=host123&OwnerName=david&DatabaseName=MyDatabase&

BackupFilePath=C:/Webspace/david/john/MyDomain.com/db/MyDatabase&OptionalParam=xml

 

 

Sample PHP Code

 

 

function RestoreDatabase($strHostUserName, $strHostPassword, $strOwnerName, $DatabaseName, $BackupFilePath, $OptionalParam)

{

        $response="";

        $soapPacket = "<?xml version=\"1.0\" encoding=\"utf-8\"?>

        <soap:Envelope

            xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"

            xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"

            xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">

            <soap:Body>

                   <RestoreDatabase xmlns=\"http://tempuri.org/\">

                    <HostUserName>$strHostUserName</HostUserName>

                    <HostPassword>$strHostPassword</HostPassword>

                    <OwnerName>$strOwnerName</OwnerName>

                    <DatabaseName>$strDatabaseName</DatabaseName>

          <BackupFilePath>$strBackupFilePath</BackupFilePath>

                    <OptionalParam>$OptionalParam</OptionalParam>

                   </RestoreDatabase>

            </soap:Body>

        </soap:Envelope>";

        // where $domain_name is where HCnix APIs are installed

        $fp = fsockopen($domain_name, 80, $errNo, $errString, 90);

        if($fp)  

        {

            // where $name is the Virtual Directory name for HCnix APIs

            $header = "POST /$name/UserManager.php HTTP/1.1\r\n";

            $header .= "HOST: $domain_name\n";

            $header .= "Content-Type: text/xml;charset=\"utf-8\"\r\n";

            $header .= "Content-Length: ".strlen($soapPacket)."\r\n\r\n";

            fwrite($fp, $header.$soapPacket);

        

            while (true)

            {  

                  $buffer = fread($fp, 1000);

                  if( $buffer != "" )

                      $response .= $buffer;  

                  if(strstr($response, '</SOAP-ENV:Envelope>') || $buffer == "" )  

                      break;

                  $buffer = "";  

              }

            fclose($fp);

            $result = explode("<?xml",$response);

            return "<?xml".$result[1];

        }

}

 

 

Sample Response

 

 

<Response>

    <Method>RestoreDatabase</Method>

    <Status>true</Status>

    <ErrorCode>73100061</ErrorCode>

    <ErrorDescription>Database restore is a lengthy task; it is queued to be performed later.</ErrorDescription>           

    <Result/>

</Response>