vB Database Backup (Lite)

[Paul M]

As of 24 Nov 2017 this modification has been withdrawn.

Note: I did not write the original version, but rather have modified & adapted it.

When vb 3.5 first came out I was using this backup system (https://vborg.vbsupport.ru/showthread.php?t=78486) on my vb 3.0 - and having nothing better to use - I converted it to work on vb 3.5 (here (https://vborg.vbsupport.ru/showthread.php?t=112304)) and since then I have cut it down and adapted it, first for vb 3.6, 3.7 and now for vb3.8.

The original version was by Trigunflame (https://vborg.vbsupport.ru/member.php?u=19191) and the rights to the code were bought by Zoints (David Chapman) in January 2007. Later 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.

As of version 3.8.002, most of the options have moved to the ACP in vBulletin Options >> vBulletin Automatic Backup

Notes:
* I will not be adding anything new to this modification.
* This is a Lite version to allow people to use the basic backup functionality on 3.8.


History:

v3.8.001 : First version for vB 3.8.
v3.8.002 : Moved most of options to ACP.
v3.8.003 : Moved more options to ACP.
v3.8.004 : Gzip option backported from vb4 version.
v3.8.005 : Split option backported from vb4 version, close option removed.
v3.8.006 : Fix php 5.3 deprecated warning.

[Brandon Sheley]

Thanks for updating this Paul :)
When I go to 3.8, I'll need to update my backup mod

[SuperDave71]

Thank you! Works with 3.8 just fine. Thanks Paul!

-Dave

[Arcade Fire]

Thanks Paul!!! ;)

[Fungsten]

Where does it dump it to? TIA.

[Paul M]

Wherever to set it to in the config file.

[Fungsten]

Wherever to set it to in the config file.

Ooops. Thank you.

[rizelim]

Thanks Paul

[puertoblack2003]

Good job :up: just a heads up in the schedule task section section it's still showing "Automatic Database Backup for vBulletin 3.7" :D

[Paul M]

Thanks, Cron title updated.

[Phaedrus]

Can you think of a reason why it would just stop in the middle of the "post" table every time I run it from the cron, even a cron directly from my site's server, but if I use mysqlbackup and do it using the php directly, it will take a full backup?

[shofolofo]

Thanks paul, I want to ask some .. euhm .. noobish questions


in the configuration file -- I've made file in path site/vb/backups/
backups file is writable and this is the configuration part

// File Saving Information
$backup['DATE'] = 'Y-M-d'; // Backup file date format (See http://uk.php.net/date)
$backup['PREFIX'] = 'Forum-'; // Backup file prefix, applied to all files
$backup['DUMP_PATH'] = 'backups/'; // Path to backups folder, must have a trailing slash, folder must be writable.


I couldn't modify the date because I didn't understand how to write the scheme from php.net , can you give an example please ?


went to cron jobs and pressed " run now "
An error occured during the Backup : Could not open Destination SQL file for writing.

:(


Thanks for you great mods :)

[Paul M]

Can you think of a reason why it would just stop in the middle of the "post" table every time I run it from the cron, even a cron directly from my site's server, but if I use mysqlbackup and do it using the php directly, it will take a full backup?
Maybe your php installation has a timeout ?

[Paul M]

This is not likely to work ;

$backup['DUMP_PATH'] = 'backups/';

Where exactly is your backups folder (in relation to other folders).

[KEKforce]

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




I did $backup['DUMP_PATH'] = './backups/';

Works for me.

[Adem GEN?]

Full path
$backup['DUMP_PATH'] = '/usr/local/******/backups/';

Works for me

[Freddy.k]

Thank you.

[Trek]

Works great, thanks much!

[shofolofo]

This is not likely to work ;

$backup['DUMP_PATH'] = 'backups/';

Where exactly is your backups folder (in relation to other folders).

I did $backup['DUMP_PATH'] = './backups/';

Works for me.



Thanks Paul, kekforce ... I did it like ./backups/ and it worked :)



---------------

Is there is a command to add to tar/gz the file then delete it the SQL one ?
the backup is taking about 500 mega :o ...


tyvm

[Phaedrus]

Maybe your php installation has a timeout ?
Well, it was working for a very long time, then I changed the albums from the database to my files and suddenly when it hits "post" it stops. No other changes were made. Of course, since then I have upgraded to 3.8, but previous to that the 3.7 version ran fine.

[starli]

Hey Paul

I have a question about Item 4
I do not understand where I think the setting for this.
In the Admin CP I find nothing about this.
THE XML has already been uploaded and the Config adjusted.

Sorry for the bad English,
Starli (ger)

[buileminh]

I have not tried it yet... Anybody can tell me if it can email backed up DB to specified email address?

[Trek]

No, it outputs to a folder with incremental folders/table names. Not saying it's not possible, but this doesn't do that. Good idea though.

I have not tried it yet... Anybody can tell me if it can email backed up DB to specified email address?

[Nadeemjp]

nice. i always had problems cause backing up data base is too complicated for me.
i shall use this.

[Paul M]

I have a question about Item 4
I do not understand where I think the setting for this.

Just leave it as is, the default is fine for 99% of people.

[Yonatan]

I get this error when i try to run this task:


Could not open Destination SQL file for writing.

[Nadeemjp]

i didnt know how to use it.
i simply uploaded files and imported the product (without editing the php file since i dont know how to do it).

now what happened was, my forum started giving a blank screen with the following error:

Fatal error: Call to undefined function fetch_require_hvcheck() in /home/familyb2/public_html/forums/global.php on line 486


and nothing is happening. i tried deleting the files, i tried uninstalling the files, i tried re-uploading the global.php file but nothing seems to work. vbulletin support peopel say if i have modifications installed then they cant help which is obsurd since i only download modifications from this official site.

now can someone tell me what to do?
my url is:
www.familybunker.com

i started to download this mod because i dont know how to backup my data and i thought maybe this mod can help me. guys please help me out i am in big trouble.

[Nadeemjp]

one more thing.
up until a few hours, i had 3.8 installed and working fine.

but accidently in the afternoon i pressed the "revert prefs" button in the admincp. i didnt know what happened then, but now that i look at my version of vbulletin, it shows 3.7.3 PL1. i dont know what the heck happened.

am in trouble? cause i dont have any backup of my data:(

[joe1989]

Excellent mod! Love it!

But, I have a question... Why is it not recommended to turn the forums off during the backup? Wouldn't that be a good idea to close the forums temporarily during the backup?

Any info?

Also, how large does the forum need to be before this mod starts suffering from PHP timeouts? I have the newest PHP version (5.1.6).

Thanks again!

[Paul M]

one more thing.
up until a few hours, i had 3.8 installed and working fine.

but accidently in the afternoon i pressed the "revert prefs" button in the admincp. i didnt know what happened then, but now that i look at my version of vbulletin, it shows 3.7.3 PL1. i dont know what the heck happened.

am in trouble? cause i dont have any backup of my data:(
Your problems are nothing to do with this mod, you should open a support ticket at vb.com

[Phaedrus]

Well, it was working for a very long time, then I changed the albums from the database to my files and suddenly when it hits "post" it stops. No other changes were made. Of course, since then I have upgraded to 3.8, but previous to that the 3.7 version ran fine.

Suddenly it started working again.

Excellent. I didn't think it was the Mod's fault (especially considering even Crons run from my server itself still wouldn't work) but I hoped I could figure out what was wrong. I never did, but Cron Backups are working again, just as scheduled, without data loss.

[FazerPaint]

Great Mod Paul, I love it......

Downloaded, followed the instructions and it worked first time..............BRILLIANT:up:

[Nadeemjp]

Your problems are nothing to do with this mod, you should open a support ticket at vb.com

yeah now i know that and my problem is fixed.
the problem that i have with this mod is, in the instructions it is written:

2. Set your choice of options in the mysqlbackupconfig.php file.


I dont have any clue how to do that. so i am asking for some help that either tell users like me who dont possess much of technical knowledge on how to do it, or give a link to some tutorials. but tutorials can take long to comprehend, the best thing would be to please mention the optimum example of the mysqlbackupconfig file.

also, i have no idea how to create and place a folder where the backup data gets stored. so i am asking for help in this regards.

thanx

[Trek]

You should have uploaded the files via FTP or something for vBulletin, use the same program to create the folder you want to put the files in.

[joe1989]

Can someone address my questions (post #29)??

[Paul M]

Excellent mod! Love it!

But, I have a question... Why is it not recommended to turn the forums off during the backup? Wouldn't that be a good idea to close the forums temporarily during the backup?

Any info?

Also, how large does the forum need to be before this mod starts suffering from PHP timeouts? I have the newest PHP version (5.1.6).

Thanks again!

1. Because the code that turns it back on fails sometimes, leaving your forum closed.

2. If php is set-up correctly then timeouts should not happen.

[joe1989]

2. If php is set-up correctly then timeouts should not happen.

Aren't timeouts possible when using vbulletin's built-in backup feature? They warn that timeouts are possible with large forums... wouldn't this also be the case here?? Sorry, I don't have much PHP knowledge, so I don't know details and specifics...

[Nadeemjp]

You should have uploaded the files via FTP or something for vBulletin, use the same program to create the folder you want to put the files in.

yes sir i am aware of that, what i dont know is, how to setup my php configuration files so that this mod can automatically backup my database and if it doesnt do it automatically, then at least inthe instructions there should be some procedure mentioned to do so.

plus i dont know how to import the saved backup database in case of an emergency and it would have been nice and kind if the developer or even anyone else had helped cause not everyone that comes here is a software expert.

if not much support is offered here for people like me, well then i guess i will have to uninstall it.

[shofolofo]

Paul, is it possible for me to add tar/gz to the file to save hard disk space while we are away from an internet connection ?

[Paul M]

Not using this mod it isnt.

[Nadeemjp]

*uninstalled*

[starli]

-fixed- ^^

[Yonatan]

I edit "mysqlbackupconfig.php" - to:
<?php
/*
<!-- $Header: d:\cvs/3.8/Auto-backup/includes/mysqlbackupconfig.php,v 1.1 2008/10/05 15:33:17 pem Exp $ -->
Auto-Backup (Lite) for vBulletin 3.8 - Paul M - v 3.8.001
This lite version is adapted from the original 3.0.x version by Trigunflame.
*/
// ---------- Main Options, alter these to suit your set-up ----------//
// Combine all tables into one backup file
$backup['COMBINE'] = 1; // 0 = No, 1 = Yes
// Close Forum during Backup (not recommended)
$backup['SHUTDOWN'] = 0; // 0 = No, 1 = Yes
$backup['MESSAGE'] = "The Forum is closed because a database backup is in progress.";
// File Saving Information
$backup['DATE'] = 'Y-M-d'; // Backup file date format (See http://uk.php.net/date)
$backup['PREFIX'] = 'Forum-'; // Backup file prefix, applied to all files
$backup['DUMP_PATH'] = './backups/'; // Path to backups folder, must have a trailing slash, folder must be writable.

// ---------- Other Options, do not alter unless you understand what you are doing ----------//
// Backup Options
$backup['LOCK'] = 0; // Lock Tables during dump
$backup['REPAIR'] = 1; // Repair & Optimize Tables before dump
// Backup Type To Use
$backup['TYPE'] = 2; // 1 = Only Specified Tables, 2 = All except Specified Tables
$backup['TABLES'] = array(); // Table List - e.g. array('table1', 'table2')
// Backup Optimizations
$backup['INNODB'] = 0; // Set to 1 if you have Innodb Tables
// Execution Function
$backup['COMMAND'] = 'exec'; // exec, system or passthru
?>


and i change "CHMOD" to "backups" folder to "0777" - and i still get this error:
An error occured during the Backup : Could not open Destination SQL file for writing.

help please,
yonatan :)

[nectons]

Hi Paul.

It works perfect 2 weeks now without any problem. I have an accident yesterday and i decide to make a restore. Everething worked perfect. ONLY one problem. All my styles messed up.. lost backgrounds, buttons.. everething. I didnt know why.

But.. after a rebuilt style in meintanance all my styles worked again perfect. Is this a problem? Should i have to worry for anything?... I lost many threads/posts and about 50 new registered users.. I dont want to loose more.

Please help me.

And another one question. Is anything i can do to take backup every 3 or 6 hours? Or.. is it possible to takes backups every one hour BUT to delete backups older than 2 days for example? I found if i choose asterisk at month/week/day and choose asterisk at a hour it takes backups every one hour.

But its gonna full the space at my server and maybe it is heavy too.. Can you please tel me if anyway to take backups every 3 or 6 hours or like i said even more frequently at 1 hour but i don have to delete anything my self ?... I mean to somehow the cron to delete backups older than 2 days?

[yingzhou]

I edit "mysqlbackupconfig.php" - to:
<?php
/*
<!-- $Header: d:\cvs/3.8/Auto-backup/includes/mysqlbackupconfig.php,v 1.1 2008/10/05 15:33:17 pem Exp $ -->
Auto-Backup (Lite) for vBulletin 3.8 - Paul M - v 3.8.001
This lite version is adapted from the original 3.0.x version by Trigunflame.
*/
// ---------- Main Options, alter these to suit your set-up ----------//
// Combine all tables into one backup file
$backup['COMBINE'] = 1; // 0 = No, 1 = Yes
// Close Forum during Backup (not recommended)
$backup['SHUTDOWN'] = 0; // 0 = No, 1 = Yes
$backup['MESSAGE'] = "The Forum is closed because a database backup is in progress.";
// File Saving Information
$backup['DATE'] = 'Y-M-d'; // Backup file date format (See http://uk.php.net/date)
$backup['PREFIX'] = 'Forum-'; // Backup file prefix, applied to all files
$backup['DUMP_PATH'] = './backups/'; // Path to backups folder, must have a trailing slash, folder must be writable.

// ---------- Other Options, do not alter unless you understand what you are doing ----------//
// Backup Options
$backup['LOCK'] = 0; // Lock Tables during dump
$backup['REPAIR'] = 1; // Repair & Optimize Tables before dump
// Backup Type To Use
$backup['TYPE'] = 2; // 1 = Only Specified Tables, 2 = All except Specified Tables
$backup['TABLES'] = array(); // Table List - e.g. array('table1', 'table2')
// Backup Optimizations
$backup['INNODB'] = 0; // Set to 1 if you have Innodb Tables
// Execution Function
$backup['COMMAND'] = 'exec'; // exec, system or passthru
?>


and i change "CHMOD" to "backup" folder to "0777" - and i still get this error:


help please,
yonatan :)

you must creat a folder name: $backup['DUMP_PATH'] = './backups/

not backup. :D

[Yonatan]

you must creat a folder name: $backup['DUMP_PATH'] = './backups/

not backup. :D
Oops :S
by mistake i wirte "backup" instead of "backups".
but, in backups folder. it's make folders(like: 2009-Jan-28 and etc), but not sql files.

[Lautaro]

I have a few questions about this modification:

1.- How do I secure the 'backups' folder?? ( CHMOD settings )
- is this a good configuration of it?
https://vborg.vbsupport.ru/attachment.php?attachmentid=93652&stc=1&d=1233222781

2.- Where do i change the time when I want the backup to be made?

3.- Is there any way to make the backups path outside the public_html folder?
when saying outsite public_html i mean here:
https://vborg.vbsupport.ru/attachment.php?attachmentid=93651&stc=1&d=1233222781
making a folder there called backups..
if yes, how will the backup path be?
my forum is located here: '/public_html/forum'

Thats all.

[FCDobbs]

Paul, thank you for this mod.
It is working fine for me.

One issue I have is with the number of backups being taken/stored (1 per day).
After a few weeks, my site hosting company is going to start charging me
for the extra disk space I am using.

I know you have no plans to modify this Mod and I don't expect you to.

But could you advise as to how I might be able to set up a CRON job to delete folders which are more than 7 days old ?

Thanks

[JonUrban]

Dumb question 101:

I installed the product, followed the directions. However, I am not sure how to

4. Alter the timing of the cron job to suit.

I'm not a real web expert, just a plodder. Can someone point me in the right direction?

THANKS

[Yonatan]

Dumb question 101:

I installed the product, followed the directions. However, I am not sure how to

4. Alter the timing of the cron job to suit.

I'm not a real web expert, just a plodder. Can someone point me in the right direction?

THANKS
Go to ACP -> Scheduled Tasks -> Scheduled Task Manager - Now edit "Automatic Database Backup for vBulletin 3.8" and save!

Good luck ;)

[Vinyljunky]

But could you advise as to how I might be able to set up a CRON job to delete folders which are more than 7 days old ?

Thanks

I'd like to be able to do that too :)

[Paul M]

You could just change the time format in the config to use the day of the week, this is what I do so I only ever have 7 folders (Monday to Sunday).

$backup['DATE'] = 'l'; // Lowercase 'L'

[FCDobbs]

Paul, never mind my earlier request.

I have successfully built a VB script (Windows Scripting Host) which:

1. Invokes Windows FTP command to connect to my site host server and list out all the folder names for all the backups.
2. Examines these folder names (each is actually the date the folder was created),
does a numerical check against todays date, and stores the information for all folders which are more than 7 days old, and stores the information for all folders which are 7 days old or less.
3. Loops through all the folder names which are more than 7 days old, and creates/runs a Windows FTP job to delete each folder.
4. Loops through all the folder names which are 7 or less days old (I want to copy them to my computer for a second backup), and copies the file in each one to my computer.
Actually, it first checks to see if the folder already exists on my computer.
If so, it ignores copying that file; if not, it creates that folder, then copies the file over.
This is also done via a Windows FTP job.

Now I merely schedule this task to run every day on my computer, and presto... it all runs unattended for me, and does exactly what I want.

Perfect.

By the way.... if anyone would like a copy of my script, just PM me and I'll be happy to send it to you.
Of course, it will be "bare bones"... you will have to insert/modify the code to accommodate your FTP ID and password, and your server backups folder structure, and your PC folder structure. But is is significantly commented so you should be able to do this quite easily.

Cheers,

[Phaedrus]

Oops :S
by mistake i wirte "backup" instead of "backups".
but, in backups folder. it's make folders(like: 2009-Jan-28 and etc), but not sql files.

Check inside the folders.

[Vaupell]

well installed, did force cron to run a backup worked like a charm
downloaded backup aswell.

this might be a FAQ- if so, could u add it to your post for mySQL newbs like me.
How do i restore the backup if i needed to, i dont right now, but would be nice to
know when i get to the point where i need to restore ;)

I got phpmyadmin acces to mySQL server at the webhost. ;)

no rush..

PS: Installed ;)

[FCDobbs]

Paul, thanks for the hint.

At least now, I will only have 7 days stored.

And I won't have to use the script I built.

[JonUrban]

Thanks Paul M! I just installed and ran a 'run now" and it worked like a champ! Very nice! Marked as installed and nominated.

[Yonatan]

Check inside the folders.
I was check.
the folders is empty :(

[BlackJacket]

where do i create the "backups" folder? Which directory?

[Yonatan]

where do i create the "backups" folder? Which directory?
In public_html


- - - - - - - - -

Paul.
Pleash help me, in my problem.
Thanks,
yonatan

[bam-met]

Thank you very much - works GREAT...

[Yonatan]

I try to backup(manually) in Safe Mod, and i get this error:
Could not open Destination SQL file for writing

But, when i turn-off the Safe Mod, everything work perfect.


What i should to do, that i will can use on the mod in Safe Mod?


Thanks,
Yonatan

[Paul M]

Nothing, dont use safe mode.

[grecostimpy]

Hi, I have a 2GB database (big board). Just want to ensure that this is ok to use with a large db. I'd love to use an automated system like this. Reading through the threads in this, the forum does not get turned off during the backup?

Thank you for your assistance. :)

[Paul M]

There is no limit built into this, so as long as your php does not timeout there is no reason you can t use it with a 2GB database.

[hydn]

windows server.

Path to backup folder is set to:
'D:\inetpub\wwwroot\forums\backups\'

I get:
"An error occurred during the Backup : Could not open Destination SQL file for writing."

Even though permissions are set in "backups" folder created in forums dir.

My vb config path is set to:
'D:\inetpub\wwwroot\forums\';

Whats missing?

EDIT: Tried creating folder "D:\backups\"
And changed config to:
'D:\backups\'

Sam error.

[Paul M]

Sorry, I cant solve indivdual server configuration problems.

[y2krazy]

Installed and worked the first time! Awesome!!

~ Sean

[hydn]

uninstalled

[y2krazy]

uninstalled
Why? Did you run into any issues?

~ Sean

[grecostimpy]

There is no limit built into this, so as long as your php does not timeout there is no reason you can t use it with a 2GB database.

Thank you for that answer. Is it safe on a database this large to keep the forums open while this runs? Mind you it is a very busy website 24/7. Thanks again for your assistance.

[jl255]

tks for this mod!

been running this for a few weeks now, and i realize that the backed up db is 2gb while the db size indicated in cpanel is close to 4gb. Does that seem right?

[Paul M]

Thank you for that answer. Is it safe on a database this large to keep the forums open while this runs? Mind you it is a very busy website 24/7. Thanks again for your assistance.
It wouldbe better to close it if you can, but I would not advise using the option in this mod as it can sometimes fail to open it again.

tks for this mod!

been running this for a few weeks now, and i realize that the backed up db is 2gb while the db size indicated in cpanel is close to 4gb. Does that seem right?

Sorry, I cannot comment on database sizes.

[wipedout]

i have serious conserns and serious problems i require serious help!

i do realise that your exact words were: "* I will not be adding anything new to this modification. " but i beg you reconsider to add gziping of the sql files after the backup is done it would shorten down the overall backup sizes with about 75% which if someone like me who wants 4 backups a day would help alot making my backups go from 120mb per day and rather down to 45mb a day.

~Wipedout
TFD Administrator

[Paul M]

My backups are way bigger than that, why is it a serious problem ?

[hydn]

i have serious concerns and serious problems i require serious help!

Good luck with getting help. Maybe now you will. Lets hope its not an "individual server configuration" you have but that some how you have a clone setup because all servers must be the same it seems.

[chingon]

Thank you very much Paul M, your work is greatly appreciated.

[hearts]

Update - I had to add 'httpdocs'

/httpdocs/backups/

it works now.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Edited: I found answers to my post. Now I get an error:
"An error ocured during the Backup : Could not open Destination SQL file for writing. "
I read another post above that said they got this message and changed to not run in safe mode.
How do I turn off Safe Mode?
/backups/ is 0777

Thanks.
Beth

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Installation instructions below. I have done #1,2,3.

How do I do #4? Where do I go to do that?
How do I start the backup? (I did create a /backups/ directory)

Thanks,

Beth
~~~~~~~~~~~~~~~~~~

Installation.

1. Copy all files in the 'includes' folder to the server.

2. Set your choice of options in the mysqlbackupconfig.php file.

3. Upload the product XML via the Product Manager.

4. Alter the timing of the cron job to suit.

[wipedout]

My backups are way bigger than that, why is it a serious problem ?

its not a serious problem, but reducing sizes of backup would be nice.

[WildFire.ca]

Thank you sir, nice little mod.
I am having a little problem running the mod. Its giving me this error when I try to run the process. An error occurred during the Backup : Could not open Destination SQL file for writing.

[Paul M]

As posted many times, thats a (write) permissions error.

[Speedy1505]

can you added a compression as TGZ, TAR or ZIP ????

ist fine :)

[bleros]

mann and tried several ways but still is not doing "help

Warning: is_file() [function.is-file]: open_basedir restriction in effect. File(../backup/2009-Mar-06) is not within the allowed path(s): ([path]/:/home/www/web1245/phptmp/:/home/www/web1245/files/:/home/www/web1245/atd/) in [path]/includes/mysqlbackup.php on line 211

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backup/2009-Mar-06) is not within the allowed path(s): ([path]/:/home/www/web1245/phptmp/:/home/www/web1245/files/:/home/www/web1245/atd/) in [path]/includes/mysqlbackup.php on line 246

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backup/2009-Mar-06) is not within the allowed path(s): ([path]/:/home/www/web1245/phptmp/:/home/www/web1245/files/:/home/www/web1245/atd/) in [path]/includes/mysqlbackup.php on line 257

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backup/2009-Mar-06/Forum-2009-Mar-06-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1245/phptmp/:/home/www/web1245/files/:/home/www/web1245/atd/) in [path]/includes/mysqlbackup.php on line 153

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backup/2009-Mar-06/Forum-2009-Mar-06-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1245/phptmp/:/home/www/web1245/files/:/home/www/web1245/atd/) in [path]/includes/mysqlbackup.php on line 163

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

[cionfs]

Installed. :) Nominated MOTM. ;)

[Paul M]

mann and tried several ways but still is not doing "help

The errors tell you whats wrong - you have an open_basedir restriction in place, preventing php writing to your destination.

[bleros]

what need to do ??S:

[Paul M]

Sorry, I cant help with server support, you must contact your host.

[Andyrew]

This mod nearly gave me a heart attack today, i was browsing my forums when all of a sudden a message in red comes at the top of the forums (Forums are turned off) :eek: or whatever it says. I thought i was been hacked, so went into admincp and looked at the setting for board on/off it was set to on. Took me about ten minutes to realise what had happened. :o:D
Good mod, but it didn't half give me a scare.:D

[Aragorn17]

how long does it typically take for the import to complete? my attempt has been stuck on the "Importing Product, Please Wait..." page for hours without changing.

[Paul M]

It only takes a few seconds - looks like you import hung, cancel it and try again.

[Aragorn17]

hmm...I've tried it a few times with the same result.

[dimaser]

I'am wondered: when I choose switch off the forum being DB backup, the forum is OFF for over a hour, how to solve that problem, due of DB backup progress takes no more than 5 minutes?

[Paul M]

As I have repeated many times in the various threads, if you have problems with the option to turn the forum off, then dont use that option.

[mrtroybaker]

*uninstalled*
I have read this entire thread and people asked over and over about
An error occured during the Backup : Could not open Destination SQL file for writing.
The only answer given was "its a database issue". It might be hard to understand but some of us dont have the knowledge to know where to look. Maybe a hint as to what we need to look at? What might be the problem or who to contact on our side.

[Paul M]

You didnt read very hard then, its a server (permissions) error, not a "database issue".

I cannot fix your permissions, if you dont know how, then you either contact your host, or someone who can.

[mrtroybaker]

You didnt read very hard then, its a server (permissions) error, not a "database issue".

I cannot fix your permissions, if you dont know how, then you either contact your host, or someone who can.

Fair enough. So what would I say when I call them? Not trying to be a smart ass I just know how it is when you call them.
My best guess is something about the permissions on there end? I 777ed everything, maybey it didnt take. I will try this. Thank you

[Paul M]

The most common cause (if the folders are set to 777) is open_basdir restrictions, esp on servers running Plesk.

[sakiri]

Dear Paul,

May i just clarify with you in your previous post that you stated that you will have only 7 folders & backups.

For example, if today is monday, the script will just overwrite the current existing monday file (belonging to the previous week)?

https://vborg.vbsupport.ru/showpost.php?p=1729243&postcount=52

[sakiri]

Fair enough. So what would I say when I call them? Not trying to be a smart ass I just know how it is when you call them.
My best guess is something about the permissions on there end? I 777ed everything, maybey it didnt take. I will try this. Thank you

I am also a newbie.
How about doing a screenshot on this post https://vborg.vbsupport.ru/showpost.php?p=1727924&postcount=47 and tell your webhost that you also do want to change your folder settings to something similar like that?

[Paul M]

For example, if today is monday, the script will just overwrite the current existing monday file (belonging to the previous week)?
That is correct.

[Fynnon]

it works for me very well...i had little issues with it but nothing that could not be solved with patience
10x

[sakiri]

That is correct.

Thanks. :)

[crazlunatic]

got a few questions:
where can I edit the settings?
where does the backup go to?

[Paul M]

1. In the settings file

2. Wherever to set it, see Q1.

[blackwolf062]

thanks installed and works

[alfaowner]

I had the sql issue, but my path was wrong in the config file, once I put the path in, it worked like a dream on 3.8.2, thanks.

[CableSux]

There is no limit built into this, so as long as your php does not timeout there is no reason you can t use it with a 2GB database.

I'm having the timeout issue. Backup stops around table "template" or "thread". Any suggestions? I'm on godaddy. I had the write error issue, too. I simply changed
$backup['DUMP_PATH'] = '../../backups/'; to
$backup['DUMP_PATH'] = './backups/';
and it worked just fine. Also change the date to small L and that works just fine, too. Thanks!

P.S. I'd love for this to work... I'm getting real tired of running mysqladmin backups! :D

[Paul M]

Decades ? :)

I'll be happy if I'm still alive in decades to come :D

[tedology]

Thanks for doing this, Paul. :)

The instructions were simple enough even for a ROOKIE like me. :)

Question:

I followed instructions and uploaded the XML file.

Now what?

Is there something I need to run?

I see "Alter the cron job to suit"

not sure how I do that.

Is there some sort of .exe file I run to make sure I start backing up my DB?

And I'm guessing this is only for vbulletin, yes? Won't work with photopost pro...?

Thanks again!

[tedology]

Paul, when I run it... I get the following error:

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

I've checked permissions and have tried various paths.

[Walter Ronny]

i works! ok so now, im looking for to get another hosting and move all info of my forum to the new hosting ill looking for to get.. what exactly i have to do ? do ill lose any info ?

[Kolbi]

Do I really have to set the folders to 777? Isn´t it unsecure?

[Paul M]

Apache needs write access to create the files, how you do that is upto you - 777 is the easiest way.

[madotds]

Cheers paul for this mod :)

Just for information:

For those of you who would like your sql dumps to be a little more secure, It is posible to have them save outside of your "public folder"
all you need to do is find out the full path to your sever for example mine looks something like this.
$backup['DUMP_PATH'] = '/home/fhlinux123/x/yoururl.com/user/mysqlbackups/'; //

Then just make sure the folder you defined in red is chmod 777. (you can do this through your FTP client and right clicking selecting properties if you are on a lynux sever. I dont know about any other severs.

I am far from an expert but hope this helps someone.

Regards

Madotds

[mokujin]

When I run this cron, after a few seconds there show these lines:
Automatic Database Backup for vBulletin 3.8

Processing access : Total Rows = 0
Processing adminhelp : Total Rows = 1748
Processing administrator : Total Rows = 4
Processing adminlog : Total Rows = 5937
Processing adminmessage : Total Rows = 3
Processing adminutil : Total Rows = 3
Processing album : Total Rows = 130
Processing albumpicture : Total Rows = 933
Processing albumupdate : Total Rows = 0
Processing announcement : Total Rows = 12
Processing announcementread : Total Rows = 1061
Processing attachment : Total Rows = 753
Processing attachmentpermission : Total Rows = 0
Processing attachmenttype : Total Rows = 10
Processing attachmentviews : Total Rows = 0
Processing automediaembed : Total Rows = 0
Processing avatar : Total Rows = 0
Processing bbcode : Total Rows = 5
Processing bookmarksite : Total Rows = 4
Processing calendar : Total Rows = 1
Processing calendarcustomfield : Total Rows = 0
Processing calendarmoderator : Total Rows = 0
Processing calendarpermission : Total Rows = 0
Processing cpsession : Total Rows = 1
Processing credits_bank : Total Rows = 2
Processing credits_lottery : Total Rows = 0
Processing credits_transactions : Total Rows = 52
Processing cron : Total Rows = 19
Processing cronlog : Total Rows = 588
Processing customavatar : Total Rows = 825
Processing customprofilepic : Total Rows = 362
Processing datastore : Total Rows = 38
Processing deletionlog : Total Rows = 1362
Processing discussion : Total Rows = 5
Processing discussionread : Total Rows = 0
Processing editlog : Total Rows = 11242
Processing event : Total Rows = 1
Processing externalcache : Total Rows = 3
Processing faq : Total Rows = 42
Processing forum : Total Rows = 206
Processing forumpermission : Total Rows = 40
Processing forumprefixset : Total Rows = 17
Processing forumread : Total Rows = 0
Processing gb_cache : Total Rows = 1099
Processing gb_media : Total Rows = 1099
Processing groupmessage : Total Rows = 20
Processing groupmessage_hash : Total Rows = 20
Processing groupread : Total Rows = 0
Processing holiday : Total Rows = 0
Processing humanverify : Total Rows = 4
Processing hvanswer : Total Rows = 2
Processing hvquestion : Total Rows = 1
Processing icon : Total Rows = 16
Processing imagecategory : Total Rows = 4
Processing imagecategorypermission : Total Rows = 0
Processing infraction : Total Rows = 825
Processing infractionban : Total Rows = 2
Processing infractiongroup : Total Rows = 0
Processing infractionlevel : Total Rows = 8
Processing language : Total Rows = 2
Processing mailqueue : Total Rows = 0
Processing moderation : Total Rows = 95
Processing moderator : Total Rows = 67
Processing moderatorlog : Total Rows = 9199
Processing nhac_song : Total Rows = 19
Processing notice : Total Rows = 1
Processing noticecriteria : Total Rows = 1
Processing noticedismissed : Total Rows = 0
Processing passwordhistory : Total Rows = 22395
Processing paymentapi : Total Rows = 7
Processing paymentinfo : Total Rows = 38
Processing paymenttransaction : Total Rows = 16
Processing phrase : Total Rows = 13155
Processing phrasetype : Total Rows = 68
Processing picture : Total Rows = 933
Processing picturecomment : Total Rows = 139
Processing picturecomment_hash : Total Rows = 193
Processing plugin : Total Rows = 144
Processing pm : Total Rows = 32552
Processing pmreceipt : Total Rows = 9
Processing pmtext : Total Rows = 26650
Processing pmthrottle : Total Rows = 0
Processing podcast : Total Rows = 0
Processing podcastitem : Total Rows = 0
Processing poll : Total Rows = 61
Processing pollvote : Total Rows = 3716
Processing post : Total Rows = 146373
Processing post_thanks : Total Rows = 306367
Processing postedithistory : Total Rows = 0
Processing posthash : Total Rows = 0
Processing postindex : Total Rows = 1204613

So I think I havent backuped all tables?
Need your help, Paul!

[Kolbi]

I hade the same problem. But then the cron job automatically makes an backup all vb_ prefixes are backed up.

[mokujin]

I hade the same problem. But then the cron job automatically makes an backup all vb_ prefixes are backed up.

I still cant backup.:confused:

[Kolbi]

How big is your database? (sorry for my english :) i?m german...)

[mokujin]

How big is your database? (sorry for my english :) i?m german...)

about 600mb, i'm czech :)

[tijmen_4real]

How can i change the time/frequency the backups are made?

[slowphantom]

thx for the mod
and
i got some problem after i installed the 3.8 and use this

it give database error

Database error in vBulletin 3.8.2:

Invalid SQL:
SHOW CREATE TABLE `template`;

MySQL Error : MySQL server has gone away
Error Number : 2006

it happen so much
befor i was useing the 3.7 on 3.7 forum
but i upgread to 3.8.2 and install that mod and i cant take any back up any more :(
any idea ?
thx

[sargatanas]

how this thing work?, i just installed it but i cant see any menu in my vb admincp [sorry for noob question]

[doctorsyrup]

how this thing work?, i just installed it but i cant see any menu in my vb admincp [sorry for noob question]

There is no menu for it. Go to the Scheduled Task Manager > Automatic Database Backup and you can run it manually. It is also set to run once daily by default.

[Jheyman]

Quick question I am getting this error when I hit run now on the backup job, I am sure I missed somehting but I cant seem to figure it out any help is appericated

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

[Outbackmark]

Installed and working fine, I created a folder called backup in the same folder as my forum, this differs from one site to the next, it needs to be in the same place as you see the folders for admincp, archive, attachements and so on (The place where you upload all your VB files).

The permissions are set to 755.

Make sure the folder is named the same in the mysqlconfig.php file so mine was called backup and my config looked like this
// File Saving Information
$backup['DATE'] = 'Y-M-d'; // Backup file date format (See http://uk.php.net/date)
$backup['PREFIX'] = 'Forum-'; // Backup file prefix, applied to all files
$backup['DUMP_PATH'] = './backup/'; // Path to backups folder, must have a trailing slash, folder must be writable.

Once set up, upload the config file into the includes folder and it will work, remember the ./ before the file name and the / after, that should be all you need on a linux server, so long as the folder is in the same place as your VB forum files.

All the above error means is the mod can not find or write into the folder because is is not named or placed correctly.

[PayJ]

What is the advantage of using this? Isn't this already in 3.8?

[Yonatan]

Quick question I am getting this error when I hit run now on the backup job, I am sure I missed somehting but I cant seem to figure it out any help is appericated

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

Safe Mode is turn on in your server and block this function, so you you need to turn off the Safe Mode if it's your own server, or contact to your hosting support.

What is the advantage of using this? Isn't this already in 3.8?

It's is a automatically backup based on Cron Jobs.
It's NOT a manual backup.

[Paul M]

What is the advantage of using this? Isn't this already in 3.8?
No, there is no automatic backup facility in vbulletin.

[Tboy_forum]

Guys, I also battled my arse off trying to get this thing to work!

It does - and eventually found it was my folder path for the backup - IT MUST BE CORRECT or it aint gonna work:D

Thanks

[bleros]

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

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


so must create folder in ftp with name backups or its established realy i need help i must have this becouse i dont have time to backup everyday with maus :)

[Paul M]

Yes, you must create the folder.

[bleros]

Yes, you must create the folder.


im get this error

Warning: is_file() [function.is-file]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 211

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 246

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 257

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/2009-Jun-07/Forum-2009-Jun-07-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 153

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/2009-Jun-07/Forum-2009-Jun-07-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 163

or this

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

are sometimes created a folder with the date. has nothing but the error :mad:

[Paul M]

open_basedir is a php security feature on your server, you need to talk to your host.

[bleros]

open_basedir is a php security feature on your server, you need to talk to your host.

ah yes SAFE MOD in server is ON .. i.e not work with SAFE MODE ON

[centurius]

Installed and works 90% perfectly. Only issue I have is that it does not re-enable my forum once it's done- and that was easily worked around using the config file.

[smartkidbk5]

i keep getting this error:

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

what is wrong?

[Outbackmark]

You have not created the folder for it to write to or set the permissions correctly.

[Yonatan]

i keep getting this error:

Automatic Database Backup for vBulletin 3.8
An error occured during the Backup : Could not open Destination SQL file for writing.what is wrong?


You have not created the folder for it to write to or set the permissions correctly.

This is unattached.

That error showing because Safe Mod turn on on his server.
turn off it and the problem will be solved ;)

[Outbackmark]

I have this installed on a number of sites, all on the same server, not in safe mode. On one site I forgot to set the folder up properly and that is exactly the same error I got. If something on the server was running in safe mode he would be having all sorts of other issues.
If you look back in this thread the error has been encountered a few times, each time is because the folder that the script writes to is not properly set up. The folder must be in the same folder that has your main vb files in it and be named the same as it is called in the config file and must have the permissions correct.
If the above is not done you will get exactly that error.

If PHP is in safe mode you will get this error -
Warning: is_file() [function.is-file]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 211

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 246

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backups/2009-Jun-07) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 257

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/2009-Jun-07/Forum-2009-Jun-07-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 153

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/2009-Jun-07/Forum-2009-Jun-07-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1/phptmp/:/home/www/web1/files/:/home/www/web1/atd/) in [path]/includes/mysqlbackup.php on line 163

[ITDarasgah]

after run show me this message tell me this is okay or not...no other message show.
Automatic Database Backup for vBulletin 3.8
Processing access : Total Rows = 10
Processing adminhelp : Total Rows = 1690
Processing administrator : Total Rows = 4
Processing adminlog : Total Rows = 4405
Processing adminmessage : Total Rows = 0
Processing adminutil : Total Rows = 1
Processing album : Total Rows = 1
Processing albumpicture : Total Rows = 2
Processing albumupdate : Total Rows = 1
Processing announcement : Total Rows = 1
Processing announcementread : Total Rows = 17
Processing attachment : Total Rows = 703

[Paul M]

You should only see that if you run it manually.

[Bob_R]

Will this mod backup everything? Database, sigs, avatars, posts, etc...

Thanks.

Looking for a good backup for vB and trying to make a proper choice for my needs.

[Paul M]

It backs up the vb database, so obviously posts etc.

It wont backup avatars or attachments etc unless you store them in the database.

[Sn1peR]

hi, thx 4 this mod

can i merg backup in single SQL file ?

coz it given to me as a table just like this!
:confused:

101969

[Paul M]

Just change the option in the config file.

[dfdems]

I have this installed and it works great so far. I do have a question regarding it though.

If I install this outside of the public html folder and it is set at 7-5-5 it should be fairly secure?

[Paul M]

As long as apache can write to it yes. Outside the public html folder is the recommended way.

[Bob_R]

When will this run? I checked the mysqlbackupconfig.php file and saw no indication. I guess I missed it? :confused:

Also, I must create a backup folder and the backups folder must be 777? Yes or No?

Thanks!! :)

[Paul M]

It runs whenever the cron (scheduled task) is set to run - 5am I think is the default.

[Bob_R]

My PHP settings are safe mode on (I believe by default)

Is this a problem?

Thanks.

[Bob_R]

My backup directory is empty this AM. So, obviously nothing was backed up.

What could be wrong?

Thanks.

[Paul M]

First of all, turn safe mode off.

Then run it manually to see what happens.

[Bob_R]

Isn't safe mode off a security issue?

Secondly, how can I put safe mode off for my forums but leave it on for my other sites. Which I believe need safe mode on if I'm not mistaken.

Thanks.

[Paul M]

Its not really a security risk, Safe Mode is just a nuisance that stops things working, it doesnt even exist in PHP 6.

I cannot help you with your own server set-up, contact your host.

[Bob_R]

I got this when I tried to run manually:

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

Is this the result of safe mode?

Thanks!

[Paul M]

Quite possibly - or your backup path could be wrong, or the folder permissions wrong, or some other reason. All the message means is apache does not have permission to write the file, you need to investigate why.

[Bob_R]

Just tried to run manually.

I have Safe Mode Off
The backup folder is named backups and is set to 777
And, I'm quite sure the path is correct

and I still get the error. :confused:

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

Here's my path:

$backup['DUMP_PATH'] = 'home/xxxxx/public_html/dumontnjforum.com/forums/backups/'; // Path to backups folder, must have a trailing slash, folder must be writable.

[Markos]

first of all thanks Paul i just upgraded to the new one worked first time :)

why not put your "backups" folder in home/xxxxx/ and change the path to that and see if that works and change the path to

$backup['DUMP_PATH'] = 'home/xxxxx/backups/';

Just tried to run manually.

I have Safe Mode Off
The backup folder is named backups and is set to 777
And, I'm quite sure the path is correct

and I still get the error. :confused:

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

Here's my path:

$backup['DUMP_PATH'] = 'home/xxxxx/public_html/dumontnjforum.com/forums/backups/'; // Path to backups folder, must have a trailing slash, folder must be writable.

[Bob_R]

why not put your "backups" folder in home/xxxxx/ and change the path to that and see if that works and change the path to

$backup['DUMP_PATH'] = 'home/xxxxx/backups/';

Same story didn't work. :(:mad:

[Bob_R]

I just noticed that I have 2 php.ini files.

Could this be causing the problem?

One is in public_html and the other is in forum root.

[Bob_R]

I got it working.

[Bob_R]

Why would my backup not run automatically this morning at the 6 AM default?

[Bob_R]

Here's a screenshot from my ACP. I run it manually again and it worked fine. But, I'm wondering why it just didn't run automatically.

[Bob_R]

Here's a screenshot from my ACP. I run it manually again and it worked fine. But, I'm wondering why it just didn't run automatically.

Anyone?

This is probably the easiest question in the whole thread.

Thanks! :)

[tandy]

When try to restore, the system said file to big and when finally it done by tables groups, it skip all french characters from database.

[Paul M]

This is probably the easiest question in the whole thread.

Actually its not, without access to your server/forum, its impossible to say.

[Bob_R]

Actually its not, without access to your server/forum, its impossible to say.

Check out a few posts up (should be previous page) where I posted the ACP screenshot. Running it manually it works fine but it doesn't run automatically. Nothing more, nothing less.

Thanks.

[Paul M]

All that screenshot tells me is that you have a correctly set-up cron job, nothing more.

Its a bit like posting a picture of an engine and then asking why it wont run.

[Bob_R]

So what do you suggest? Where do we go from here?

[Paul M]

Version 3.8.002 released - most of the options have been moved to the ACP.

Just re-upload the files and import the product.

[anaksimandros]

How do you recommend for the settings in the vBulletin options in 3.8.002?

[Paul M]

The defaults are fine for most people.

[Mike54]

Thanks Paul. It works a treat, just as always.

[Markos]

thanks Paul installed and works a treat

[anaksimandros]

The defaults are fine for most people.

In vBulletin Options All "no" sign. I hope they are correct. Because by default they came.

[atmaca]

Thanks for update Paul M. The new version is more beautiful and useful. :) Turkish translation can bedownloaded from the attachment.

P.S Language pack updated.
Dil paketi g?ncellenmiştir.

[joe1989]

I had this for a while, and it's always worked fine. However, I just updated, and now when I try to run it manually, I just get a screen that says "an error occurred during the backup."

EDIT: I found the problem. If anyone else is experiencing this, I solved it by going here: vBulletin Options --> vBulletin Auto Backup and scrolling down to the file path. For some reason it made the file path ../../backups/ instead of ././backups/

I simply changed it by removing the extra . and it worked fine!

[dandanch]

I'm still getting that same error"an error occurred during the backup"i'm not to clear on
how my Backups Path should be written?do i leave it like: ../../backups/ or do i need to
put a certain path and if so can you show example on how it should look.thanks

[Markos]

i put the path i had in the version before this so all you really need in there is ././backups/

[Paul M]

You put whatever path you were using before.

[dandanch]

paul i've never got it to work.. thats why i'm asking for example on how the path should look?

[Paul M]

The path is user/server specific, there is already an example in the settings, and many posts on the subject in this thread. I cannot tell you what you need for your specific setup.

[Adem GEN?]

Turkish Language File at the following link

T?rk?e Lisan Dosyası Aşağıdaki Linkte

http://www.vbulletin-ipuclari.com/vbulletin-turkce-dil-dosyalari/vbulletin-forum-pluginlerin-turkce-dil-dosyasi.html

[atmaca]

Turkish Language File at the following link

T?rk?e Lisan Dosyası Aşağıdaki Linkte

http://www.vbulletin-ipuclari.com/vbulletin-turkce-dil-dosyalari/vbulletin-forum-pluginlerin-turkce-dil-dosyasi.html

Look https://vborg.vbsupport.ru/showpost.php?p=1859597&postcount=178 ;)

[Paul M]

Thanks both of you. :)

[Stryker412]

Version 3.8.002 released - most of the options have been moved to the ACP.

Just re-upload the files and import the product.

I installed the latest version but I do not see the Auto Backup option in vBulletin Options --> vBulletin Auto Backup.

[Paul M]

Look again. It will be near the end, otherwise it didnt install correctly (which is unlikely).

[j1mmy]

I installed the latest version but I do not see the Auto Backup option in vBulletin Options --> vBulletin Auto Backup.
Same issue here. I displayed all options then type it in via the browser search. Doesn't detect anything. I also did a reinstall, still nothing there.

[coffee]

Thank you for the update.

You put whatever path you were using before.
In my case just: backup/ :)

[anaksimandros]

Edition upgrade to version 3.8.002 when a team was having problems. You have to remove and install the plugin again and "ADEM GENÇ" take advantage of our translation of the problem was resolved.

Thanks for the updates and improvements ...

[JonUrban]

Paul,

I just uninstalled the old version and installed the new version and all is well.

I would like to do what you suggested with regards to having the backups named by the day of the week instead of the date in order to keep only 7 backups on the website.

Is there an easy way to do this with the new interface without editing the php files?

If so, can you give the the info and where I should enter it?

THANKS

[Paul M]

Yes, enter l (lowercase L) in the date format.

[JonUrban]

Paul,

Sorry to be a moron here, but let me just clarify. I remove the 'Y-m-d' from the 'Date Format" info and replace it with a lower case L? That's it?

[Paul M]

Correct.

[dancue]

paul i've never got it to work.. thats why i'm asking for example on how the path should look?


Anyone having issues with this can upload this file and point to it on your browser.

[dancue]

Is there any way someone can provide me with a list of files the old version had?

Are they the same as what's included in this folder?

[SorentoUltimate]

Very Gooood addon

i want the backup file to be compressed ! can i do that automatical with some changes to the code ?

can someone help me?

Thanks
Giorgos

[Bob_R]

I'm rolling right along and everything's cool.

My only thing is that the backup seems to run not at the default time? The other day it ran at 10:54 AM and today it ran at 9:21 AM?

Thoughts?

[M3xital]

Great hack!!

Installed and working just fine ;)

[Paul M]

Is there any way someone can provide me with a list of files the old version had?

Are they the same as what's included in this folder?

Old version ?

The name/number of files has not changed (ever ...).

[Paul M]

My only thing is that the backup seems to run not at the default time? The other day it ran at 10:54 AM and today it ran at 9:21 AM?

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

[Bob_R]

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

OK, thanks.

[Kolbi]

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.

[Paul M]

The option Repair Tables also includes optimizing them?
Yes.

Are there now no mysql datas needed?
Sorry, I dont know what you mean by this.

I have the problem that the cronjob stops during the backup and that not all tables are backed up than.
Then you have a server issue that you need to look into.

[Kolbi]

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?

[Paul M]

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

[Kolbi]

Okay, and now there isn´t any soluting?

[Racecar]

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

[Almezmar]

very useful, thank you

[newguy]

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/

[Paul M]

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

[newguy]

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

[Paul M]

Just go into schedule manager and run the task.

[KHALIK]

Thank you installed.

[MrDeath]

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?

[Paul M]

In your scheduled tasks.

[MrDeath]

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?

[Paul M]

That depends on how your server is configured.

[princeedward]

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

;)

[bigdjam]

Thanks paul the auto backup is good

[Paul M]

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

http://en.wikipedia.org/wiki/InnoDB

[mackers8923]

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

[Ice-Maiden]

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! :)

[MrDeath]

That depends on how your server is configured.
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?

[Paul M]

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

[matt4]

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

Thanks

[MrDeath]

Yes, (in the settings ...... :))
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 :)

[Paul M]

vBulletin Options > vBulletin Automatic Backup > Combine Files

[princeedward]

http://en.wikipedia.org/wiki/InnoDBthanks paul...but to complicated for like me to understand it...LOL :p

[MrDeath]

vBulletin Options > vBulletin Automatic Backup > Combine Files
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!!

[Paul M]

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

[MrDeath]

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

[Paul M]

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

[Itchy Nips]

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

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* :)

[princeedward]

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:

[indiawilds]

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

[indiawilds]

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.

[Paul M]

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

[Drache]

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

[Paul M]

My database is bigger than that.

[Kamern]

I'm getting the same error as a previous poster, it isn't giving me a reason for an error, but it isn't backing up. Fresh install, by the way.

I fixed the problem by using "././backups/" instead of "../../backups/"

[MrDeath]

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!!

Hi Paul!,, since i cannot wait for the next version of the mod, i tried to patch the mod with this option... :).... i thought of uploading my modifications so that other ppl can benefit.. hope you dont mind...

i have added two options :

IF you choose to "COMBINE FILES" Then:-

1. All the backups now goes into a single backup dir.
2. If on Linux... then you also have a option to produce a compressed .gz file.

Installation :

1. install the original mod.
2. replace mysqlbackup.php with the attached one.
3. Uninstall the product.
4. Re-import the product with the attached xml file.

Important info..
1. the relative path do not work for me... i used full path (/home/sdadsf/backup/)
2. Do not use this if you do not want to combine your files..
3. I am not a php programmer .. so use it at your own risk.!!

[Paul M]

Actually, Ive already fixed it locally to put combined files in the root folder, just not released it atm. I might look at the compress feature as well, since a number of requests have been made for it.

[creative-friend]

So This will defo do my mysql backup??

[Paul M]

Thats a somewhat vague question, can you be more specific please.

[creative-friend]

can you please tell me....how am i gonna find out that my data base has been backuped??

i dont have idea how to use this Mod...please help me...

[EidolonAH]

I so often forget to back-up each day, this is a fantastic mod, thank you very much for this.

[mcyates]

How long does this take, i clicked run now from the shedule menu and its been running for 10 min, can't access the forum either because of a database error which I don't know what it is. My database is only 330meg in size.

I put it to lock the forum, repair and close the forum. Surely I shouldn't be getting a database error?

[Paul M]

To backup 330M shouldnt take more than a minute or two.

I cant comment on any database error unless you post the actual error.

[mcyates]

the server was playing up, but i can't seem to get the file location correct. Think i'm being stupid.