mysql_controller.php

<?php

class MysqlController extends AppController {

  var $name = 'Mysql';
  var $helpers = array();
  var $uses = array();

  function beforeFilter() {
    $this->autoRender = FALSE;
    $this->Auth->allowedActions = array('exec');
    parent::beforeFilter();
  }

  function exec() {
    $allowed_actions = array('dump', 'restore', 'connect');
    
    $action = array_splice($this->passedArgs, 0, 1);
    $action = $action[0];
    $args = implode(' ', $this->passedArgs);
    
    if(!in_array($action, $allowed_actions)) {
      echo 'command not in list of allowed commands';
      header("Location: http://".$_SERVER['HTTP_HOST'].str_replace('//', '/', '/'.BASE_URL.'/todos_app'));
    }
    
    $mysql = $this->mysql($action, $args);
    header("Location: http://".$_SERVER['HTTP_HOST'].str_replace('//', '/', '/'.BASE_URL.'/todos_app'));
  }
  
  function mysql($action, $args = '') {
    if($action == 'dump') {
      $postfix = 'mysqldump';
      $io = '>';
    } elseif ($action == 'restore') {
      $postfix = 'mysql';
      $io = '<';
    } elseif (isempty($action)) {
      $cmd = 'mysql connect 192.168.1.16 2>&1';
      $op = `$cmd`;
      return $op;
    }
    
    
//    $cmd = sprintf('%1s -uaxel_1 -pkakadax -h localhost todos_backbone %2s E:/Sites/php/mysql_backup/file.sql 2>&1', $postfix, $io);
    $cmd = sprintf('%1s -uaxel -pkakadax -h localhost todos_backbone %2s /var/www/vhosts/webpremiere.de/mysql_backup/file.sql 2>&1', $postfix, $io);
    $op = `$cmd`;
    return $op;
  }
}