-
-
Save micc83/fe6b5609b3a280e5516e2a3e9f633675 to your computer and use it in GitHub Desktop.
<?php | |
ini_set('display_errors', 1); | |
ini_set('display_startup_errors', 1); | |
error_reporting(E_ALL); | |
$database = 'db'; | |
$user = 'user'; | |
$pass = 'pass'; | |
$host = 'localhost'; | |
$dir = dirname(__FILE__) . '/dump.sql'; | |
echo "<h3>Backing up database to `<code>{$dir}</code>`</h3>"; | |
exec("mysqldump --user={$user} --password={$pass} --host={$host} {$database} --result-file={$dir} 2>&1", $output); | |
var_dump($output); |
If you're in windows like me and don't want create a ENVIRONMENT VARIABLE, you can use the mysql dir before the dump command
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
define('DS', DIRECTORY_SEPARATOR);
$database = 'etsy';
$user = 'root';
$pass = '';
$host = 'localhost';
$dir = dirname(__FILE__) . DS . 'dump.sql';
$mysqlDir = 'D:'.DS.'wamp64'.DS.'bin'.DS.'mysql'.DS.'mysql8.0.18'.DS.'bin'; // Paste your mysql directory here and be happy
$mysqldump = $mysqlDir.DS.'mysqldump';
echo "<h3>Backing up database to `<code>{$dir}</code>`</h3>";
exec("{$mysqldump} --user={$user} --password={$pass} --host={$host} {$database} --result-file={$dir} 2>&1", $output);
var_dump($output);
The script works well locally, now how can I use it externally?
Thanks a lot for this script.
I improved it with a bit of bash
and a desktop launcher, it's written in French but this may interest someone:
https://roneo.org/ovh-sans-ssh-sauvegarde-database-sql-script-bash/
Hi guys,
first of all let me thank you for the amazing simple script.. it works great, but i needed to add some features to fit my project, such as save file from input form in php, where we select de name of the backup and post it to the execut backup script, and then download file in webrowser directly. attached below is a working example of the code.
And yeahhh keep up the good work lads.
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);include_once("conect-db.php");
$name_backup = $_REQUEST['name_backup'];
$command='mysqldump --opt -h' .$databaseHost .' -u' .$databaseUsername .' -p' .$databasePassword .' ' .$databaseName .' > ' .$name_backup;
exec($command,$output,$worked);$file_name = basename($name_backup);
//save the file by using base name
$fn = file_put_contents($file_name,file_get_contents($name_backup));
header("Expires: 0");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
header("Content-type: application/file");
header('Content-length: '.filesize($file_name));
header('Content-disposition: attachment; filename="'.basename($file_name).'"');
readfile($file_name);switch($worked){
case 0:
echo 'The database ' .$databaseName .' was successfully stored in the following path '.getcwd().'./' .$name_backup .'';
break;
case 1:
echo 'An error occurred when exporting ' .$databaseName .' zu '.getcwd().'/' .$mysqlExportPath .'';
break;
case 2:
echo 'An export error has occurred, please check the following information:';
MySQL Database Name: ' .$databaseName .' MySQL User Name: ' .$databaseUsername .' MySQL Password: NOTSHOWN MySQL Host Name: ' .$databaseHost .'
break;
}
?>
better version : https://gist.github.com/pthavarasa/1ff1933a74eb97ae07aa0103ad8bea1d
Hi, first at all, GREAT SCRIPT...! now i have to questions: 1)- how can i zip the dump? 2)- How can i for the download after finish? Suggestions or ideas? Best regards.
Hi @smitione look here, you should find everything you're looking for: https://stackoverflow.com/a/4369173
thanksssss alot i had very struggle for this command and now i find it.
Work fine!