Using PHP To Backup MySQL Database | tutorialsforu.info

Language Translator

Using PHP To Backup MySQL Database

Written by Harry

Monday, 14 January 2008

Article Index
Using PHP To Backup MySQL Database
Page 2
Page 3

Page 2 of 3

Run mysqldump using system() function

The system() function is used to execute an external program. Because MySQL already have built in tool for creating MySQL database backup (mysqldump) let's use it from our PHP script

<?php
include 'config.php';
include 'opendb.php';

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

include 'closedb.php';
?>

<< Prev - Next >>

Last Updated ( Tuesday, 15 January 2008 )