Skip to content

Instantly share code, notes, and snippets.

@ashrafmisran

ashrafmisran/mysqldump.php

Forked from micc83/mysqldump.php
Created April 30, 2018 04:12
Show Gist options
  • Save ashrafmisran/3f87e5885f3a5a2a24afddeeff1f240c to your computer and use it in GitHub Desktop.
Save ashrafmisran/3f87e5885f3a5a2a24afddeeff1f240c to your computer and use it in GitHub Desktop.
Download ZIP
Simple PHP script to dump a MySql database
Raw
mysqldump.php
<?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);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment