Coldfusion 和 mySQL - 寻求通用和异地备份策略的建议
CF9、Windows Server 2008 Standard、IIS7、mySQL 5.1.48 社区。
我已经设法让 CF 获取一个数据库 mySQLdump，我将其作为每晚 cfschedule 任务运行，并在 application.cfc 中控制的应用程序上设置基于服务器时间的锁定，
这将为我提供一个本地副本，但最好的策略是什么加密 datadump.sql 文本文件（以及您将使用什么来加密敏感个人信息）并传输到异地位置 cfftp？
CF9, Windows Server 2008 Standard, IIS7, mySQL 5.1.48 community.
I have managed to get CF to take a database mySQLdump which I was going to run as a nightly cfschedule task, with a server time based lock on the application controlled in application.cfc
That will get me a local copy, but whats the best strategy to encrypt the datadump.sql text file (and what would you use to do so for sensitive personal information) and transfer to an off site location, cfftp?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
对于我的个人网站，我使用 ColdFusion 计划作业来运行 mysqldump，然后将更新的备份存储在 Dropbox 帐户中。我从来没有费心加密备份，尽管这看起来确实是一个潜在的危险。如果加密文件损坏怎么办？那么您甚至无法从文件的未损坏部分进行部分恢复。
For my personal sites, I use a ColdFusion scheduled job that runs a mysqldump, and then stores the updated backup in a dropbox account. I've never bothered encrypting the backups, though that does seem like a potential hazard. What if the encrypted file becomes corrupted? Then you can't even get a partial restore from uncorrupted sections of the file.
难道windows的计划任务备份和EFS不能加密吗？
Can't you windows' scheduled tasks for the backup and EFS to encrypt it?