You prob arent getting enough members visiting at the time its set to run to trigger the cron system.

OK, thanks.

The option Repair Tables also includes optimizing them?

Are there now no mysql datas needed?

I have the problem that the cronjob stops during the backup and that not all tables are backed up than.

Yes.

Sorry, I dont know what you mean by this.

Then you have a server issue that you need to look into.

I have a webhosting package... so i can?t look into the server configurations.
Is there another way?
Perhaps combining all tables?

If its timing out then combining them isnt going to make any difference.

Okay, and now there isn´t any soluting?

I have installed and tried to run manually and get

An error occured during the Backup

I have uninstalled and reinstalled and still the same

very useful, thank you

I have one question, sorry if it has been asked in one of theses 15 pages. I just upgraded to 3.8.002. My backup path was ./xxx/backups/ inside the forums directory. Such as public_html/forums/xxx/backkups/. What would I enter to have the back up be up one level from the public_html. Such as home/account name/

Use a relative path, such as ../../backups/

Thanks Paul, how do you run it manually to test?

Just go into schedule manager and run the task.

Thank you installed.

installed. ..

where can i set the predefined time when the backup should occur? i want the backup to be done everynight at 2am... where is the setting for this?

In your scheduled tasks.

thx paul... i am new to vb so sorry for asking the dumb question again... does this backup tool also suffers from the php/mysql timeouts for large databases?

That depends on how your server is configured.

thanks and all workin now....hope so....having error using this ../../backups/

instead use this ././backups/ now its all okay...

will see how it work auto tommorrow...one thing is this going to have only 1 fresh backup daily? not the old way to have the daily back up files?...so everytime it backup our database...it gonna change the old one with the fresh and latest one?
if it is...great and better than before..


i'm not getting this...

InnoDB Tables
Set to yes if you have any innodb tables
...care to explain this pls.


million thanks Paul M

;)

Thanks paul the auto backup is good

This is a fantastic hack, I have it installed and being automatically downloaded every night in the early hours using a download manager, 100% working been waiting for something like this to tweak for a long time...

BZ

Hi can someone please answer a quick question for me!

A couple of weeks ago my host gave me a fresh install due to a confliction with my database i couldnt access the ACP panel, anyway when they re-installed the boards they added a back up file public_html_backup on my server, now my question is do i need to install this mod to gain a back up or does my site automatically back up anyway thru this new folder as i just looked in there and there is everything i have on site in the public_html_backup folder

Sorry for the question if it sounds dumb but im new to vb so still learing how to deal with mods etc

Thanks in advance! :)

thx paul for your reply... i have another question...
i always backup my db as a single file. But this mod creates a separate folder for each backup which is not needed... is there any setting so that every backup goes into the same folder?

Yes, (in the settings ...... :))

Paul, What's the cron to use? I can't find it anywhere.

Thanks

thx paul..
but i cannot find the settings .... in vb options there is setting for automatic backup but i could not find what i want... can you please pin point the setting.... thx a lot for your time :)

vBulletin Options > vBulletin Automatic Backup > Combine Files

thanks paul...but to complicated for like me to understand it...LOL :p

that i already did... let me explain it more clearly...

my backup folder is /home/xxxx/forum_backup/

now inside that forum_backup folder i have several folders
forum_backup/2009-08-31/Form-2009-08-31-full-backup.sql
forum_backup/2009-09-01/Form-2009-09-01-full-backup.sql
forum_backup/2009-09-02/Form-2009-09-02-full-backup.sql

so you can see that every day a new folder is created of that particular date... Creating new folder for each backup make sense when you are NOT using combined files...

so what i want is the all the backup files should go into the forum_backup folder and do not create separate folder for each date..

thanks!!

Sorry, each will will have its own folder, whether they are combined or not.

hmm... ok... but please include this feature in your next version... it should be very easy for you to code it :)

Since I agree with you, thats quite likely to be changed for the 4.0 version.

i'll agree to this adjustment. I was looking for the option to do this and came here to ask....voila! someone else asked it first :)

*waits for next update* :)

YES! me too and that will be great not to have more and more file of back up on that folder...maybe it will be great also if it possible to auto delete tha old backup and replace with the new one....so it means we have always a fresh daily backup on one file only...

hope this will happen or implement if only possible on the next version

anyway this is one hell of a great mod and in fact very useful to our site.....

;):up:

Hello,

I copyied the files in the includes folder on the server. And the settings as per the instructions. But, when i run the process manually it just gives an error :-

An error occured during the backup:

Please help

Well..i changed the path..and the process started smoothly.

Only problem i have now is it stopped on the forum_user (519) table.

what can be done? Help appreciated. Thanks.

No idea, why did it stop ? Did you get an error ?

can you use this on very large DB like 500 to 1GB?

My database is bigger than that.