Keywords: MySQL - AWS - Technical issue - Permissions
Wishing to download mysql database files located in /opt/bitnami/mysql/data/databasename from from AWS Bitnami Linux installation to a local Windows machine.
Executing following command from local Windows machine:
scp -i \path\awssc.pem ubuntu@ip:/opt/bitnami/mysql/data/databasename/*.* .
Receive "scp: /opt/bitnami/mysql/data/databasename: Permission denied" error. Have changed owner of /data/databasename directory and all files within /data/databasename to unbuntu and bitnami and still does not work. (Have tried username in scp command as bitnami as well.)
How to transfer mysql files via scp so a backup can be obtained?