I'm working in a location with a physical server, and the company I am working for is in a different location, and has a cloud server with a different address.
Database backups work using automysqlbackup script in the cloud server also. But the database backups that I want to pull from the cloud server is quite huge and cannot be exported to my local server using phpMyAdmin.
So can I use the scp command in the crontab to pull the backed up database daily into my local server? , i.e :
* * * * * scp -r [email]root@cloudservername:/backups/databasename.sql.gz[/email]