How to make rsync to use relative path?

Question

I want to sync remote database copy using command

rsync --relative user@remote:/backup/databases/*.sql /backup/snapshots/

As it's result command creates file /backup/snapshots/backup/databases/mysql.sql. How can I force it to put file in /backup/snapshots/mysql.sql? It's mandatory that source must be remote (it's part of more complex script).

Answer 1

I think you don't want to use the --relative flag, as this creates subdirectories in the target location. Have you tried this?

From the man page:

 -R, --relative              use relative path names

Answer 2

What about passing rsync the --no-relative option?