unexpected[it]

Professional IT Blog

  • 22nd, Jul 2010

PHP mysqldump Script – Backup a MySQL Database

Tags: , , , , , ,

/**
* PHP mysqldump Script
* www.unexpectedit.com
*/
$dbname="magentoDatabase";
$dbhost="localhost";
$dbuser="root";
$dbpass="123456";

$backupFile = $dbname . date("Y-m-d-H-i-s")  . '.gz';
$command = "mysqldump --opt -h $dbhost -u'$dbuser' -p'$dbpass' $dbname | gzip > $backupFile";
$returned = system($command);
echo $returned;

© 2010 unexpected[it]. All Rights Reserved.

This blog is powered by Wordpress and a modified version of Magatheme