laravel备份组件安装

第一步：

1. $ composer require laravel-admin-ext/backup -vvv

复制代码

添加provider

1. // config/app.php
   
2. 
   
3. 'providers' => [
   
4.     // ...
   
5.     Spatie\Backup\BackupServiceProvider::class,
   
6. ];

复制代码

第二部

1. php artisan admin:import backup

复制代码

第三部：在数据库配置文件中加上如下代码（config/database.php）参照修改

1. 'mysql' => [
   
2.     'driver'            => 'mysql',
   
3.     'host'              => env('DB_HOST', 'localhost'),
   
4.     'database'          => env('DB_DATABASE', 'forge'),
   
5.     'username'          => env('DB_USERNAME', 'forge'),
   
6.     'password'          => env('DB_PASSWORD', ''),
   
7.     'charset'           => 'utf8',
   
8.     'collation'         => 'utf8_unicode_ci',
   
9.     'prefix'            => '',
   
10.     'strict'            => false,
    
11.     'engine'            => null,
    
12.     'dump' => [
    
13. 
    
14.         'dump_binary_path' => '/path/to/directory/', // only the path, without `mysqldump` or `pg_dump`
    
15.         // 'dump_binary_path' => '/Applications/MAMP/Library/bin/', // works for MAMP on Mac OS
    
16.         // 'dump_binary_path' => '/opt/homebrew/bin/', // works for Laravel Valet on Mac OS
    
17.         'use_single_transaction',
    
18.         'timeout' => 60 * 5, // 5 minute timeout
    
19.         // 'exclude_tables' => ['table1', 'table2'],
    
20.         // 'add_extra_option' => '--optionname=optionvalue',
    
21.     ]
    
22. ],

复制代码

主要是dump备份路径位置

第四部：发布配置文件

1. php artisan vendor:publish --provider="Spatie\Backup\BackupServiceProvider"

复制代码

第五步：config/bacpup.php内容如下：

1. return [
   
2. 
   
3.     'backup' => [
   
4. 
   
5.         /*
   
6.          * The name of this application. You can use this name to monitor
   
7.          * the backups.
   
8.          */
   
9.         'name' => env('APP_URL'),
   
10. 
    
11.         'source' => [
    
12. 
    
13.             'files' => [
    
14. 
    
15.                 /*
    
16.                  * The list of directories and files that will be included in the backup.
    
17.                  */
    
18.                 'include' => [
    
19.                     base_path(),
    
20.                 ],
    
21. 
    
22.                 /*
    
23.                  * These directories and files will be excluded from the backup.
    
24.                  *
    
25.                  * Directories used by the backup process will automatically be excluded.
    
26.                  */
    
27.                 'exclude' => [
    
28.                     base_path('vendor'),
    
29.                     base_path('node_modules'),
    
30.                 ],
    
31. 
    
32.                 /*
    
33.                  * Determines if symlinks should be followed.
    
34.                  */
    
35.                 'followLinks' => false,
    
36.             ],
    
37. 
    
38.             /*
    
39.              * The names of the connections to the databases that should be backed up
    
40.              * Only MySQL and PostgreSQL databases are supported.
    
41.              */
    
42.             'databases' => [
    
43.                 'mysql',
    
44.             ],
    
45.         ],
    
46. 
    
47.         'destination' => [
    
48. 
    
49.             /*
    
50.              * The filename prefix used for the backup zip file.
    
51.              */
    
52.             'filename_prefix' => '',
    
53. 
    
54.             /*
    
55.              * The disk names on which the backups will be stored.
    
56.              */
    
57.             'disks' => [
    
58.                 'local',
    
59.             ],
    
60.         ],
    
61.     ],
    
62. 
    
63.     /*
    
64.      * You can get notified when specific events occur. Out of the box you can use 'mail' and 'slack'.
    
65.      * For Slack you need to install guzzlehttp/guzzle.
    
66.      *
    
67.      * You can also use your own notification classes, just make sure the class is named after one of
    
68.      * the `Spatie\Backup\Events` classes.
    
69.      */
    
70.     'notifications' => [
    
71. 
    
72.         'notifications' => [
    
73.             \Spatie\Backup\Notifications\Notifications\BackupHasFailed::class         => ['mail'],
    
74.             \Spatie\Backup\Notifications\Notifications\UnhealthyBackupWasFound::class => ['mail'],
    
75.             \Spatie\Backup\Notifications\Notifications\CleanupHasFailed::class        => ['mail'],
    
76.             \Spatie\Backup\Notifications\Notifications\BackupWasSuccessful::class     => ['mail'],
    
77.             \Spatie\Backup\Notifications\Notifications\HealthyBackupWasFound::class   => ['mail'],
    
78.             \Spatie\Backup\Notifications\Notifications\CleanupWasSuccessful::class    => ['mail'],
    
79.         ],
    
80. 
    
81.         /*
    
82.          * Here you can specify the notifiable to which the notifications should be sent. The default
    
83.          * notifiable will use the variables specified in this config file.
    
84.          */
    
85.         'notifiable' => \Spatie\Backup\Notifications\Notifiable::class,
    
86. 
    
87.         'mail' => [
    
88.             'to' => 'your@email.com',
    
89.         ],
    
90. 
    
91.         'slack' => [
    
92.             'webhook_url' => '',
    
93.         ],
    
94.     ],
    
95. 
    
96.     /*
    
97.      * Here you can specify which backups should be monitored.
    
98.      * If a backup does not meet the specified requirements the
    
99.      * UnHealthyBackupWasFound event will be fired.
    
100.      */
     
101.     'monitorBackups' => [
     
102.         [
     
103.             'name' => env('APP_URL'),
     
104.             'disks' => ['local'],
     
105.             'newestBackupsShouldNotBeOlderThanDays' => 1,
     
106.             'storageUsedMayNotBeHigherThanMegabytes' => 5000,
     
107.         ],
     
108. 
     
109.         /*
     
110.         [
     
111.             'name' => 'name of the second app',
     
112.             'disks' => ['local', 's3'],
     
113.             'newestBackupsShouldNotBeOlderThanDays' => 1,
     
114.             'storageUsedMayNotBeHigherThanMegabytes' => 5000,
     
115.         ],
     
116.         */
     
117.     ],
     
118. 
     
119.     'cleanup' => [
     
120.         /*
     
121.          * The strategy that will be used to cleanup old backups. The default strategy
     
122.          * will keep all backups for a certain amount of days. After that period only
     
123.          * a daily backup will be kept. After that period only weekly backups will
     
124.          * be kept and so on.
     
125.          *
     
126.          * No matter how you configure it the default strategy will never
     
127.          * delete the newest backup.
     
128.          */
     
129.         'strategy' => \Spatie\Backup\Tasks\Cleanup\Strategies\DefaultStrategy::class,
     
130. 
     
131.         'defaultStrategy' => [
     
132. 
     
133.             /*
     
134.              * The number of days for which backups must be kept.
     
135.              */
     
136.             'keepAllBackupsForDays' => 7,
     
137. 
     
138.             /*
     
139.              * The number of days for which daily backups must be kept.
     
140.              */
     
141.             'keepDailyBackupsForDays' => 16,
     
142. 
     
143.             /*
     
144.              * The number of weeks for which one weekly backup must be kept.
     
145.              */
     
146.             'keepWeeklyBackupsForWeeks' => 8,
     
147. 
     
148.             /*
     
149.              * The number of months for which one monthly backup must be kept.
     
150.              */
     
151.             'keepMonthlyBackupsForMonths' => 4,
     
152. 
     
153.             /*
     
154.              * The number of years for which one yearly backup must be kept.
     
155.              */
     
156.             'keepYearlyBackupsForYears' => 2,
     
157. 
     
158.             /*
     
159.              * After cleaning up the backups remove the oldest backup until
     
160.              * this amount of megabytes has been reached.
     
161.              */
     
162.             'deleteOldestBackupsWhenUsingMoreMegabytesThan' => 5000,
     
163.         ],
     
164.     ],
     
165. ];

复制代码

备份不能下载和删除，需要修改D:\WWW\syfw\vendor\laravel-admin-ext\backup\resources\views 里面的视图文件

详情可以看：https://www.yaanbbs.net/study/yaan30017/此文