/**
* Restore database
*
* @param $inputFile
* @return bool|string
*/
public function restore($inputFile)
{
$tempFileHandle = tmpfile();
fwrite($tempFileHandle, "[client]" . PHP_EOL . "user = '******'" . PHP_EOL . "password = '******'" . PHP_EOL . "host = '" . $this->host . "'" . PHP_EOL . "port = '" . $this->port . "'" . PHP_EOL);
$temporaryCredentialsFile = stream_get_meta_data($tempFileHandle)['uri'];
$command = sprintf('mysql --defaults-extra-file=%s %s < %s', escapeshellarg($temporaryCredentialsFile), escapeshellarg($this->database), escapeshellarg($inputFile));
return $this->console->run($command);
}
/**
* Restore database
*
* @param $inputFile
* @return bool|string
*/
public function restore($inputFile)
{
$command = sprintf('PGPASSWORD=%s psql --host=%s --port=%s --user=%s %s -f %s', escapeshellarg($this->password), escapeshellarg($this->host), escapeshellarg($this->port), escapeshellarg($this->user), escapeshellarg($this->database), escapeshellarg($inputFile));
// Log::info($command);exit;
return $this->console->run($command);
}
