After having seriously database loosing problems, I decided to go for an autobackup system. I researched and AutoMySQLBackup looks fine.
I use Bluehost, where should I locate the automysqlbackup.sh file? I just worry about security issue. Also, where should we locate the backup files?
Appreciate! thanks a lot!
I don't know bluehost, but definitely put it outside the web root if you can. If you can't, create a new directory, put the shell script and a .htaccess file saying
Deny from all
in it. That should block it for access from outside with a 403 error - make sure you test.
Putting it outside the web root is the way better option IMO, especially if it contains sensitive data.