Things looked like they were going fine until....

Processing poll (72) : Processed 72 Rows in 0.006 seconds
Processing pollvote (2284) : Processed 2284 Rows in 0.176 seconds
Processing post (127205) : Processed 127205 Rows in 18.943 seconds
Processing postedithistory (2571) : Processed 2571 Rows in 0.629 seconds
Processing posthash (7) : Processed 7 Rows in 0.015 seconds
Processing postindex (2778108)

No errors...just froze.

After about an hour on postindex, I gave up. Apparantly, this doesn't work so well on Hostgator shared hosting.

It was worth a try. Thanks anyway Paul. I use many other mods you've created.

UNinstalling.

Thanks a lot.

So how do you set the time interval for it to create a backup? And does it create only mysql or public_html (my forums directory) backups or both of them in the backups folder?

I would like to make it per week. How I do that?

Thanks! Works great.

Got the same problem.....

Excellent - Thanks installed

Processed Database in 18.805 seconds

Backup Completed Successfully

Done

Working well for me :)

Thanks Paul,

-Patrick

Hostgator probably timeout the script (The mod trys to set it to one hour, but some hosts disallow their timeout from being changed).

Given that it took 18.9 seconds to process about 127000 rows, then 2778108 is going to take about 20 times longer (over 6 minutes).

The only way I can think of getting round this is to process larger record counts in batches. It would have to be optional as it would probably slow down the backup, and not everyone would need it, but may help your issue. I will provide a beta version for people to test later.

Worked perfectly. Great work! I know my host does daily backups, but this prevents me from having to wait until they look at a trouble ticket, etc.

goto Scheduled Tasks/Scheduled Task Manager in admincp and edit Automatic Database Backup for vBulletin settings.