vB Database Backup
 

Note: Because I did not write the original version, but rather have modified & adapted it, support of this modification may be limited

When vb 3.5 first came out I was using this backup system on my vb 3.0 - and having nothing better to use - I converted it to work on vb 3.5 (here) and since then I have cut it down and adapted it, first for vb 3.6 and now for vb3.7.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. In 2007 David gave me permission to release my adaptation.

I have stripped out much of the extra stuff that I do not use (or indeed, could not get to work). This is a simple (lite) version that does a php based dump of your database either as one file, or one file per table.

Notes:
* I will not add anything new to this, or spend vast amounts of time supporting it.
* This is a Lite version to allow people to use the basic backup functionality on 3.7.


History:

v3.7.001 : First version for vB 3.7.

Thanks
OK

i hope this version not make new tables as i saw in my db when using this hack whick make thousand of tables with same name but in different number

Look's like it can do both ....


This is a simple (lite) version that does a php based dump of your database either as one file, or one file per table.

Its always done either.

[high]* projectego clicks install :)[/high]

thanks very good

Nice, thanks.

i always forget to do them myself :D

It does not act me.

Hello,

I do not, or is my backup to FTP !
Can you help me ?

Thank you

Not really sure what you are asking, but this cannot backup to ftp if thats your question.

Thanks Paul. :)

great hack thx

Does it work for vbb 368 too?

There is a 3.6 version in the 3.6 forum.

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

Where do you tell it to backup to? I can't find anything.

Its a setting in the config file.

What one ? I'm getting the same

Cancel that found it ....


$backup['DUMP_PATH'] = '/xxx/xxx/backups/'; // Path to backups folder, must have a trailing slash

Might as well just set up a cron job.

https://vborg.vbsupport.ru/showthread.php?t=169550

Regards Jason :)

This is a cron job, no need to promote your own articles in peoples threads.

Composite excellent work
Thank you very much

so is this in lieu of using the backup in the acp?

if i use this, will be easier to use the file from this script to upload to lets say a new db and new installation of my site? cuz i know the one in the acp that comes with the forum sucks and i could never get it to actually work, always having to start from scratch.

Excellent

Has anybody modified this to compress the file after making the backup?

Hi Paul,

I've set everything correctly, for the cron job -- I do that in my hosting cPanel right?

Does this backup every table?

Regards Jason :)

No, just install the product via your ACP panel. Fill out the required information in the mysqlbackupconfig.php file and you're done. To edit the cron job once you have done this it is under 'Scheduled Tasks' in vBulletin. It has nothing to do with cPanel.

This option can specify if you want all tables or just tables your want:

Paul, I am quite new to cron jobs. What does the '*' mean in the options like 'Day of the Week' etc? Because basically what I want to do is back it up every day at midnight.

Cheers
LTC

Thanks for that.

Now for me to answer your question:

This is the day of the week the task should run on. Set this to * to have it not apply, or for it to run every day (if Day of the Month is set to * below). Otherwise select a specific day. Note that this will override the day of the month option, unless this is set to *.

Regards Jason :)

One more question, I click "Run Now" and it returned the following error:

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

Anything need changing?

Regards Jason :)

This means that the path to your backups folder is not correct. Download this file and upload it to your backups directory. This will give you the entire path, for you to insert into the config file. Remember to have a trailing slash /.

Forum Path

Also make sure your backups folder is set to 777.

I don't understand you.

I have it right in the config.php file. I have my backups folder at: /public_html/backups/ ... and that's what I've set in the config.php file.

Regards Jason :)

Well that error means your forum path is incorrect. Is the folder CHMODDED to 777 ?

Yes, it is.

Regards Jason :)

Can you please just try my other method? I had the same problem as you and once I put the correct path in it worked.

Cheers
LTC

What do you want me to do with that file? Upload it where? And how to run it?

Regards Jason :)

Upload it to your backups folder, and point your browser to it.

So once uploaded, go to your browser and run it like this:

http://yourdomain/backups/filepath.php

It will then display the entire root path, and then just copy that and put it in the path option in the config file. It must have a trailing slash. So for example:

/home/users/public_html/backups/

I ran: /backups/forumpath.php but get Internal Server Error

Regards Jason :)

You ran it from your browser, yes? So you went http://yourdomain/backups/filepath.php?

Yes, I did.

It's not filepath, it's forumpath.php ... that's the file name.

Regards Jason :)

Oh yes, sorry.

Well, I don't know what to suggest. It worked for me, so I have no more answers.

You will have to wait until Paul (or someone else) logs on to help you.

Will do.

Regards Jason :)