dskpywvki951583595
2014-12-08 14:22
浏览 47
已采纳

用于MySQL转储cron作业的PHP脚本

I am trying to create a script that would run through a cron job, so it would dump the database on a regular basis. I also tried a couple of combinations with quotations and dots, but neither worked.

<?php
$date = date('Y-m-d-H:i:s');
$host = 'localhost';
$user = 'username';
$password = 'password';
$database = 'databasename';
echo shell_exec("mysqldump -h $host -u $user -p$password $database > mysqlbackup$date.sql");
?>
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dongmu2026 2014-12-08 14:30
    已采纳

    It would be a lot wiser to run the database dump directly as a cron job. I can see that you already have the command ready, so type crontab -e and enter something like to run it nightly at 03:30 AM:

    30 03 * * * /usr/bin/mysqldump -u[username] -p[password] --all-databases --single-transaction > /home/USERNAME/backups/full_backup_`date +%Y-%m-%d_%H-%M-%S`.sql
    

    And avoid writing your password in the command - instead, use .my.cnf.

    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题