dbImpExp.php

gehe zur Dokumentation dieser Datei

<?php
define('ACTION_BACKUP', 1);
define('ACTION_IMPORT', 2);
define('ACTION_NOACTION', 99);

$action = ACTION_NOACTION;
if (isset($_POST['backup'])) {
  $action = ACTION_BACKUP;
}
if (isset($_POST['import'])) {
  $action = ACTION_IMPORT;
}

switch ($action) {
 case ACTION_BACKUP:
   $db = $_POST['bname'];
   $cmd = "mysqldump "
     . "-uftp49971 "
     . "-psa8turmdb "
     . "--default-character-set=latin1 "
     . "--opt " . $db;
   header( "Content-type: text/sql; charset=iso-8859-1" );
   header( "Content-Disposition: attachment; filename=\"$db.sql\"" );
   system($cmd);
   break;
 case ACTION_IMPORT:
   $db = $_POST['iname'];
   $path = "/is/htdocs/49971/www.juelich-bonn.com/tm_ad_v2/tmp/"
     . $db 
     . '.sql';
   if (is_file($path) != 1) {
     echo "Datei $path existiert nicht!";
     exit();
   }
   $cmd = "/usr/bin/mysql "
     . "-uftp49971 "
     . "-psa8turmdb "
     . "-hserver023.webpack.hosteurope.de "
     . $db
     . " < " 
     . $path;
   $fp = 1;
   system($cmd, $fp);
   if ($fp == 0) {
     echo "Datenbank $db importiert";
   }
   else {
     echo "Es ist ein Fehler aufgetreten.";
   }
   break;
 default:
   echo 'Falscher Aufruf!';
   exit();
}
exit();

?>

---