SAE定时备份数据库 偏执的太偏执、 2022-06-16 13:25 202阅读 0赞 https://leo108.com/pid-1810.asp WordPress迁移到SAE之后,以前的backwpup插件就不能直接用了,但是又需要备份,所以就利用SAE的几个服务来实现这个功能。 1.deferred job SAE自带的数据库导入、导出服务,可以直接将数据库导出到storage下。 2.cron SAE的计划任务,根据设置定时访问设定的页面,来触发我们的备份行为。 下面是操作步骤: 1.新建一个叫back的storage,用来存放备份文件。 2.在网站根目录新建一个文件back.php,内容如下 <table style="border-spacing:0px; border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; border-collapse:collapse!important; width:auto!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; min-height:auto!important"> <tbody style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <tr style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <td style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:3em!important; line-height:1.1em!important; min-height:auto!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0.3em 0px 0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; text-align:right!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:2.7em!important; min-height:auto!important; display:block!important; color:rgb(175,175,175)!important">1</code></td> <td style="border-width:0px 0px 0px 3px!important; border-top-style:initial!important; border-right-style:initial!important; border-bottom-style:initial!important; border-left-style:solid!important; border-top-color:initial!important; border-right-color:initial!important; border-bottom-color:initial!important; border-left-color:rgb(67,90,95)!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0px 0px 0.5em!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important; word-break:break-all!important; color:rgb(185,189,182)!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important"><?php</code></td> </tr> </tbody> </table> <table style="border-spacing:0px; border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; border-collapse:collapse!important; width:auto!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; min-height:auto!important"> <tbody style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <tr style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <td style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:3em!important; line-height:1.1em!important; min-height:auto!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0.3em 0px 0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; text-align:right!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:2.7em!important; min-height:auto!important; display:block!important; color:rgb(175,175,175)!important">2</code></td> <td style="border-width:0px 0px 0px 3px!important; border-top-style:initial!important; border-right-style:initial!important; border-bottom-style:initial!important; border-left-style:solid!important; border-top-color:initial!important; border-right-color:initial!important; border-bottom-color:initial!important; border-left-color:rgb(67,90,95)!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0px 0px 0.5em!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important; word-break:break-all!important; color:rgb(185,189,182)!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important; color:rgb(255,170,62)!important">$date</code> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">= </code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important; color:rgb(255,170,62)!important">date</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">(</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important; color:rgb(92,230,56)!important">'Y-m-d'</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">);</code></td> </tr> </tbody> </table> <table style="border-spacing:0px; border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; border-collapse:collapse!important; width:auto!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; min-height:auto!important"> <tbody style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <tr style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <td style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:3em!important; line-height:1.1em!important; min-height:auto!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0.3em 0px 0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; text-align:right!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:2.7em!important; min-height:auto!important; display:block!important; color:rgb(175,175,175)!important">3</code></td> <td style="border-width:0px 0px 0px 3px!important; border-top-style:initial!important; border-right-style:initial!important; border-bottom-style:initial!important; border-left-style:solid!important; border-top-color:initial!important; border-right-color:initial!important; border-bottom-color:initial!important; border-left-color:rgb(67,90,95)!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0px 0px 0.5em!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important; word-break:break-all!important; color:rgb(185,189,182)!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important; color:rgb(255,170,62)!important">$dj</code> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">= </code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important; color:rgb(91,161,207)!important">new</code> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">SaeDeferredJob();</code></td> </tr> </tbody> </table> <table style="border-spacing:0px; border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; border-collapse:collapse!important; width:auto!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; min-height:auto!important"> <tbody style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <tr style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <td style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:3em!important; line-height:1.1em!important; min-height:auto!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0.3em 0px 0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; text-align:right!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:2.7em!important; min-height:auto!important; display:block!important; color:rgb(175,175,175)!important">4</code></td> <td style="border-width:0px 0px 0px 3px!important; border-top-style:initial!important; border-right-style:initial!important; border-bottom-style:initial!important; border-left-style:solid!important; border-top-color:initial!important; border-right-color:initial!important; border-bottom-color:initial!important; border-left-color:rgb(67,90,95)!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0px 0px 0.5em!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important; word-break:break-all!important; color:rgb(185,189,182)!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important; color:rgb(255,170,62)!important">$taskID</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">=</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important; color:rgb(255,170,62)!important">$dj</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">->addTask(</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important; color:rgb(92,230,56)!important">"export"</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">,</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important; color:rgb(92,230,56)!important">"mysql"</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">,</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important; color:rgb(92,230,56)!important">"back"</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">,</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important; color:rgb(92,230,56)!important">"$date.sql.zip"</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">,</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important; color:rgb(92,230,56)!important">"数据库名"</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">,</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important; color:rgb(92,230,56)!important">""</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">,</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important; color:rgb(92,230,56)!important">""</code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">);</code></td> </tr> </tbody> </table> <table style="border-spacing:0px; border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; border-collapse:collapse!important; width:auto!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; min-height:auto!important"> <tbody style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <tr style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <td style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:3em!important; line-height:1.1em!important; min-height:auto!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0.3em 0px 0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; text-align:right!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:2.7em!important; min-height:auto!important; display:block!important; color:rgb(175,175,175)!important">5</code></td> <td style="border-width:0px 0px 0px 3px!important; border-top-style:initial!important; border-right-style:initial!important; border-bottom-style:initial!important; border-left-style:solid!important; border-top-color:initial!important; border-right-color:initial!important; border-bottom-color:initial!important; border-left-color:rgb(67,90,95)!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0px 0px 0.5em!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important; word-break:break-all!important; color:rgb(185,189,182)!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">?></code></td> </tr> </tbody> </table> 其中addtask的第3个参数就是刚刚新建的storage名称 第4个参数是要保存的文件名,本文设置成当天日期 注意两点: ①可以把.sql改成.csv,这样导出的就是csv格式,.zip是可选项,不加也行。 ②支持目录,例如test/$data.sql.zip就是把文件备份到test目录下 数据库名根据你的实际情况修改 3.编辑网站根目录下的config.yaml,这个用来设置cron,增加如下几行 <table style="border-spacing:0px; border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; border-collapse:collapse!important; width:auto!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; min-height:auto!important"> <tbody style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <tr style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <td style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:3em!important; line-height:1.1em!important; min-height:auto!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0.3em 0px 0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; text-align:right!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:2.7em!important; min-height:auto!important; display:block!important; color:rgb(175,175,175)!important">1</code></td> <td style="border-width:0px 0px 0px 3px!important; border-top-style:initial!important; border-right-style:initial!important; border-bottom-style:initial!important; border-left-style:solid!important; border-top-color:initial!important; border-right-color:initial!important; border-bottom-color:initial!important; border-left-color:rgb(67,90,95)!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0px 0px 0.5em!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important; word-break:break-all!important; color:rgb(185,189,182)!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">cron:</code></td> </tr> </tbody> </table> <table style="border-spacing:0px; border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; border-collapse:collapse!important; width:auto!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; min-height:auto!important"> <tbody style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <tr style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <td style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:3em!important; line-height:1.1em!important; min-height:auto!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0.3em 0px 0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; text-align:right!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:2.7em!important; min-height:auto!important; display:block!important; color:rgb(175,175,175)!important">2</code></td> <td style="border-width:0px 0px 0px 3px!important; border-top-style:initial!important; border-right-style:initial!important; border-bottom-style:initial!important; border-left-style:solid!important; border-top-color:initial!important; border-right-color:initial!important; border-bottom-color:initial!important; border-left-color:rgb(67,90,95)!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0px 0px 0.5em!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important; word-break:break-all!important; color:rgb(185,189,182)!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important"> </code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">- description: back</code></td> </tr> </tbody> </table> <table style="border-spacing:0px; border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; border-collapse:collapse!important; width:auto!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; min-height:auto!important"> <tbody style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <tr style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <td style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:3em!important; line-height:1.1em!important; min-height:auto!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0.3em 0px 0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; text-align:right!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:2.7em!important; min-height:auto!important; display:block!important; color:rgb(175,175,175)!important">3</code></td> <td style="border-width:0px 0px 0px 3px!important; border-top-style:initial!important; border-right-style:initial!important; border-bottom-style:initial!important; border-left-style:solid!important; border-top-color:initial!important; border-right-color:initial!important; border-bottom-color:initial!important; border-left-color:rgb(67,90,95)!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0px 0px 0.5em!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important; word-break:break-all!important; color:rgb(185,189,182)!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important"> </code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">url: back.php</code></td> </tr> </tbody> </table> <table style="border-spacing:0px; border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; border-collapse:collapse!important; width:auto!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; min-height:auto!important"> <tbody style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <tr style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <td style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:3em!important; line-height:1.1em!important; min-height:auto!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0.3em 0px 0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; text-align:right!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:2.7em!important; min-height:auto!important; display:block!important; color:rgb(175,175,175)!important">4</code></td> <td style="border-width:0px 0px 0px 3px!important; border-top-style:initial!important; border-right-style:initial!important; border-bottom-style:initial!important; border-left-style:solid!important; border-top-color:initial!important; border-right-color:initial!important; border-bottom-color:initial!important; border-left-color:rgb(67,90,95)!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0px 0px 0.5em!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important; word-break:break-all!important; color:rgb(185,189,182)!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important"> </code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">schedule: every day of month 00:20</code></td> </tr> </tbody> </table> <table style="border-spacing:0px; border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; border-collapse:collapse!important; width:auto!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; min-height:auto!important"> <tbody style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <tr style="border:0px!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important"> <td style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:3em!important; line-height:1.1em!important; min-height:auto!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0.3em 0px 0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; text-align:right!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:2.7em!important; min-height:auto!important; display:block!important; color:rgb(175,175,175)!important">5</code></td> <td style="border-width:0px 0px 0px 3px!important; border-top-style:initial!important; border-right-style:initial!important; border-bottom-style:initial!important; border-left-style:solid!important; border-top-color:initial!important; border-right-color:initial!important; border-bottom-color:initial!important; border-left-color:rgb(67,90,95)!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px 0px 0px 0.5em!important; vertical-align:top!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; line-height:1.1em!important; min-height:auto!important; word-break:break-all!important; color:rgb(185,189,182)!important"> <code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important"> </code><code style="border:0px!important; font-family:Consolas,"Bitstream Vera Sans Mono","Courier New",Courier,monospace!important; font-size:1em!important; margin:0px!important; outline:0px!important; padding:0px!important; vertical-align:baseline!important; line-height:1.1em!important; background:none!important; float:none!important; position:static!important; left:auto!important; top:auto!important; right:auto!important; bottom:auto!important; height:auto!important; width:auto!important; min-height:auto!important">timezone: Beijing</code></td> </tr> </tbody> </table> url就是我们刚刚新建的php文件,schedule是调用频率,我们设置的是每天的00:20调用一次。 4.最后测试一下是否能正确导出,直接访问http://域名//back.php,然后到SAE管理面板查看对应的storage中是否有备份文件。
还没有评论,来说两句吧...