Is it possible to use this script and a cron job to back up multiple databases to an external hard drive such as My Book.
In the script you change BACKUPDIR to point to a directory on the MyBook
assuming that you named the backup script mbackup.sh the following cron entry will run backups at 2:15 every morning
15 2 * * * /u/me/mbackup.sh
One last thing... the external drive is on a different drive i.e G drive, how would I set up the path to that?
That sounds like it is on a PC. Can't help you there.