备份代码和数据库的最佳方法是什么？

Question

So what can be best way to have a Backup of code and DB is it downloading Locally via http ? But i fear it is security risk as some hacker might get access to it .

I am looking into compress then encrypt the compressed file. But i dunno what encryption i should use and if linux CLI tool available for password protected encryption ?

Thanks Arshdeep

Answer 1

If you're worried about transports, use SSH. I tend to use replication over an SSH tunnel to keep a MySQL database in sync. A backup of the version control server (which is not the same as the deployment server) is passed by rsync over ssh. If you want to encrypt files locally you could use gpg, which would of course not work in tandem with the database replication, in that case you'd be forced to use a dump or snapshot of your database at regular intervals.