SQL export query

Ooit begonnen aan een Backup class.. nooit afgemaakt, maar werkt wel.

<?php
// @TODO: queries via de database class
// @TODO: mail via mail class

class Backup
{

private $db, $sql_backup;

function __construct()
{
$this->db = new Database();
}

public function getData()
{
$query = mysql_query('SHOW TABLE STATUS');
$this->sql_backup = '';

while ($row = mysql_fetch_assoc($query))
{
$query2 = mysql_query('SHOW CREATE TABLE '.$row['Name']);

$this->sql_backup.= "\r\n#Create table ".$row['Name']."\r\n\r\n";
$out = mysql_fetch_assoc($query2);

$this->sql_backup.= $out['Create Table'].";\r\n\r\n";
$this->sql_backup.= "#Dump data\r\n\r\n";

$out = mysql_query('SELECT * FROM '.$row['Name']);
$sql_code = '';

while ($code = mysql_fetch_array($out, MYSQL_ASSOC))
{
$sql_code .= "INSERT INTO ".$row['Name']." SET ";

foreach ($code as $insert => $value)
{
$sql_code.= $insert."='".addslashes($value)."',";
}
$sql_code = substr($sql_code, 0, -1);
$sql_code.= ";\r\n";
}
$this->sql_backup .= $sql_code;
}
}

public function mailData()
{
$unique = md5(uniqid(time()));

$message = "Backup procedure van database is met succes verlopen. U vindt in de bijlage een backup van de inhoud gemaakt op ".date('d-m-Y H:i:s')."\r\n Autobot";

$headers = "From: Autobot <noreply@".DOMAIN.">\r\n";
$headers .= "Reply-To: Autobot <noreply@".DOMAIN.">\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: multipart/mixed; boundary=\"".$unique."\"\r\n";
$headers .= "Content-Disposition: attachment\r\n";

$body.= "This is a multi-part message in MIME format.\r\n";
$body.= "\r\n";
$body.= "--".$unique."\r\n";
$body.= "Content-Type: text/plain; charset=iso-8859-1\r\n";
$body.= "Content-Transfer-Encoding: 7bit\r\n";
$body.= "\r\n";
$body.= $message."\r\n";
$body.= "--".$unique."\r\n";
$body.= "Content-Type: application/octet-stream; name=database.sql\r\n";
$body.= "Content-Transfer-Encoding: base64\r\n";
$body.= "Content-disposition: attachment\r\n";
$body.= "\n";
$body.= chunk_split(base64_encode($this->sql_backup))."\r\n";

if (@mail(EMAIL, 'Mysql backup '.date('d-m-Y H:i:s'), $body, $headers))
{
return true;
}
return false;
}

}

?>

Backup doormiddel van query's is nooit geheel betrouwbaar. Daar is mysql_dump voor.

Mag je op os level mysqldump uitvoeren?
Hiermee maak je eenvoudig de backup die je beschrijft.
Voorbeeld:
/usr/bin/mysqldump web_users >/disk/mnt/web_users_backup.sql