dongyuan4790 2014-03-08 16:28
浏览 66

PHP Ubuntu - 备份和恢复MySQl

I follow this and it working well in Window

But when i run in ubuntu (13.10) and using xampp

<?php
$server     = "localhost";
$username   = "root";
$password   = "root";
$db = "test";
$restore_file   = "/home/myname/test.sql";
$cmd = "/opt/lampp/bin/mysql -h {$server} -u {$username} -p{$password} {$db} < $restore_file";
//umask(0);
exec($cmd);
echo "Restore complete!";
?>

it echo restore complete but database is empty. If i run script on terminal then it working.

How to fix that thanks

  • 写回答

1条回答 默认 最新

  • drzb7969753 2014-03-08 16:41
    关注

    What is O/P?

    <?php
            if(function_exists('exec')) {
            echo "exec function is enabled";
            }
            else {
            echo "exec is not enabled";
            }
      ?>
    

    Edit
    Execute this command in shell.

    chmod +x /opt/lampp/bin/mysql
    

    Edit

    exec($cmd, $output, $return); 
    
    echo $output;
    if (!$return) {
        echo "Success";
    } else {
        echo "Failed";
    }
    
    评论

报告相同问题?

悬赏问题

  • ¥15 yolov8边框坐标
  • ¥15 matlab中使用gurobi时报错
  • ¥15 WPF 大屏看板表格背景图片设置
  • ¥15 这个主板怎么能扩出一两个sata口
  • ¥15 不是,这到底错哪儿了😭
  • ¥15 2020长安杯与连接网探
  • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么
  • ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
  • ¥16 mybatis的代理对象无法通过@Autowired装填
  • ¥15 可见光定位matlab仿真