I want to transfer a mysql dump, compressed, to s3.
I tried:
mysqldump -u root -ppassword -all-databases | gzip -9 | s3cmd put s3://bucket/sql/databases.sql.gz
but then I get:
ERROR: Not enough paramters for command 'put'
How can I do this (in one line)?
Best Answer
This is possible with
s3cmd
1.5+ (link):$ mysqldump ... | s3cmd put - s3://bucket/file-name.sql