If you have put /public_html/backups/ then it will be trying to look for that at the root of your server. Its usually best to use a relative path, like ../backups/

Automatic Database Backup for vB 3.7

An error occured during the Backup : Could not open Destination SQL file for writing.

Thanks paul, that worked.

I clicked run now, and it's created the folder with .sql files for each table :):)

Although it didn't close my board when I opened it in a new tab.

Thank you very much!!!

Regards Jason :)

Provided the config file's destination path is correct, did you ch mod the backup folder to 777?

H Paul, one more question:

What would I set the cron job to, so that it starts the backup, 4am every night (UK time)?

Regards Jason :)

Path is correct $backup['DUMP_PATH'] = '/var/www/vhosts/xxxxxxx/httpdocs/backupdat';

Folder mod to 777

As I told the other member, try using a relative path, not the full path.

What would I set the cron job to, so that it starts the backup, 4am every night (UK time)?

Regards Jason :)

I dont understand what you mean, besides the obvious answer that you set it to run daily at 4am ....

I edit "Automatic Database Backup for vB 3.7" under "scheduled Task Manger". Day of the week is set to *

Day of the month: *

Then do I set hour to 4 and minute to 0, so that it does it 4am UK time?

Regards Jason :)

this support large databases tables ? because i tried some auto backup scripts but they didnt complete backup the database. My tables are so long .

SSH rlz :)

p.s: my database about 1gigabyte .

If I remember rightly - it does.

Regards Jason :)

Get this error:
An error occured during the Backup : Could not open Destination SQL file for writing.

and tried it with

../backups/

and with

/home/xxx/yyy/backups/ (provided by filepath.php)

always the same error message

Yes.

Hi Paul,

Is it a good idea to have it in a web accessible area? I have mine at public_html/backups ... and I don't think this is a good idea, as anyone can then download your backups .sql.

Where is it best to have it, and what path would it have?

Regards Jason :)

any idea why I get this:

An error occured during the Backup : Could not open Destination SQL file for writing.

and tried it with

../backups/

and with

/home/xxx/yyy/backups/ (provided by filepath.php)

always the same error message

No, its not a very good idea and should be avoided if possible.

If you cant then at the very least you should use an htaccess file to stop people accessing the folder via the web.

Yes, I've changed it too: /home/user/backups ... all looking good.

Once again, thanks for this great hack ;)

Regards Jason :)

thanks

60MB database it didnt backup even 50% of the table. Yes i Did try with the "mysqldump binary option"

Sorry but if it failed then the problem is local to you. My database is 10 times that size, and Ive tested on even bigger.

Does this work now or not? I was never able to make an update and upload the data to a new Database since I have this vbulletin. I always get SQL errors when I try to upload the database to a new one. I have also tried it according to the vbulletin manual. Anbody has some ideas?

Not really sure what you mean by that. This has worked since the day it was released - and runs my backups every night (and has done for a few years now).

cool...does the normal backup which comes with vbulletin work for big tables? It never worked for me even if I do it according to the manual...

I cannot comment on the vb system, never used it.

Very nice simple mod that work's great. "Clicks Installed"

Just a quick question. I have this set to save as one file but when I save directly through the vbulletin backup that file is larger than the one this generates. I have run them both at the same time.

For instance.. On my test installation I get the following:

Directly through vbulletin: 6.20M

Through this script: 6.13M

What exactly is this leaving out? Just curious and wanted to make sure this is a true backup. This is pretty cool and very useful for those of us who always forget to backup!

I don't know for sure but my guess is that this might only be backing up vBulletin tables whilst the method built in will (by default) backup everything that has a table (plug-ins etc)

I just installed a few mods from .org onto the test board and those tables were saved. The sql file sizes are still different though. I imported the sql from this mod into a new database and ran from that. Everything seems to be working so im not complaining! :)

Different methods will produce files of different sizes, it depends on what comments are added and what method exactly is used.

Thanks Paul. So as for the forum data, there is no data loss? I just get paranoid with this stuff so thats why im asking! =) I nominated this as MOTM since this can save all of us major headaches down the road. I never remember to backup!

How would I create a htaccess file to prevent people from accessing the backups from the web?

You should really save the backups outside of the web directory.

Yes, you should.

I have mine at:

/home/user/backups

Regards Jason :)

Thanks Paul, will be installing this in the next few days.

This Is A Better Version

Thank Paul

I would love too but I couldn't get it working if it wasn't in the public_html directory. I'm not sure what the path name should be.

erm, nevermind. I figured it out. Working great now.

Can you get this run every two nights at 4am? If so, what settings do you use?

Regards Jason :)

It uses the VB cron system so you can [only] do anything that is capable of.