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.sqlDoes that mean that password is being transferred in plain text?
Multiple Mysql databases backup tool?
linux;backup;mysql
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 likefor host in host1 host2 host3    do mysqldump ...done