Here is the error i get:

Database error in vBulletin 3.0.7:

Invalid SQL: LOCK TABLES `access` READ, `adminhelp` READ, mysql error:

THE REST DELETED

Access denied for user: 'xxxxxxxxx@localhost' to database 'xxx-xxx_forums'



mysql error number: 1044

Date: Tuesday 22nd of March 2005 09:30:44 AM
Script: http://xxxxxxxx.com/forums/admincp/c...cron&cronid=17
Referer: http://xxxxxxxx.com/forums/admincp/index.php?
Username: paratek
IP Address: xx.xxx.xxx.xx

1. Try turning off LOCK tables, in the configuration first.

You might not have LOCK priviledges or something.

Ok Progress...i turn off the lock feature, and using mysql type backup i get the Failover was initiated for MySQLDump Binary but backup was succesfull error....however, i can not find the backup anywhere. If i change it to php dump built into the program it does work and the backup file is in my directory. I am just concerned that i am turning locks off, as you said it was not recommended.

One last thing, and i am sure it was not the intended use of the program to manually do backups with it. Any backups i do on the same day, are just written over, as the file name format is saved using the date. If i do 1 backup per day, fine, it just saves the file as the next date. If i do multiple backups in one day, they will just get written over.

Yes you are correct, the main function is cron. Until I create an actual "webpage" based center for the script, its running the cron function everytime you click "Run Task". So it's doing its intended job, by running the cron function.

When I finish making the AdminCP based page for it, you will be able to test different settings, customize backups, do individual dumps etc...

Note:
Yes, not using locks isnt as secure.. but if you have the shutdown forum option enabled, that is almost as good. Its basically turning the forum off to your members while the backup is in progress; that will prevent anyone from writing to the database. So, it Is your 2nd best option, just make sure its enabled.

Well thanks for the reply. Just smacked the install. Last question. What happens to the users already in the forums when the cron starts and shuts the board down? I haven't been able to test this myself yet.

They will just get a page notifying them the board is temporarily closed, its built-in to vbulletin.

Marvellous!

All working fine now...I can only assume my path was a bit bung..I have /backups directories dotted around the server, but it didn't find them. :)

Thats good to know :), was hoping it wasn't my code lol..

Good job :)