Processing poll : Total Rows = 24
Processing pollvote : Total Rows = 291
Processing post : Total Rows = 86239

it is cutting the process here.

I changed my time out period like this

max_execution_time 200

mysql.allow_persistent On On
mysql.connect_timeout 600 600
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

I think i have a different problem.

max_execution_time is set to 60 on our server, post has over 750,000 rows. Whatever your problem is, it's server related.

I've been testing with mine, it reaches around 13mb mark before stopping, I managed to trim some old tables from the database, but it still doesn't reach the end - max_exec time is set to 60 on my server too - this is just so damn frustrating, i realise this isn't your problem, I'm just so desperate to be able to make daily backups automatically!

Thanks,

Jason

Just did a short test on something; I used my phpMyAdmin to backup the database - it didn't complete it, cut off around the same place as it would with the VB Backup, then I used my host's version of phpMyAdmin which backed up it fully!!

Just for reference - my version backed up around 13mb, my hosts did a full 24mb.....

Hello,

First I want to thank Paul M for this backup plugin, it's working very nice on my Windows server!

Now I got a request, or question, well actually 2:
I would like to compress (zip or rar) the folder containing the .sql files after the dumps have been completed.
Plus I would like to keep a history of atleast 6 previous backups on the server (I don't have the posibility to FTP/move the files to another location), and that the script automatically deletes the oldest backup.

Unfortunately I am unable to code this myself, is there anyone who can help me with this?

I have a newbie question. I get the following error:

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

I have chommoded the folder to 777. Did I not input the config.php file correctly?

here is what I have: DIR.'/home/sole/backups/

Is this correct? Thank you

No, DIR is the path to your forums, you are then appending that with another full path, change it to just '/home/sole/backups/'

Good system to have, just lacks the Gzip option, which is a shame.

Paul thanks for the mod

i have small problem, when i started to back up it reach up to Processing posthash : Total Rows = 0
Processing postindex : Total Rows = 585217

then stops !!!

any idea??

paul ... the problem solved :)

MySQL Backup was completed successfully with no errors.

thanks again