[linux-baslangic] mysql,php,gzip peryodik backup

---------

New Message Reply About this list Date view Thread view Subject view Author view Attachment view

From: Ayhan BARIS (abaris@oyaktur.com.tr)
Date: Tue 07 Sep 2004 - 11:08:34 EEST


Ben soyle yapiyorum linux server uzerinde...
 

<?php
include("db_login.php");
// Mysql Database Information:
    $database = 'name_of_db'; // name of the database.
    $username = $user; // username with access to database.
    $password = $pass; // password for username.
// Database Backup Filename & Location
    $backupto = '/path/to/save/databases'; // absolute path to folder
containing database - no trailing slash.
    $backupas = $database . '.sql' . '.gz';
// Perform backup
$backupcommand = "mysqldump -u$username -p$password $database | gzip
>$backupto/$backupas";
passthru ("$backupcommand", $error);
if($error) {
   echo ("Problem: $error\n"); exit;
}
?>

 

---
linux-baslangic listesinden cikmak  ve tum listeci islemleri icin
http://liste.linux.org.tr/   adresini kullanabilirisniz.
Bu listeden cikmak icin
<a href="mailto:linux-baslangic-request@liste.linux.org.tr?Subject=unsubscribe"> tiklayiniz</a>


New Message Reply About this list Date view Thread view Subject view Author view Attachment view

---------

Bu arsiv hypermail 2.1.2 tarafindan uretilmistir.