laravel添加日常备份任务
2024-08-24 22:59:42
app/Console/Command/MySqlDump.php
<?php namespace App\Console\Commands; use Illuminate\Console\Command; //mysql每天备份, 需要在crontab -e添加以下命令
//* * * * * /usr/local/php/bin/php /wwwroot/shells/artisan schedule:run >> /dev/null 2>&1
class MySqlDump extends Command
{
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'mysqldump'; /**
* The console command description.
*
* @var string
*/
protected $description = '项目数据库每天备份任务'; /**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$ds = DIRECTORY_SEPARATOR; $schema = env('DB_DATABASE');
$user = env('DB_USERNAME');
$password = env('DB_PASSWORD');
$path = database_path() . $ds . 'backups' . $ds . date('Y-m') . $ds;
if (!is_dir($path)) {
mkdir($path, 0755, true);
} $file = date('Y-m-d') . '.sql';
$command = sprintf('/usr/local/mysql/bin/mysqldump %s -u %s -p\'%s\' > %s', $schema, $user, $password, $path . $file); exec($command);
}
}
app/Console/Kernel.php
<?php namespace App\Console; use Illuminate\Console\Scheduling\Schedule;
use Illuminate\Foundation\Console\Kernel as ConsoleKernel; class Kernel extends ConsoleKernel
{
/**
* The Artisan commands provided by your application.
*
* @var array
*/
protected $commands = [
//\App\Console\Commands\MakeCourseKeyword::class,
\App\Console\Commands\MySqlDump::class,
]; /**
* Define the application's command schedule.
*
* @param \Illuminate\Console\Scheduling\Schedule $schedule
* @return void
*/
protected function schedule(Schedule $schedule)
{
// $schedule->command('MakeCourseKeyword')
// ->dailyAt("03:00")
// ->sendOutputTo('storage/logs/MakeCourseKeyword.log', true);
$schedule->command('mysqldump')
->dailyAt('03:00');
}
}
最新文章
- Spring IoC源码解析——Bean的创建和初始化
- HDU4329
- CentOS 5系统安装Django、Apache 、mod_wsgi部署Python环境教程
- javascript 日常总结
- 有关IT的小笑话
- [转]NHibernate之旅(4):探索查询之条件查询(Criteria Query)
- (9)集合之Set,HashSet,TreeSet
- Android中的java层的线程暂停和恢复实现
- Git详细教程(3)---结合gitHub使用
- 测试框架httpclent 1.HttpClient简介及第一个demo
- JAVA自学笔记13
- schema举例二
- Ubuntu 16.04 不能用inittab 设置 运行等级 runlevel
- java基本数据间转换
- Android Studio离线打包5+SDK
- c# winform+wcf代理上网的处理
- bzoj 4650(洛谷 1117) [Noi2016]优秀的拆分——枚举长度的关键点+后缀数组
- ASP.NET网页VS利用文件系统发布
- Hadoop源码学习笔记之NameNode启动场景流程一:源码环境搭建和项目模块及NameNode结构简单介绍
- 修改oracle表空间数值