Back-Up
Introduction
Back-up sur une table
Code :
<![CDATA[
$tableName = 'mypet';
$backupFile = 'backup/mypet.sql';
$sql= "SELECT * INTO OUTFILE '$backupFile' FROM $tableName";
$req = mysql_query($sql)or die("Erreur SQL : ".$sql."<br>".mysql_error());
]]>
LOAD BDD
Code :
<![CDATA[
$tableName = 'mypet';
$backupFile = 'mypet.sql';
$sql = "LOAD DATA INFILE '$backupFile' INTO TABLE $tableName";
$req = mysql_query($sql)or die("Erreur SQL : ".$sql."<br>".mysql_error());
]]>
Back-up avec mysqldump
Code :
<![CDATA[
$backupFile = $dbname . date("Y-m-d-H-i-s") . '.gz';
$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupFile";
system($command);
]]>
