error when running mysqldump

I try to follow the tutorial on how to perform a backup (http://bitnami.org/article/how-to-backup-and-up…, i run into the following problem.

I run the following mysqldump command from the BitNami Redmine Stack console (exactly following the tutorial:

But i get the error:

-bash: redmine_backup.sql: Permission denied

I’ve tried to add sudo in front of the command, but gets the same error.

I run the stack on amazon.

I’m a newbie on the linux commandline, so it’s probably a simple mistake i make – please help..

Hi,

It seems that you do not have write permissions in this folder. Try to create the sql dump in /tmp/redmine_backup.sql:

$ mysqldump -u root -p XXXXX > /tmp/redmine_backup.sql

Cheers

i still gets the same error:

bitnami@ip-xxxxx:/opt/bitnami/apps/redmine$ mysqldump -u root -p ‘xxxxx’ > /tmp/redmine_backup.sql
bq. -bash: /tmp/redmine_backup.sql: Permission denied
bq. bitnami@ip-xxxxx:/opt/bitnami/apps/redmine$ sudo mysqldump -u root -p ‘xxxxx’ > /tmp/redmine_backup.sql
bq. -bash: /tmp/redmine_backup.sql: Permission denied

My password contains an exclamation mark, so i enclose the password with single quotes:

-p ‘password’

Is that a the correct way to define the password then?

Hi,

It seems that you do not have access, try to use the option —password=“xxxx”. Also check if you MySQL port is 3306, if not you should also specify the port using the -P option.