anand4linux

I think Geuis wants the script to access the remote mysql database, not himself from his local machine. In that case he needs to grant permission for the "mysqluser" to access the database from the "ip of the server which has the php script" something like this... mysql> grant all privileges on dbname.* to 'mysqluser'@'<ipaddress or servername' identified by 'password' with grant option; Anand S

Thanks Bruce, Thomas, Don, and Tim, I'd post a better sh script, but I think shell scripts are against your AUP. Anand S

dude, I read the script and i dont think is worth the time discussing or editing the script You can do this. /usr/bin/mysqldump is normally having execute permission and if TCH has not changed it you can run this from bash . mysqldump --databases DB1 DB2 ....... > $HOME/mysqltestdump.`date +%d-%m-%Y` this will create dumps when ever you run the above command, and if you need to delete previous older ones, its just a couple of lines . No need for the script being discussed above Anand S Earlier remote sysadmin