How to setup a cron job to do data backup task from my localhost to a VPS?

Suppose I’ve this backup server which stores all my backups. I run a php based website on localhost which is connected through LAN with my backup server. All the CRUD I perform on my website is then saved to my backup server.

Q1. Now the question is I’ve to setup a cron job so that the backed up data on my backup server which is you can say a file with sql extension(Exported from phpmyadmin) is then perform a import in phpmyadmin(which is of my VPS host on the Internet) on a scheduled time ?

Q2. With Laravel how this can be possible ?

Q3. How to write a cron job in php to upload files to my google drive automatically at a scheduled time?

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.