Error Message when making a backup:

[Threshold]

I got this error message when making a backup of my vBulletin:

Warning: fopen(./forumbackup-05-20-2003.sql) [function.fopen]: failed to create stream: Permission denied in /home/threshol/public_html/forums/admin/backup.php on line 264

DROP TABLE IF EXISTS access; CREATE TABLE access ( userid int(10) unsigned NOT NULL, forumid smallint(5) unsigned NOT NULL, accessmask smallint(5) unsigned NOT NULL, importaccessid int(10) NOT NULL, KEY userid (userid,forumid) );

Warning: fwrite(): supplied argument is not a valid stream resource in /home/threshol/public_html/forums/admin/backup.php on line 268


What does this mean?

[Threshold]

Incidentally, despite the messages, it seems to have worked. When done, it gave me this message:

Dumping word

Warning: fclose(): supplied argument is not a valid stream resource in /home/threshol/public_html/forums/admin/backup.php on line 271

Data dumped sucessfully!

Should I not worry about the error messages?

I would hate to think I am making useless backups.

[Floris]

If you used second option to write a backup to the web server, then you must first create a directory outside of the public web section. And then chmod it to 777 to have write rights on it.

Then goto the vBulletin admin control panel and backup section, make sure all the tables are 'checked' for backup and goto the second option 'write to web server'

Enter the full path there.

I.e.

* Login with your ftp client to your web server
* Make sure you are in this directory
/
* Mkdir (make a new dir) called db_backup
(so you have /db_backup/)
* Chmod this directory 777
(most ftp clients let you right click on the dir and either use chmod or raw command to set this)
* Login to your vBulletin admin control panel and goto the backup section and fill in this path:
/home/threshol/db_backup/forumbackup-05-20-2003.sql
* and process it by clicking on the button.
it might seem to 'freeze' for a moment, but it will be done when it says 'dump successfull' at the bottom of the page (and then you are done)

Good luck.

[Floris]

Make sure your .sql backups are NOT in ANY public directory. Everybody who can browse in your /public_html/* directories, can download the .sql by guessing the filename and then they have all your usernames and all their passwords (even though encrypted).