Multiple Mysql databases backup tool? My OS is Ubuntu 10.10. I have several small sites (all on various shared hosts) and I'm thinking that it'd be probably good idea to regularly backup mysql databases from these remote shared hosts. I currently do it manually and it seem to be while not laborious but definitely boring process (phpmyadmin). How should I go about it (no ssh access available)? If do it like this: mysqldump -u root -p[root_password] [database_name] -h mysql_host > dumpfilename.sql Does that mean that password is being transferred in plain text?

Specifying the password that way is just insecure on your machine. Over the network it's just the same way that MySQL clients connect to your database. As far as I read, the username and password are hashed, so you are not sending your password in plain text.

In your situation I would write a simple wrapper script, something like


for host in host1 host2 host3
do mysqldump ...
done