timetrex database backup error -mysqldump

[Suresh Chandran]

When executing mysqldump command, I get this error:

/usr/bin # mysqldump --tab=/home/mydir/backup --opt timetrex_db --user=root -p

mysqldump:Got error: 1: Can't create/write '/home/mydir/backup/absence_policy.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'


Installation Details:

Timetrex version 1.5.1
mysql5.0.18
php5.1.2
OS: SLES10
apache2.2.3

Can you please help resolve this issue?

[shaunw]

This is strictly a MySQL issue, I would recommend asking the MySQL folks about this error.

To start though, I would check for any corruptions in your MySQL database, and check to make sure you have permissions to write to the file you are trying to.

[Suresh Chandran]

Thank you, Shaun. You are right. I was able to execute the same command without any errors after changing the permission to the backup folder: "chmod 770 backup".