Thanks Paul for answering
i change it on my php.ini to 120 sec and i got
Database error

but on the v3.8.001 : First version for vB 3.8. i never had error
and the execution time was 30 sec too

Please post the full sql error message.

hello paul
here is it
Thank You

Thank you paul
its working now

after i change the search option to full text search

so it seem that it cant backup when the the forum use the database serach option

That error means your mysql connection timed out - you probably have a very low timeout value.

heu paul
Thank you again
do u mean
mysql.connect_timeout ?
cz i have it -1 means no limit

No, mysql wait_timeout.

oh i dont think this is in php.ini
i think its the host thing

Thanks for replaying paul

have a nice day

how do i make it so only i can access my backup?

Store them in a place only you can access.

for example?

like right now i have the folder set to 777, which means anyone can access it........ >.> that doesn't seem safe to me
how do i make it so only some1 with the password can access it? (or shuld i just make it into a random directory like....

public_html/alkjal3oo3dDDDie3/backups/
?

No, you use a directory outside of public_html.

how would i do that?

right now i have it set to this
./backups/

hmmm?

still waiting? would the directory be something like....

home/silabgar(my host name)/backups
???

I cannot generally answer server specific questions. Normally you would create a backups folder in the same location that your public_html is located, and reference it by ../../backups (which is the default setting).

u said that, how would i do that

Paul,

I installed this. I have a backups folder in the same level as my public folder (in which my forums reside). It has correct write permissions.

I tried running this and get : It has no actual error message and I made no changes to anything in your files.

Can you provide any help?

*edit* - fixed per post 318.

Regards,

From a restore standpoint, is it better to backup with your default separate tables or lump them into one? I've only restored with a xxxxx.sql.gz previously and was wondering what was the better way when using your method? I do have to untick 'extended inserts' when backing up manually and restoring via 'bigdump'.

Does this backup include extended inserts?

No, this does not use extended inserts.

Personally I prefer to backup one file per table, so that if I need to restore one table I can do it easily.

If I need to restore them all then its easy enough to combine them all into one file first.

Excellent. Thanks a lot

I installed it, I did not modify the config files.

I created a backups directory under the /public_html
I set the permissions to 777

When I click "Run Now" I get the following error:

I set the permissions to 777

Automatic Database Backup for vBulletin

An error occured during the Backup :

I changed the path to ././backups/ as defined in a previous post and still get the same error.

I do have the backups directory right under public_html Do I need to specify the entire path?

I know I am screwing something up, not sure what though.

The path would depend on what path your forum is - but on a typical setup, from the info you have given, I would suggest you try ../backups/

Thanks, the forum is located under /public_html/forums

So should I create the directory under forums or public_html?

Thanks man, I got it working.

the backups directory needs to be under the forums directory when you use the ../backups/

Thanks again!

Great mod ! Btw, how can i set it up so it doesn't keep anything but last 3 backups or so ? The database is really big and if i forget about backups, it takes too much space :) Thx in advance !

Using the vB default "database backup" causes error frequently. Does this hack also ends up in error or this is safe to use?

We really need a way to change how many backups to be kept on server. I just got my drive full... and when i checked, it was filled with sql files made by vB Database Backup... Please, can you find a way for this ?

This has already been posted before - but you can change the backup date options to limit the number of files - for instance I use a lowercase L, which means they are called Monday, Tuesday etc, so you only ever have 7 files - after that they overwrite each other. You can use other options (such as the day of the month).

I don't understand what you mean. If i go in my Scheduled Task Manager and look for Automatic Database Backup for vBulletin i can only set what day of the week, day of the month and hour i want to backup. I don't understand how can i limit the number of files (what lowercase L means ? where do i find that ?)...

Paul, i'm also interested in doing this, i have my cron job set to every sunday, how do i get it to overwrite the previous weeks entry?

vBulletin Options > vBulletin Automatic Backup > Date Format

(Setting for Backup file date format ).

As above - if the generated filename is/are the same, it will simply replace the existing file(s).

Hi paul, i currently use this mod and it's already saved me a nightmare!, however i wanted the back-up performed every Sunday, you kindly gave the solution of using a lowercase L, i do now get a backup every sunday but it's a single file where the ones before gave me a dated folder with each component backed up separately, how do i get back to having each element backed up as before but just on a sunday?

Great add-on. Thanks OP.

Just set the vb cron job to run once a week (on Sunday) using the standard date format.

getting this error:

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

Suggestion:

Daily backups are great but unless I download the backups and delete them promptly they eat up my disk space allowance on my host. The ability to do a backup on multiple selected days of the week would be really useful. It would let users back up weekly or twice a week, say Monday and Thursday, or any other combination of days that suits.

At the moment the only alternative to daily seems to be monthly and thats a bit risky imho.

Thanks for the update with gzip. I also just set my date code to 'l'. I used to go in weekly and delete all but 2 backups and now I don't have to anymore. Truly automatic! It does take up ~ 2.5 GB buts that's a small price to pay

Paul, i love this mod and couldn't live without it now but i do experience a small problem more often than not, when using the option to close forum during back up i'll find that i sign on the next day and find that the forums are still closed, i then have to turn off your mod, CLOSE the forums in vboptions (yes i know its already closed) then open the forum again and reinstate your mod, any idea what could be causing the lock up, is there some way of adding an extra check to see if the back up activity has stopped then make the forum closed status time out?

Right now i leave the option off but it could spell disaster eventually as my database is over 2gb.

That option has always had issues, and as I didnt write it, ive never had the time to look into why.

I suggest you simply dont use it (I dont). It was removed from the 4.0 version.

You can always use the lock tables option, but only do it at a very quiet period as visitors will experince the forum hanging while you do, and eventually you will start to get "too many connections" errors as the mysql process queue backs up waiting for write access.

Thanks for coming back to me, i've also turned off the lock tables too now as i don't want to get a barrage of database error emails :)