16 Jan
2008
16 Jan
'08
5:49 p.m.
Consider: rsync -avz user@host:/var/lib/mysql /var/lib/mysql
Assuming the files I want to transfer are owned by mysql (both locally and remotely), and are not world-readable, how do I achieve this?
I can use sudo at the local end: sudo rsync -avz user@host:/var/lib/mysql /var/lib/mysql .. to give me the necessary write access to /var/lib/locally, but how do I give rsync read access to the files at the remote host? The mysql user does not have login rights and therefore does not have a password, so I can't just use mysql@host, and there is no root user at the remote host either; if I wanted read access at that end I'd use sudo to get it.
Local end is Ubuntu, remote host is FC4, if that's relevant.
--
Mark Rogers // More Solutions Ltd (Peterborough Office) // 0845 45 89 555
Registered in England (0456 0902) at 13 Clarke Rd, Milton Keynes, MK1 1LG