Skip to content

Instantly share code, notes, and snippets.

@ashokmhrj
Last active January 7, 2016 07:08
Show Gist options
  • Save ashokmhrj/ffef27654bd606e393b6 to your computer and use it in GitHub Desktop.
Save ashokmhrj/ffef27654bd606e393b6 to your computer and use it in GitHub Desktop.
PHP Importing database via CLI mode
<?php
/**
* import db via Command Line Interface (CLI) PHP
*/
define('DBUSER','DBUSER');
define('DBPASSWD','DBPASSWRD');
define('DATABASE','DBNAME');
define('HOST','host');
$filename = "backup-" . date("d-m-Y") . ".sql.gz";
$mime = "application/x-gzip";
header("Content-Type: " . $mime);
header('Content-Disposition: attachment; filename="' . $filename . '"');
$cmd = "mysqldump -h " . HOST . " -u " . DBUSER . " --password=" . DBPASSWD . " " . DATABASE . " | gzip --best";
passthru($cmd);
exit(0);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment