mysqldump – with exec() function from php outputs empty file

Here is the code I wrote that proves this…
isAuthorized())
{
$this->redirect($this->getConfig(‘login_page’));
}

// Get requirements and verify they loaded correctly
if (!stristr($_SERVER[‘HTTP_REFERER’], ‘pages/adminManager.php’))
{
$this->append($this->error(‘Access denied to this location’));

return;
}

// Get the database credentials
$db = new db();
$host = $db->getHost();
$dbname = $db->getDbName();
$user = $db->getUserName();
$pass = $db->getPass();

// Create the dump filename
$date = date(‘h:i:s–m-d-Y’);
$backup_path = “../db_dumps/{$host}-{$dbname}-{$date}.sql”;

// Attempt the backup for a Linux environment
$command = “mysqldump -f -C -K –host={$host} –user={$user} –password={$pass} $dbname >{$backup_path}”;
exec($command, $output, $error_code);

// Check for errors
if ($error_code != 0)
{
// Get the path to the mysqldump program
$command = ‘dir /b/s \mysqldump.exe’;
exec($command, $output, $error_code);

// Check for errors
if ($error_code != 0)
{
// Something is wrong but we don’t know what
$this->append($this->error(“$command failed with an error code of $error_code”));

return;
}

// Windows refuses to work with dashes and or colons in the file name
$date = date(‘hismdY’);
$base_path = $this->getConfig(‘base_dir’);
$backup_path = “{$base_path}db_dumps/{$host}{$dbname}{$date}.sql”;

// Windows needs back slash paths instead of forward slash paths
$path_array = explode(‘/’, $backup_path);
$backup_path = implode(‘\\’, $path_array);

// Attempt the backup for a Windows environment
$command = “\”{$output[0]}\” -f -C -K –host={$host} –user={$user} –password={$pass} $dbname >\”{$backup_path}\””;
exec($command, $output, $error_code);

// Check for errrors
if ($error_code != 0)
{
// Something is wrong but we don’t know what
$this->append($this->error(“$command failed with an error code of $error_code”));

return;
}
if (!file_exists($backup_path))
{
// The file that needs to be created cannot be
$this->append($this->error(“The path $backup_path, does not exist”));

return;
}
if (sizeof($backup_path) == 0)
{
// The file was created but no data was written to it
$this->append($this->error(“The backup file was created but not filled. Try running the command $command from cmd.”));

return;
}

}

header(“Location: {$_SERVER[‘HTTP_REFERER’]}”);
}
}

$db_dump = new dbDump();
?>

do you have a solution for linux too ?

Hi,
I tried your given window command it runs but linux command is not running from remote server. I have written code as follow:

$strCommand = “/usr/bin/mysqldump –host=$host –user=$user –password=$password test > $path”;
echo “————-START————-\n”;
$strOutput = exec($strCommand,$arrOutput,$intReturnValue);
echo “COMMAND: $strCommand\n\n”;
echo “RETURN VALUE: $intReturnValue\n\n”;
echo “OUTPUT: \n”;
print_r($arrOutput);
echo “————-END————-\n”;
die();

But it gives following output:

START————- COMMAND: /usr/bin/mysqldump –host=krislinmsbt.krislinm.com –user=krislinm_msbte09 –password=(———-) test > /home/krislinm/public_html/msbte11/admin/all_control/master_control/ftp_upload/backup/text.sql RETURN VALUE: 2 OUTPUT: Array ( ) ————-END————-

So, please advice me where i am wrong.

Hi,
Thanks for your valuable suggestions. I run following code:

1) echo system(‘which mysqldump’); It shows twice /usr/bin/mysqldump /usr/bin/mysqldump

2) I tried to find error message but it shows blank output.

Hi,
Thanks for your script. I tried each step but still getting 0 kb files.
and result:
Array ( [0] => Usage: mysqldump [OPTIONS] database [tables] [1] => OR mysqldump [OPTIONS] –databases [OPTIONS] DB1 [DB2 DB3…] [2] => OR mysqldump [OPTIONS] –all-databases [OPTIONS] [3] => For more options, use mysqldump –help )

My code :

$back_folder = $_SERVER[‘DOCUMENT_ROOT’].’/backups’;
$backup_file = date( “m-d-Y-H-i-s” ).”_”.$database_members.”.sql”;

$command = “mysqldump –opt –skip-extended-insert –complete-insert –host=”.$hostname_members.” –user=”.$username_members.” –password=”.$password_members.” “.$database_members.” > “.$back_folder.”/”.$backup_file;
exec($command, $ret_arr, $ret_code);

I am not sure what is going wrong.

$date = Carbon::now()->format(‘y-m-d_h-i’);
$host = env(‘DB_HOST’,’127.0.0.1′);
$user = env(‘DB_USERNAME’,’root’);
$password = env(‘DB_PASSWORD’,”);
$database = env(‘DB_DATABASE’,’kalai’);

$command = “\”D:\\wamp\\bin\\mysql\\mysql5.6.17\\bin\\mysqldump.exe\” –user={$user} –password={$password} –host={$host} –flush-logs –single-transaction {$database} > {$date}.sql”;

$process = new Process($command);
$process->start();

while ($process->isSuccessful()) {
$local=Storage::disk(‘local’);
$local->put(”.$date.”.sql”, file_get_contents(“{$date}.sql”));
unlink(“{$date}.sql”);
}
}

refer this link http://www.theerrormessage.com/2008/10/mysqldump-with-exec-function-from-php-outputs-empty-file/