Some hosting systems (Plesk being an example) have default open_basdir settings that prevent the webserver writing to any files outside the domains root html folder. You have to check/change them.

the script stops after the largest table in database. How to overcome this?

thanks

This may be unrelated to the backup itself, but right after this runs each morning my db/site seems to be having trouble restarting correctly. This doesn't happen every time but lately has occurred several times per week. Only the forumhome page starts correctly but all other pages have errors and won't display their content (just lines of errors). When I go in and turn vB off then back on, all pages display correctly. The errors occur right after the backup completes. Is there a command I could add to the end of the backup config file that would perform this restart procedure after the backup is completed?

How big of a database can this backup?

Thanks :)

There is no limit other than what your server can handle.

Okay thanks, but I am somewhat confused. Their is the option of SSH backup and that can do big database backups, now with this one isn't it a script and could it "time out" on big databases?

I am somewhat new to database backups and don't fully understand them, so say my database is 500mb , this can back it up without timing out and would do a FULL backup?,

now what do you mean "other than your server can handle"???

Sorry for all the questions, I truly appreciate the help :)

I have a question, this may sound stupid however:

the backup isnt just 1 sql file, say I wanted to restore the database, would I have to load each .sql file that this backup saved?

Say I had a database error, how would I go about restoring the database?

sorry just trying to figure out how to use this since im used to the 1 .sql file

When this backs up it put the sql into seperate files and not into a zip or something, how would I re-upload the database now???

Thanks :)

As per the many previous posts on the subject, you have the choice to backup to a single file if you wish.

Sorry found out how to do it now, wow!, this backs up the database so fast, how come it is this fast, it took like 3 seconds to do a backup, whereas I used another script and it took like 1 minute.

I downloaded the backup file and it was 15 mb, now is this too large for a database?

Now sorry but I have to ask this, how would I go about restoring the database from this 1 file?, please I need to know this.

Thanks :)