I have a server running Ubuntu 10, it mostly has PHP websites with MySQL databases.
I need to write a backup script
- to backup the database
- to zip up all the php files.
Is it better security to do write my backup script in PHP or shell? Or does it not matter?
I like PHP more, because that lets me have the database password in only one place, a PHP file.
If I write this in shell, then Ill need to put the database password in the shell script. When I change the password, then Ill need to change it in two places.