Permissioning required for backup to work?

[Swakoo]

Hi guys,

I tried the backup feature for files and mysql, and bumped into some problems, hopefully some people can enlighten me:

1) MySQL backup

_QUERY_ERROR_Access denied for user 'user'@'localhost' to database 'dbname'

My user has only SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER rights. Is there any other that he needs, for this function to work?

2) Files Backup

Warning: FileBackup::MakeBackup(zip.php) [function.MakeBackup]: failed to open stream: No such file or directory in /home/phinger/pligg/libs/backup/file_backup/backup.php on line 8

Warning: FileBackup::MakeBackup() [function.include]: Failed opening 'zip.php' for inclusion (include_path='.:/usr/share/pear') in /home/phinger/pligg/libs/backup/file_backup/backup.php on line 8

Fatal error: Class 'Archive_Zip' not found in /home/phinger/pligg/libs/backup/file_backup/backup.php on line 34

I have tried chmod 777 to the path already but to no avail. Something else missing? do i requrie additional extension for this to work?

thanks!

[Swakoo]

update:

I have allowed 'lock tables' for the user and now it shows a script error

Warning: touch() [function.touch]: Unable to create file ./backup/MySQL-Data-Backup-phinger-2006-10-17 17-21-53.sql because Permission denied in /home/phinger/pligg/libs/backup/mysql_backup/libs/backup.class.php on line 252

Warning: fopen(./backup/MySQL-Data-Backup-phinger-2006-10-17 17-21-53.sql) [function.fopen]: failed to open stream: Permission denied in /home/phinger/pligg/libs/backup/mysql_backup/libs/backup.class.php on line 253

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/libs/backup.class.php on line 254

Warning: fclose(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/libs/backup.class.php on line 255

Warning: fopen(./backup/MySQL-Structure-Backup-phinger-2006-10-17 17-21-53.sql) [function.fopen]: failed to open stream: Permission denied in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 57

Warning: fopen(./backup/MySQL-Structure-Backup-phinger-2006-10-17 17-21-53.sql) [function.fopen]: failed to open stream: Permission denied in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 259

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 266

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 268

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 266

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 268

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 266

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 268

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 266

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 268

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 266

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 268

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 266

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 268

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 266

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 268

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 266

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 268

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 266

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 268

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 266

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 268

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 266

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 268

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 266

Warning: fwrite(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 268

Warning: fclose(): supplied argument is not a valid stream resource in /home/phinger/pligg/libs/backup/mysql_backup/mysql_backup.class.php on line 272

[StingingNettle]

I'm getting the same error. I changed the directories to 777 as well. What do I need to change to fix this? Is it pointing to the wrong directory?

[dbaker]

I was getting the same error:

Warning: touch() [function.touch]: Unable to create file ./backup/MySQL-Data-Backup-pligg-2008-10-09 10-33-13.sql because Permission denied in /usr/local/apache2/htdocs/pligg/libs/backup/mysql_backup/libs/backup.class.php on line 252
.
.
.

I did chmod 777 on pligg/backup and that fixed my problem.