Backup module - fails to create backps dir

[OrsonKart]

Hello

When I installed the backup module it gave me a couple of warnings about failing to create the backups dir.  I manually created the /backups  + /admin/backups dirs and tried to backup but got the error:


Warning: fopen(backups/backup-2006-01-24_23-17-40.txt): failed to open stream: Permission denied in /home/stones/public_html/modules/Backup/Backup.module.php on line 247
backing up database ...

    * cms_additional_htmlblob_users

      Warning: fwrite(): supplied argument is not a valid stream resource in /home/stones/public_html/modules/Backup/Backup.module.php on line 257

Any ideas where it's going wrong.

Thanks

[OrsonKart]

It wouldn't let me.  I entered 777 but when I checked, it was set to 755.  I suppose it's because the  admin directory is set to 755.

What would you recommend I change?

Many thanks.

[OrsonKart]

I actually would NOT recommend at all to set admin to 777.

I thought not 

I didn't quite understand everything you wrote, but it turned out OK.

I uninstalled the backup module and then ftp'd to my site and checked that the /admin/backups dir was still there (it was).  I checked the permissions and they were now set to 777, when I had tried to set them to 777 previously, it wouldn't let me.  Strange.

Anyway, I reinstalled the backup module and everything appears to work.

Aside from doing a backup and copying the uploads dir, is there anything else I'd need to do to be able to completely reproduce my site if disaster strikes?  I've only edited templates\style sheets from within the admin module, so I assume these are stored somewhere in the database.

Many thanks for your help.

[OrsonKart]

Thanks for that.

I've managed to get into the phpAdmin page that my host provides and I wondered if you could confirm what settings I need to enable please.

I've gone into 'Export' and have the following ticked:

Structure
I shall also tick Drop Table.
Add AUTO_INCREMENT value
Enclose table and field names with backquotes

Data
Nothing ticked here.
Export Type: INSERT

Thank you.

[OrsonKart]

God good.  I can sleep easier at night now 

Thanks for your help.