I am the web administrator for a small company. We host our website on our own server. The site runs on PHP and MySQL. I access the server via SSH.
I am not very familiar with UNIX/LINUX commands, but I was given instructions by the previous web administrator on how to back up the website. Basically, I need to export a mysqldump operation to a .sql file on the server, then move it to a local, secure location. I back up the website via the zip operation and download that via FTP.
I do not have access to the Apache server configuration so I cannot enable shell commands in PHP. However, I would like to write some kind of simple batch-style program that can access the shell, log in, and run a series of commands automatically. Then the administrator can simply download those files off (or, better yet, the downloading process could be automated as well).
Is this even possible? If so, could you direct me to where to start to learn about something like this? I don't even know what to search for.
Thanks so much.