vB Database Backup

[Paul M]

This modification is no longer available or supported.

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 (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 and now for vb3.7.

The original version was by Trigunflame (https://vborg.vbsupport.ru/member.php?u=19191) 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.

[Adem GEN?]

Thanks
OK

[yahoooh]

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

[Bounce]

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.

[Paul M]

Its always done either.

[projectego]

* projectego clicks install :)

[Atilla_UYGUN]

thanks very good

[M-Tuning]

Nice, thanks.

i always forget to do them myself :D

[Mrsdos]

It does not act me.

[TouffTouff]

Hello,

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

Thank you

[Paul M]

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

[rainyleaves]

Thanks Paul. :)

[slowphantom]

great hack thx

[vuiveclub]

Does it work for vbb 368 too?

[Paul M]

There is a 3.6 version in the 3.6 forum.

[LGKeiz]

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.

[Paul M]

Its a setting in the config file.

[Bounce]

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

[Jase2]

Might as well just set up a cron job.

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

Regards Jason :)

[Paul M]

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

[asj]

Composite excellent work
Thank you very much

[seangworld]

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.

[EvErDrEaMs]

Excellent

[Lynne]

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

[Jase2]

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

[lordtopcat]

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:

// 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')

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

[Jase2]

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:

// 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')

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

[Jase2]

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

[lordtopcat]

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 (http://hsmcafe.com/forumpath.zip)

Also make sure your backups folder is set to 777.

[Jase2]

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

[lordtopcat]

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

[Jase2]

Yes, it is.

Regards Jason :)

[lordtopcat]

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

[Jase2]

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

Regards Jason :)

[lordtopcat]

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/

[Jase2]

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

Regards Jason :)

[lordtopcat]

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

[Jase2]

Yes, I did.

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

Regards Jason :)

[lordtopcat]

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.

[Jase2]

Will do.

Regards Jason :)

[Paul M]

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/

[bollie]

Automatic Database Backup for vB 3.7

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

[Jase2]

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

[inteller2k7]

Automatic Database Backup for vB 3.7

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

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

[Jase2]

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

[bollie]

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

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

Folder mod to 777

[Paul M]

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

[Jase2]

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

Regards Jason :)

[Paul M]

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

[Jase2]

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

[maxicep]

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 .

[Jase2]

If I remember rightly - it does.

(Note: If you have an extremely large database, make sure to use the mysqldump binary option that is selected by default.)

Regards Jason :)

[abroad]

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

[Paul M]

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 :)
Yes.

[Jase2]

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

[abroad]

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

[Paul M]

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

[Jase2]

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

Once again, thanks for this great hack ;)

Regards Jason :)

[avsunforum]

thanks

[gertoo]

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

[Paul M]

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.

[abroad]

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?

[Paul M]

Does this work now or not?
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).

[abroad]

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

[Paul M]

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

[snakeair]

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

[connkid25]

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!

[TomJames]

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)

[connkid25]

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

[Paul M]

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

[connkid25]

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!

[Paradigm]

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

[connkid25]

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.

[Jase2]

Yes, you should.

I have mine at:

/home/user/backups

Regards Jason :)

[Michael Biddle]

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

[Shawn Yue]

This Is A Better Version

Thank Paul

[Paradigm]

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

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.

[Paradigm]

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

[Jase2]

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

Regards Jason :)

[Paul M]

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

[sexyeyes83]

Thank you, works great :)

[1quick1]

Installed. Works like a charm just like the 3.6.xx version.

[karel1985]

Hi Paul,

i recently updated my board to 3.7 (2 weeks ago), before i had the 3.6 version installed.
Now the last 2 days, my board doens't come online anymore after the backup.

Should i upgrade to this version (are there changes with the 3.6v?) or what would be the problem?

I haven't change a thing....

[Paul M]

Turn off the board close option.

[yaoren]

Works awesome! Thanks for this!

[Jase2]

Hi Paul,

Is this meant to close your forums? Reason I ask, is because when I tested it out before, it didn't close my forums. I clicked "Run Now".

Do I just set this too 1? :

Close Forum during Backup
$backup['SHUTDOWN'] = 0;

Can any problems arise from having your forum stay open, or is it best to close them?

Also, how do we get it to save as one .sql file, and not a .sql file for each table?

[Paul M]

Yes, you would set that to 1. I dont close my forums.

As i recall, for one file you would set the combine option to 1.

[Jase2]

I see. Thanks, Paul!

[peterska2]

I've installed this and while it's running quite happily on some of my sites, it isn't working on others.

It appears that it dies and skips the rest of the table after 1.9GB even if the tables are backed up individually. With a 10GB post table on one site and a 2.5GB post table on another this isn't therefore giving the expected results.

Is there a way to get it to handle large tables correctly, or do I need to give up on it as a bad job on these particular sites? The whole reason I installed it is to save me having to log into SSH every day to take backups, but it is looking like it isn't going to stop my need for that at the moment.

[Paul M]

As I recall, this has a 1 hour script timeout so maybe you are exceeding that. Try upping it to 2 hours. There are no size restrictions in this other than ones the OS you are running may apply.

[HybridIllusions]

I've modified this script to create a folder per day, while it creates a backup file in the folder every 6 hours. How is this different? Well, instead of it rewriting the file, it'll make a new one, thus a 6 hour cron per day gives around 4 backup files per folder. I did this by forcing the file name to be a time, instead of a date, as well as

Thus it just creates a new file for each time that a new backup is made, in one folder per day (since the folder name is just the date and not the time, thus it doesn't create another one). How does this help? Well, it helps keep backups of times where the forums could be up and running great, but prevent backing up or replacing a backup of when the forums were hacked or whatever.

So, lets say your forum was backed up. Awesome! Now, sometime before the next backup, a hacker or someone you thought you could trust goes crazy and deletes all posts, users, or just generally messes up the software data. Well, unless caught before the next backup and the forums are running fine enough to use crons, then it'll replace the old backup file with the screwed up one. Thus, the backup won't help in that situation...

So, I just have it do a 6 hour backup per day, thus around 4 backup files in one daily folder. Anyways, just wanted to explain this, and am willing to help or re-release my modified version that does just this. However, I would need permission first, so that's why I'm posting.

If not, oh well. Thanks for releasing a killer mod! Definitely making me feel at ease :D

[nothing4me]

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

[HybridIllusions]

I get the error:

Make sure the path to store the backups is correct (must create a all folders in the path, if not already created)

[drsli]

As I recall, this has a 1 hour script timeout so maybe you are exceeding that. Try upping it to 2 hours. There are no size restrictions in this other than ones the OS you are running may apply.
First of all - thank you very much for providing this useful enhancement! :)

Regarding the timeouts I wonder about the flaweless function of this tool within my server-restrictions: as my provider told me, there is a timeout of 30 seconds regarding perl- and php-sripts. My database is growing beyond 30 mbs, maybe that could provoke an interruption of the backup-tool with an incomplete dump?

[Paul M]

This should override the 30 second default timeout in php.

[Phaedrus]

How different is this from the 3.6 version that I currently run?

[Paul M]

Minor changes, no need to change it if the 3.6 version is running ok for you.

[Phaedrus]

Minor changes, no need to change it if the 3.6 version is running ok for you.

Very good. I'll mark this one as installed though.

I love this mod. It has made my life much easier.

[SMO]

Paul, just to clarify, and more for my sake... does this have the capability to back up to db on my server automatically and dump thie old one? Where does it save? In what format does it save? Sorry if this had been answered but I couldnt find the exact issues.

thanks

[Phaedrus]

Paul, just to clarify, and more for my sake... does this have the capability to back up to db on my server automatically and dump thie old one? Where does it save? In what format does it save? Sorry if this had been answered but I couldnt find the exact issues.

thanks
This simply backs up your database to somewhere on your server according to the cron timer..

You tell it which file it writes to. Mine goes into a file above the public area so nobody can access it but me...

It has no ability to upload the db, you would have to do that through more mundane means.

[Stryker412]

I have a db question in regards to this mod and wonder if someone could answer it in PM?

[CheeSie]

It never finishes for me, it always get stuck and never fully completes.. how come?

[Paul M]

It never finishes for me, it always get stuck and never fully completes.. how come?
Its not really possible for me to know the answer to that.

[vuiveclub]

this script stops after 30 seconds.

[Paul M]

Perhaps you are running in safe mode ?

[mgurain]

thanks alot Paul M for your great mods,,

1. How does it work ? snapshots please?
My database experiences heavy load,
2.so does this hack backup the database in batches for example and then compliled in one file or even each table in one file ?
3. Does it work with very large databases ?
4. Does it le me choose the folder and file name ?

[CheeSie]

You can choose to have all your tables saved separately or one combined file..
You choose the destination of the saved file..
It crashes 25% of the time when I'm running it on my forum (the complete db is about 400mb)..

[Paul M]

If it crashes 25% of the time then you have a local issue. My db file is over 1GB and it never crashes.

[vuiveclub]

Perhaps you are running in safe mode ?
Yes, i am running in safe mod. My hosting provider cant disable safe mod.

[Paul M]

Then you are screwed, there is no way to overide the 30 second timeout in safe mode.

[1230]

Hi,
what i do for set setting vb Backup?
Time,data and ... . ?

[arena]

Very good master:) Thanks for hack

[glennybee]

Thanks for this, just installed.

I was wondering, does it delete backups after a certain period of time? Or does it continually create backup and you need to manually delete them?

Thanks :)

[Paul M]

It does not delete backups (unless they are the same name as the new one its creating, in which case it will overwrite).

[glennybee]

Thanks you for the reply Paul. :)

[Fabsboards]

Thanks Paul!

[b6gm6n]

anyone know the path to outside public html? i have errors cannot write file, i have set the backups dir to > home/mysitecom/backups and set the chmod to 777

[Paul M]

its usually better to use a relative path, like ../../backups/

[b6gm6n]

its usually better to use a relative path, like ../../backups/
ahh right thanks, thats 'backups' within public html? - well ok then :)

[b6gm6n]

i should of used outside pub_html to save space... its not writing a file for me whatever dir i try or do... should of worked the first time, i'll read through this thread and see if i can find a solutions, cheers

EDIT, the solution for me was to write these databases outside of public_html, security and space saving...

The people having problems are forgetting the forward slash

/home/mysitecom/backups/

cheers

one last thing... to make it perfect this hack should gzip the output file and maybe have a setting to keep backups for a defined time period, say...going back 3 weeks or 2 days or whatever :)

cheers

[Paul M]

ahh right thanks, thats 'backups' within public html? - well ok then :)
Its just an example, not a suggestion of what to actually use.

[XFSImperial]

Installed. We'll see how things go tonight at 1:00AM :)

[b6gm6n]

well i waited a day...only ran the once (by me pressing run-now) for some reason it's not working, i have lost confidence, uninstalled, sorry dude

[Paul M]

Works fine if you set it up correctly, not much i can do if you dont. :)

[b6gm6n]

Works fine if you set it up correctly, not much i can do if you dont. :)

yeah your right, i know.... i just got frustrated with it as other things were praying on my mind, re: other webbby stuff not installing...or driving me mad :)

[energetic]

installed and thanks
please tell how to restore the database if needed ?

[Chadi]

It does not delete backups (unless they are the same name as the new one its creating, in which case it will overwrite).

Could you possibly add this feature to automatically prune backups older than x amount of days? That would be great.

[Paul M]

Sorry, I wont be adding any features to this in the forseeable future.

[Jason Buchanan]

I am a true rookie when it comes to this. Does it matter which folder on the server I upload the files too, or do they go in the forum folder?

[Paul M]

Copy the files in the includes folder to your forum includes folder, similar for the cron folder.

[Jason Buchanan]

Okay I have installed everything in the proper folders. I click run and get:
Automatic Database Backup for vBulletin 3.7

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

I created a folder named backups? What else should I do and how do I CHMod a folder to 777?

[Jason Buchanan]

I changed all the 0666 to 0777 and now when I run it I get this:

Automatic Database Backup for vBulletin 3.7

Warning: require_once([path]/includes/mysqlbackup.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/cron/cronbackup.php on line 19

Fatal error: require_once() [function.require]: Failed opening required '/home/darkhors/public_html/forum/includes/mysqlbackup.php' (include_path='.:/usr/local/php52/pear') in /home/darkhors/public_html/forum/includes/cron/cronbackup.php on line 19

[TrIn@dOr]

Thanks.

[shlomot]

Thanks for this important MOD. However, I'm getting the same error: I get the error: An error occured during the Backup : Could not open Destination SQL file for writing.

The situation is as follows:

1. I didn't edit anything in mysqlbackupconfig.php

2. Since the relative path for the backup files is '../../backups/', I created a 'backups' folder in forum root and chmod to '777'

What am I missing here? Thanks for your help.

[|Jordan|]

Is there any way to have it automatically compress the backed up database? The backup can be quite large.

[russbo]

try ./backups/ if your backup folder is in the forum root, or, ../forum/backups/

I had to play with mine for a bit. You guys get this error when the config file can't find the backups folder.

I put mine outside the forum root, and outside the public html root so that it's more protected. use the actual server path to the folder if you want to do it that way.

[Paul M]

What am I missing here? Thanks for your help.
Probably open_basdir protection.

Is there any way to have it automatically compress the backed up database? The backup can be quite large.
Nope, this has no such facility.

[shlomot]

Probably open_basdir protection.

How can I overcome this challenge?

[Paul M]

Read this (http://help.godaddy.com/topic/121/article/1616), and speak to your host.

[shlomot]

Thank you. Will do.

Read this (http://help.godaddy.com/topic/121/article/1616), and speak to your host.

[SaPh[i]R]

Can we configure the hack to save database in another FTP Please ?

[Paul M]

Nope, you cannot do that with this mod.

[chet]

Nice one, Installed

[LCN2007]

Im a little lost i wanted to use this great hack when i was 3.6 but got the same error.

Automatic Database Backup for vBulletin 3.7

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

can someone help me?

[LCN2007]

Can Anyone help?

[Paul M]

If you read the thread you will see that this is down to permissions on your server, there is not much we can do as you havent really given any information.

[Artes_Marciales]

Thanks Paul, Great mod.
does she work if the data base is very heavy? (around 1GB)

Best Regards!

[Paul M]

Yes, should be fine.

[Artes_Marciales]

Thanks for reply!! : )
**installed**

[69lakalle]

I get this error: and my forum stays with the error and the backup wont complete i cant even access admincp....but when reparing tables everything go back to normal, but i can never do backup, i get that error, before it was all good now idk what happen it wont work


Database error in vBulletin 3.7.0:

Invalid SQL:
CHECK TABLE `post_thanks`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, June 17th 2008 @ 04:11:16 AM
Error Date : Tuesday, June 17th 2008 @ 04:12:07 AM
Script : http://www.xxxx/forums/admincp/cronadmin.php?do=runcron&cronid=27
Referrer : http://www.xxxx/forums/admincp/cronadmin.php?do=modify
IP Address : xxxxxxxx
Username : xxxxxx
Classname : vB_Database
MySQL Version :

[Paul M]

You mysql timeout must be very low - I would say the database connection is timing out checking the previous table, which I would guess is the post table.

[Sakai Ray]

This is great clicks install.

[PGAmerica]

This mod rocks, I am having 2 problems.

1) Whenever I modify my "mysqlbackupconfig.php" file to exclude tables from the backup, I get an error that says Parse error: parse error, unexpected ',', expecting ']' in mysqlbackupconfig.php on line 29
Line 29 is where I put in my exclusions. The currently say $backup['TYPE'] = 2; // 1 = Only Specified Tables, 2 = All except Specified Tables
$backup['quiz_questions','quiz_answers'] = array(); // Table List - e.g. array('table1', 'table2')

They are large and never change so I do not want them backup up. There is nothing wrong with the way they are entered into the array. What is wrong here?

2) The scheduled task area does not have an option to make a task run every 3rd day. How do I do this? This is not a busy site, I have no need for a daily backup.

Ideas?

[Paul M]

1. The example clearly shows you put the tables in the array, you have not done this.

$backup['TABLES'] = array('quiz_questions','quiz_answers');


2. You cannot do this with the vb cron system.

[PGAmerica]

1. The example clearly shows you put the tables in the array, you have not done this.D'Oh! I am such an idiot! Thanks
2. You cannot do this with the vb cron system.Is there mod out there that allows me another choice for cron execution?

[69lakalle]

You mysql timeout must be very low - I would say the database connection is timing out checking the previous table, which I would guess is the post table.
Thank You
What should i do?
Contact webhost ?
What is a good timeout for mysql ?
Thank You again

[Paul M]

If you are on a shared server then contact your host - dont hold out too much hope tho.

[BeerLuver]

Excellent mod/addon :). I'm not too savvy with setting up cronjobs/scheduled tasks properly, so this worked perfectly. Saves a lot of time and hassle for doing regular backups; which I often tend to forget to do heh.

So huge thanks for this :up:

[Paul M]

Is there mod out there that allows me another choice for cron execution?
None I know of.

[Artes_Marciales]

There is any way that files not contain in your name the date but the folder yes contain?
Best Regards!!

**nominated**

[Paul M]

Nope, both will have the date.

[Artes_Marciales]

OK, thanks Paul.
then if I have to restore the data base I have to rename all of the files? : (

Best Regards!!

[Paul M]

Why do you have to rename the files, there is no reason to have to do that.

[abdelghani68]

Thanks for this hack.

Can you help me please, i have some probleme with some emphasis.

how to resolve the problem

thanks

[Artes_Marciales]

Why do you have to rename the files, there is no reason to have to do that.
Ok thanks.
then like I must restore a data base?

I thought that files should have had the same names than originals :rolleyes:

Best Regards!! : )

[fedorama]

I'm pretty green and would love if someone can hold my hand here -

OK, I downloaded it, and read the instructions, here -

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.

OK, so I understand 1, 3, and 4, but how do I set choices in the mysqlbackupconfig.php file , can this be done AFTER from the acp, or the actual file needs to be edited ( I'm no programmer or coder, and have no clue what to edit)

The most important thing - WHERE should the back-up go - I read here it's unsafe to put it in the public_html, and should be in the root.

Would someone kindly assist me (pm or here, or in the forums) to go thru it step by step - my database is not large now, about 30 MB, but I need to back-up now and weekly.

[Paul M]

For option 2 you edit the actual file.

[captainron19]

Excellent Mod - just installed - couple of quick questions...

Is it recommended I turn off boards to do a backup? I just did a "Run Now" in the scheduled Task Manager and it backed up my entire forum in about 30 seconds at 40MB (so it is not that large)

Will it overwrite the previous backup or will I have to routinely ftp in and delete the old files?

Currently I am saving backups in public_html/backups with path being ../backups/

I understand it is not wise to have in acceptible location where accessible by public so where should I save to and what would the path to that section be?

I was going to protect the directory with ausername and password but I am assuming that if I do that it will not only prevent unwanted people from accessing but it will also prevent the mod from saving the backup file to that location.... true?

any help would be appreciated

[Paul M]

Where you save it will be server dependant, but outside your public folder would be best.

If you mean an htaccess user/password, then that should not affect this mods ability to write to the folder.

Previous backups will not be overwritten unless they are named the same.

[captainron19]

If you mean an htaccess user/password, then that should not affect this mods ability to write to the folder.



not sure about htaccess user/password - whenever I want to protect a directory I just go into cpanel and click on "protect files and folders" and then choose a folder to protect and designate a username and password

[Jase2]

Hi Paul,

A few questions. Currently, I have one .sql per table. How would I change this? Also, what would you recommend: One file named the same each time so that it is overwritten, or one .sql per table. Personally, I think if you should ever need to restore a backup, then one .sql per table is possibly better, since you may only need to restore a certain table, ect.

Oh, as mine currently is, one .sql per table, I usually delete one or two backups after a few days and save usually three, but when I delete them, I ALWAYS optimize the tables afterwards. Is this needed or not?

[Paul M]

You change it in the config file.

I have one file per table, you can always join them together later if needed.

You rarely need to optimize tables.

[Jase2]

Ok, thanks for your reply Paul, much appreciated. :)

[malomairy]

just installed it and it worked fine by pressing run now, i have the following questions:

1- Cron didn't start as scheduled, i put day of week to * and day of month to * and hour to 4AM, so this should backup the DB everyday at 4AM, one day passed with no backup. is there anything else i have to do?

2- which is better backup up DB on one file, or have it Table by Table?

3- I've never done restore so far, so how and what is the fastest way to restore DB?

Thanks Paul for this great Mod.

[tazzarkin]

Thanks for posting this thread. It's always good to have more than one option.

----------------
Might as well just set up a cron job.

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

Regards Jason :)

[tazzarkin]

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.

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

No one ever answered seangworld, and I pretty much have the same question.

How is this better than the backup in the acp?

[XFSImperial]

I've installed this mod on a forum of mine, it has worked well so I decided to install it on another. I'm getting this error though:

Parse error: syntax error, unexpected T_STRING in D:\Websites\xboxnation\forums\includes\mysqlbackup config.php on line 24

Running IIS on Windows 2003, any suggestions?

[Paul M]

Correct the error you have made editing the file.

[War_force]

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

what can I do?

[Pavlus]

I have a little problem here.

Sometimes when i use option - close board due to backup, board will not automaticaly open after process.

Today i just disabled it because morning backup failed. My database is very small about 23mb, when i making backup - manualy using this product - process stops at one of the tables polls f.e and its stucked....

Any ideas? From today everything was ok.

[Paul M]

That is known to happen from time to time - the only answer is dont use that option. Its not necessary to close the board.

[Pavlus]

Ok but there is also another complication, now backup stops at some table and dont go forward. From 23mb of database only 6mb have been backuped :/

I didnt changed anything, forum stands on shared gosting, do you thing that admins could provide me with new restrictions? Maybe script gets timeouted?

[Angels1928]

Can someone reupload the file that was posted in the beginning of this thread, the one that finds the file's location in means of "home/root/public_html" or something like that? I need to change my "backup location".

edit--

Nevermind, found it elsewhere on the 'net. Here it is, reuploaded on here

[rockinaway]

I get this error:

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

What is wrong?

[pspmaster93]

heres what error it gives me when i go to scheduled tasks and try and run it

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

heres what i put for config

<?php
/*
<!-- $Header: d:\cvs/3.7/Auto-backup/includes/mysqlbackupconfig.php,v 3.2 2008/01/06 15:32:44 pem Exp $ -->

Auto-Backup (Lite) for vBulletin 3.7 - Paul M - v 3.7.001
This lite version is adapted from the original 3.0 version by Trigunflame.
*/

// Combine all tables into one file
$backup['COMBINE'] = 1; // 0 = No, 1 = Yes

// Close Forum during Backup
$backup['SHUTDOWN'] = 1; // 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'] = 'warez-4u.com/backup/'; // Path to backups folder, must have a trailing slash

// -----------------------------------------------------------------------------------------------//

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

?>

[Super Jinni]

Installed and works perfectly..

thanks Paul

[Paul M]

heres what error it gives me when i go to scheduled tasks and try and run it

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

heres what i put for config

Either the backup path is wrong, or your webserver does not have permission to write to it. If I were guessing, I would say the former.

[rockinaway]

I have checked the destination folder and chmodded the directory, yet I get the same error.. why?

[Paul M]

I cannot possibly answer that, security/permissions are server specific, speak to your host.

[Vinyljunky]

Paul,

Have you released a Pro version?

I'd like something that only keeps x backups etc....

Thanks

VinylJunky

[Paul M]

Sorry, this is the only version.

[Super Jinni]

Hi Paul

I've installed this just yesterday and it works well.
but,
when I checked the backup folder, I found that there is two folders inside, with the names:
2008-Jul-16
2008-Jul-17

and as I see these folders contain the backups of yesterday and today, and in this way I think it will create a new folder every time it makes backup..

is this ok? or there is some thing wrong with it?
should I do anything else?

I thought the old backup will be replaced with the newest one.. and only have one folder..

any suggestions?

thanks

:)

[Paul M]

Its working exactly as expected.

[Super Jinni]

should I delete the older ones or keep them?

I mean I think the newest one is all what I need, right?

thanks

:)

[Paul M]

Thats your decision, not mine.

[Super Jinni]

What I mean is that,
is there any differences between the newest one and the ones older than it?

if I delete the older ones and only keep the newest one, it will be enough if I want to restore my forum if I needed to?

I'm sorry for my foolishness but I'm new for database backup matters

thanks

:)

[Rideharder]

Ok this is alittle nuts I know I have two hosting plans on one I have my DB and on one I have all my files .. I tryed this and this is what I got

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

what do I need to do to point it to my DB?

[Paul M]

Thats a server permission error (as mentioned numerous times in previous pages).

[Rideharder]

Thanks Paul, but what I need to know will this mod still work for my Database that is hosted on www.xxxx.com and all my files for my board it loaded on www.xxxx.net with no Database?

[Paul M]

I dont understand your question.

This backs up whatever database your forum is using.

[Super Jinni]

aah, sorry

I got the previous reply wrong..

thanks anyway

:)

[Rideharder]

I dont understand your question.

This backs up whatever database your forum is using.


I have two cpanel...
I loaded my vBulletin files I used FTP to www.speedxxx.net..
I created my database on www.usaXXXX.net..
Some how the www.speedxxx.net cpanel used the www.usaXXXX.net database I made..

I was sleepy at the time okie lol

They have the same DNS

I know alittle nuts hmm..

[Paul M]

If your forum works then this will work.

[BigJohnny]

is this a lite version?

[Paul M]

Yes.

[BigJohnny]

so what would be the "heavy" version?

[Paul M]

There is no heavy version, except for vb 3.0.

[pranaysanghavi]

<i>Alter the timing of the cron job to suit.</i>
How to do that?
sorry, am new to all this

[briansol]

go into your schedule task manager, find the product name, and change the time there, save.

Paul- great mod/adaptation.

gzip seems to be a big request.
If i build it, would you have a problem adding it on to this?

[lele816]

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

why??

[briansol]

check your path.

the config file is a little misleading. it makes you think you can enter ../forums/ or whatever, but it SHOULD be the URI to your directory, like /var/vhosts/home/yoursite/nonpublic/

[jkcerda]

nice

[trulylowcarb]

SWEET! Installed and my first backup already ran successfully - thanks so much for this TERRIFIC mod.

[Paul M]

check your path.

the config file is a little misleading. it makes you think you can enter ../forums/ or whatever, but it SHOULD be the URI to your directory, like /var/vhosts/home/yoursite/nonpublic/


There is nothing misleading - relative paths are perfectly acceptable.

[PAKIDIL]

One question please does this backup all the forum,threads,post etc ?automatically the time,day we set it to .

[Paul M]

All those are part of the database, so yes.

[PAKIDIL]

what is the best configuration for the mysqlconfig ? whats the operation of this

// Combine all tables into one file

= 'Forum-'; // Backup file prefix, applied to all files
= '../../backups/'; // Path to backups folder, must have a trailing slash

what should come in forum- fields ?
and
../../backups; shoudl it be like http://www.sitename.com/forum/backups ?

[briansol]

the option is there to have 1 file per table
or 1 file for the whole thing.

the path should NEVER be web accessible. it should be at the same level or below your public_html/ directory. Keeping your backups web acessible is a huge security risk, as anyone can download your entire site and have all your content and user emails

i suggest using a path URI,

ie,

/home/yoursite/backup/
where
/home/yoursite/public_html/ is your web root.

[PAKIDIL]

okay .i have do it as i say put Y-m-d = 2008-08-10

i have put backup location

and upload autoback

but its not showing in vbulletin option ?
can any one help me abt it

[Paul M]

Nothing in this is supposed to show in vb options

[PAKIDIL]

hello please check is this is correct

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

where abd is my account id

and does this '2008-AUG-11' we have to set it manually every time we wants to make auto backup

waiting for ur reply
thanks

[Paul M]

No, its not correct - read the comments for each setting (e.g. you use the php date format for that setting - hence the nice link to their site).

[PAKIDIL]

// File Saving Information
$backup['DATE'] = '2008-01-01'; // Backup file date format (See http://uk.php.net/date)
$backup['PREFIX'] = 'Forum-'; // Backup file prefix, applied to all files
$backup['DUMP_PATH'] = 'home/abd/backups'; // Path to backups folder, must have a trailing slash
now check please and also tell me one thing that i have to set it manually to make backup file and upload the file ? thanks

[Jaxel]

Got the following error when running this cronjob...

Database error in vBulletin 3.7.2:

Invalid SQL:

REPLACE INTO datastore
(title, data, unserialize)
VALUES
('options', 'a:478:{s:15:\"templateversion\";s:5:\"3.7.2\";s:19:\"subscriptionmethods\";i:1;s:10:\"attachfile\";s:1:\"2\";s:7:\"hv_type\";s:9:\"Recaptcha\";s:22:\"hv_recaptcha_publickey\";s:40:\"6LeRuAIAAAAAAFA7It7n9_Ptw85R3IDRoUS2Nli1\";s:23:\"hv_recaptcha_privatekey\";s:40:\"6LeRuAIAAAAAAIXrcWKTgfZUo4x6QMRwqpHEwwSN\";s:18:\"hv_recaptcha_theme\";s:5:\"clean\";s:12:\"regimagetype\";s:5:\"GDttf\";s:10:\"attachpath\";s:13:\"./attachments\";s:14:\"regimageoption\";i:13;s:13:\"usefileavatar\";i:1;s:10:\"avatarpath\";s:15:\"./customavatars\";s:9:\"avatarurl\";s:13:\"customavatars\";s:14:\"profilepicpath\";s:19:\"./customprofilepics\";s:13:\"profilepicurl\";s:17:\"customprofilepics\";s:10:\"sigpicpath\";s:15:\"./signaturepics\";s:9:\"sigpicurl\";s:13:\"signaturepics\";s:14:\"fulltextsearch\";i:1;s:13:\"album_dataloc\";s:14:\"fs_directthumb\";s:13:\"album_picpath\";s:14:\"./customalbums\";s:15:\"album_thumbpath\";s:21:\"./customalbums/thumbs\";s:14:\"album_thumburl\";s:20:\"/customalbums/thumbs\";s:8:\"bbactive\";s:1:\"1\";s:14:\"bbclosedreason\";s:111:\"<p>Sorry, the board is unavailable at the moment while we add new features.</p>\r\n<p>We will be back soon...</p>\";s:7:\"bbtitle\";s:7:\"8WayRun\";s:5:\"bburl\";s:22:\"http://www.8wayrun.com\";s:9:\"hometitle\";s:7:\"8WayRun\";s:7:\"homeurl\";s:22:\"http://www.8wayrun.com\";s:13:\"contactuslink\";s:15:\"sendmessage.php\";s:13:\"contactustype\";i:1;s:16:\"contactusoptions\";s:35:\"Site Feedback\r\nRegistration Problem\";s:14:\"webmasteremail\";s:23:\"jaxel@crookedjester.com\";s:10:\"privacyurl\";s:0:\"\";s:13:\"copyrighttext\";s:49:\"Copyright ?2000 - 2008, Jelsoft Enterprises Ltd.\";s:11:\"companyname\";s:0:\"\";s:9:\"faxnumber\";s:0:\"\";s:7:\"address\";s:0:\"\";s:8:\"keywords\";s:638:\"soul calibur 4, soul calibur 3, soul calibur 2, soul calibur, soul edge, soul blade, Abyss, Abelia, Aeon Calcos, Algol, Amy, Angol Fear, Arthur, Ashlotte, Assassin, Astaroth, Aurelia, Berserker, Cassandra, Cervantes, Charade, Chester, Demuth, Edge Master, Girardot, Greed, Han-myeong, Hilde, Hualin, Hwang, Inferno, Ivy, Kamikirimusi, Kilik, Li Long, Lizardman, Luna, Lynette, Maxi, Miser, Mitsurugi, Necrid, Night Terror, Nightmare, Olcadan, Raphael, Revenant, Rock, Scheherazade, Seong Mi-na, Seong Mina, Setsuka, Shura, Siegfried, Sophitia, Strife, Taki, Talim, Tira, Valeria, Voldo, Xianghua, Yoshimitsu, Yun-seong, Yunsung, Zasalamel\";s:11:\"description\";s:62:\"A Tournament Competitive Community for the Soul Calibur series\";s:12:\"useforumjump\";i:1;s:12:\"pagenavpages\";i:10;s:8:\"pagenavs\";s:18:\"10 50 100 500 1000\";s:12:\"enableaccess\";i:0;s:15:\"addtemplatename\";i:1;s:15:\"usestrikesystem\";i:1;s:12:\"forumleaders\";i:1;s:16:\"allowedreferrers\";s:12:\".8wayrun.com\";s:13:\"threadmarking\";s:1:\"0\";s:12:\"markinglimit\";i:10;s:12:\"disable_ajax\";i:0;s:21:\"enable_inlinemod_auth\";i:1;s:9:\"imagetype\";s:2:\"GD\";s:10:\"magickpath\";s:0:\"\";s:20:\"hvcheck_registration\";i:1;s:12:\"hvcheck_post\";i:1;s:14:\"hvcheck_search\";i:1;s:17:\"hvcheck_contactus\";i:1;s:8:\"yestoday\";i:2;s:10:\"timeoffset\";i:-5;s:8:\"dstonoff\";i:0;s:10:\"dateformat\";s:5:\"m-d-Y\";s:10:\"timeformat\";s:5:\"h:i A\";s:20:\"registereddateformat\";s:3:\"M Y\";s:10:\"calformat1\";s:6:\"F j, Y\";s:10:\"calformat2\";s:3:\"F j\";s:13:\"logdateformat\";s:11:\"H:i, jS M Y\";s:13:\"cookietimeout\";i:1800;s:10:\"cookiepath\";s:1:\"/\";s:12:\"cookiedomain\";s:12:\".8wayrun.com\";s:10:\"gzipoutput\";i:1;s:9:\"gziplevel\";i:1;s:10:\"addheaders\";i:0;s:10:\"ie8render7\";i:1;s:14:\"nocacheheaders\";i:0;s:17:\"useheaderredirect\";i:1;s:12:\"allowphpinfo\";i:0;s:11:\"cachemaxage\";i:7;s:15:\"threadviewslive\";i:1;s:19:\"attachmentviewslive\";i:1;s:9:\"loadlimit\";i:0;s:10:\"safeupload\";i:0;s:7:\"tmppath\";s:4:\"/tmp\";s:13:\"copypostindex\";i:1;s:7:\"ipcheck\";i:1;s:9:\"remoteyui\";i:1;s:10:\"languageid\";i:1;s:7:\"styleid\";i:3;s:17:\"allowchangestyles\";i:1;s:11:\"cleargifurl\";s:9:\"clear.gif\";s:14:\"storecssasfile\";i:0;s:9:\"usepopups\";i:1;s:13:\"legacypostbit\";i:0;s:11:\"showimicons\";i:1;s:12:\"skypeweb_gfx\";i:1;s:12:\"enablecensor\";i:0;s:10:\"censorchar\";s:1:\"*\";s:11:\"censorwords\";s:0:\"\";s:15:\"blankasciistrip\";s:0:\"\";s:11:\"enableemail\";i:1;s:13:\"displayemails\";i:1;s:11:\"secureemail\";i:1;s:14:\"emailfloodtime\";i:60;s:12:\"usemailqueue\";i:1;s:12:\"emailsendnum\";i:10;s:11:\"bounceemail\";s:0:\"\";s:13:\"needfromemail\";i:0;s:8:\"use_smtp\";i:0;s:9:\"smtp_host\";s:0:\"\";s:9:\"smtp_port\";i:25;s:9:\"smtp_user\";s:0:\"\";s:9:\"smtp_pass\";s:0:\"\";s:8:\"smtp_tls\";i:0;s:17:\"allowregistration\";i:1;s:8:\"usecoppa\";i:0;s:10:\"checkcoppa\";i:0;s:18:\"moderatenewmembers\";i:0;s:11:\"welcomemail\";i:1;s:9:\"welcomepm\";s:1:\"1\";s:12:\"newuseremail\";s:0:\"\";s:14:\"allowmultiregs\";i:0;s:11:\"verifyemail\";i:1;s:18:\"requireuniqueemail\";i:1;s:13:\"minuserlength\";i:3;s:13:\"maxuserlength\";i:16;s:16:\"illegalusernames\";s:5:\"Jaxel\";s:13:\"usernameregex\";s:20:\"^((\\w)|[\\-\\=\\.\\@])+$\";s:11:\"usereferrer\";i:1;s:17:\"defaultregoptions\";i:13075133;s:18:\"usernamereusedelay\";i:365;s:9:\"uiforumid\";i:0;s:9:\"uimessage\";i:1;s:9:\"rpforumid\";i:0;s:8:\"rpuserid\";s:1:\"0\";s:7:\"rpemail\";i:1;s:6:\"socnet\";i:31;s:11:\"reqbirthday\";i:0;s:10:\"ctMaxChars\";i:25;s:13:\"ctCensorWords\";s:38:\"admin forum moderator vbulletin leader\";s:11:\"ctCensorMod\";i:1;s:18:\"minifriends_amount\";i:6;s:16:\"friends_per_page\";i:10;s:18:\"profilemaxvisitors\";i:10;s:15:\"profilelastpost\";i:0;s:18:\"softlinebreakchars\";i:90;s:10:\"ignoremods\";i:0;s:21:\"usercss_allowed_fonts\";s:446:\"arial|Arial, Helvetica, sans-serif\r\ntimes_new_roman|\'Times New Roman\', Times, serif\r\ncourier_new|\'Courier New\', Courier, monospace\r\ngeorgia|Georgia, \'Times New Roman\', Times, serif\r\nverdana|Verdana, Arial, Helvetica, sans-serif\r\ntahoma|Tahoma, Verdana, Arial, Helvetica, sans-serif\r\ngeneva|Geneva, Arial, Helvetica, sans-serif\r\ntrebuchet_ms|\'Trebuchet MS\', Arial, Helvetica, sans-serif\r\ncomic_sans_ms|\'Comic Sans MS\', Arial, Helvetica, sans-serif\";s:26:\"usercss_allowed_font_sizes\";s:39:\"small|small\r\nmedium|medium\r\nlarge|large\";s:29:\"usercss_allowed_border_widths\";s:32:\"small|1px\r\nmedium|2px\r\nlarge|3px\";s:23:\"usercss_allowed_padding\";s:80:\"none|0px\r\ntiny|1px\r\nsmall|2px\r\nmedium|3px\r\ nlarge|6px\r\nhuge|10px\r\ngargantuan|20px\";s:14:\"albums_perpage\";i:10;s:22:\"album_pictures_perpage\";i:25;s:20:\"profile_album_amount\";i:5;s:26:\"albums_pictures_moderation\";i:0;s:15:\"album_thumbsize\";i:160;s:23:\"album_captionpreviewlen\";i:150;s:18:\"album_uploadamount\";i:5;s:21:\"album_maxpicsperalbum\";i:0;s:10:\"pc_enabled\";i:1;s:13:\"pc_moderation\";i:0;s:10:\"pc_perpage\";i:10;s:13:\"pc_maxperpage\";i:50;s:17:\"pc_allowed_bbcode\";i:1091;s:11:\"vm_maxchars\";i:1000;s:10:\"vm_perpage\";i:10;s:13:\"vm_maxperpage\";i:50;s:13:\"vm_moderation\";i:0;s:17:\"vm_allowed_bbcode\";i:1091;s:16:\"sg_name_maxchars\";i:50;s:17:\"social_moderation\";i:0;s:24:\"sg_allow_owner_mod_queue\";i:0;s:25:\"socnet_groups_msg_enabled\";i:1;s:21:\"sg_allow_join_to_view\";i:0;s:28:\"socnet_groups_albums_enabled\";i:1;s:17:\"sg_allowed_bbcode\";i:1091;s:27:\"sg_allow_delete_empty_group\";i:1;s:13:\"avatarenabled\";i:1;s:14:\"numavatarswide\";i:5;s:17:\"numavatarsperpage\";i:30;s:17:\"profilepicenabled\";i:1;s:16:\"reputationenable\";i:0;s:17:\"reputationdefault\";i:10;s:19:\"reputationundefined\";s:16:\"is off the scale\";s:13:\"showuserrates\";i:5;s:10:\"adminpower\";i:10;s:7:\"rdpower\";i:365;s:7:\"pcpower\";i:1000;s:7:\"kppower\";i:100;s:17:\"minreputationpost\";i:50;s:18:\"minreputationcount\";i:10;s:19:\"maxreputationperday\";i:10;s:16:\"reputationrepeat\";i:20;s:13:\"unallowvbcode\";i:1;s:14:\"unallowsmilies\";i:1;s:10:\"unallowimg\";i:1;s:11:\"unallowhtml\";i:0;s:16:\"enablememberlist\";i:1;s:15:\"memberlistposts\";i:0;s:16:\"memberlistfields\";i:1759;s:17:\"memberlistperpage\";i:50;s:22:\"usememberlistadvsearch\";i:1;s:13:\"enablebanning\";i:1;s:5:\"banip\";s:0:\"\";s:8:\"banemail\";s:0:\"\";s:18:\"aggressiveemailban\";i:0;s:20:\"allowkeepbannedemail\";i:1;s:12:\"globalignore\";s:0:\"\";s:14:\"allowedbbcodes\";i:1023;s:12:\"codemaxlines\";i:30;s:11:\"allowbbcode\";i:1;s:12:\"allowsmilies\";i:1;s:16:\"allowbbimagecode\";i:0;s:9:\"allowhtml\";i:0;s:10:\"quickreply\";i:1;s:9:\"quickedit\";i:1;s:10:\"multiquote\";s:1:\"1\";s:7:\"mqlimit\";i:0;s:12:\"postminchars\";i:10;s:12:\"postmaxchars\";i:0;s:13:\"titlemaxchars\";i:70;s:16:\"ignorequotechars\";i:1;s:10:\"quotetitle\";i:1;s:9:\"maximages\";i:0;s:12:\"stopshouting\";i:5;s:14:\"floodchecktime\";i:30;s:20:\"editthreadtitlelimit\";i:5;s:14:\"addpolltimeout\";i:0;s:13:\"edittimelimit\";i:0;s:14:\"noeditedbytime\";i:10;s:5:\"logip\";i:1;s:15:\"postedithistory\";i:1;s:11:\"editormodes\";s:45:\"a:3:{s:2:\"fe\";i:2;s:2:\"qr\";i:2;s:2:\"qe\";i:2;}\";s:7:\"smtotal\";i:8;s:9:\"smcolumns\";i:2;s:15:\"wysiwyg_smtotal\";i:15;s:16:\"attachtotalspace\";i:0;s:11:\"attachlimit\";i:5;s:14:\"attachboxcount\";i:1;s:14:\"attachurlcount\";i:1;s:14:\"allowattachdel\";i:1;s:20:\"allowclosedattachdel\";i:0;s:15:\"allowduplicates\";i:1;s:12:\"attachresize\";i:1;s:18:\"viewattachedimages\";i:1;s:12:\"attachthumbs\";i:1;s:16:\"attachthumbssize\";i:100;s:12:\"thumbquality\";i:75;s:9:\"attachrow\";i:5;s:10:\"thumbcolor\";s:7:\"#000000\";s:15:\"lightboxenabled\";i:1;s:14:\"maxpolloptions\";i:10;s:13:\"maxpolllength\";i:100;s:14:\"updatelastpost\";i:0;s:9:\"showvotes\";i:1;s:10:\"votechange\";i:0;s:14:\"enablesearches\";i:1;s:15:\"searchfloodtime\";i:0;s:13:\"searchperpage\";i:25;s:10:\"maxresults\";i:500;s:15:\"minsearchlength\";i:4;s:19:\"similarthreadsearch\";i:0;s:13:\"searchsharing\";i:1;s:22:\"similarthreadthreshold\";d:3.5;s:8:\"badwords\";s:0:\"\";s:9:\"goodwords\";s:14:\"vb vbb php sql\";s:15:\"maxsearchlength\";i:20;s:14:\"allowwildcards\";i:1;s:15:\"multimatchscore\";i:15;s:9:\"datescore\";i:15;s:16:\"threadtitlescore\";i:5;s:14:\"posttitlescore\";i:5;s:10:\"replyscore\";d:0.100000000000000005551115123125782702118158340 4541015625;s:9:\"replyfunc\";s:4:\"none\";s:9:\"viewscore\";d:0.010000000000000000208166817117216851329430937 76702880859375;s:8:\"viewfunc\";s:4:\"none\";s:9:\"ratescore\";d:0.5;s:8:\"ratefunc\";s:4:\"none\";s:13:\"threadtagging\";i:0;s:9:\"tagminlen\";i:3;s:9:\"tagmaxlen\";i:25;s:11:\"tagbadwords\";s:0:\"\";s:12:\"taggoodwords\";s:0:\"\";s:12:\"tagdelimiter\";s:0:\"\";s:12:\"tagmaxthread\";i:25;s:13:\"tagmaxstarter\";i:5;s:10:\"tagmaxuser\";i:2;s:13:\"tagforcelower\";i:1;s:13:\"tagcloud_tags\";i:70;s:15:\"tagcloud_levels\";i:5;s:18:\"tagcloud_cachetime\";i:30;s:21:\"tagcloud_usagehistory\";i:365;s:18:\"tagcloud_usergroup\";i:2;s:20:\"tagcloud_searchcloud\";i:1;s:22:\"tagcloud_searchhistory\";i:30;s:9:\"forumhome\";s:6:\"forums\";s:15:\"displayloggedin\";i:1;s:13:\"showbirthdays\";i:1;s:10:\"showevents\";i:1;s:12:\"showholidays\";i:1;s:13:\"showeventtype\";i:0;s:16:\"activememberdays\";i:30;s:19:\"activememberoptions\";i:3;s:14:\"forumhomedepth\";i:2;s:17:\"forumdisplaydepth\";i:2;s:13:\"subforumdepth\";i:0;s:20:\"showforumdescription\";i:1;s:17:\"showprivateforums\";s:1:\"0\";s:9:\"showlocks\";i:0;s:15:\"lastthreadchars\";i:50;s:19:\"showmoderatorcolumn\";i:0;s:18:\"showprefixlastpost\";i:0;s:13:\"nav_forumdesc\";i:0;s:14:\"showforumusers\";i:0;s:10:\"maxthreads\";i:20;s:12:\"showstickies\";i:1;s:8:\"showdots\";i:1;s:13:\"usehotthreads\";i:1;s:14:\"hotnumberviews\";i:150;s:14:\"hotnumberposts\";i:15;s:11:\"linktopages\";i:1;s:12:\"maxmultipage\";i:3;s:13:\"threadpreview\";i:150;s:11:\"oneannounce\";i:1;s:15:\"showthreadusers\";i:0;s:8:\"maxposts\";i:20;s:12:\"usermaxposts\";s:14:\"20, 30, 40, 50\";s:11:\"showdeficon\";s:45:\"http://www.8wayrun.com/images/icons/icon1.gif\";s:8:\"wordwrap\";i:0;s:11:\"threadvoted\";i:0;s:16:\"threadsubscribed\";i:1;s:18:\"showsimilarthreads\";i:0;s:12:\"postelements\";i:7;s:15:\"socialbookmarks\";i:0;s:17:\"allowthreadedmode\";i:1;s:12:\"threadedmode\";i:0;s:18:\"threaded_listdepth\";i:5;s:17:\"threaded_maxcache\";i:40;s:18:\"threaded_trimtitle\";i:30;s:9:\"enablepms\";i:1;s:10:\"checknewpm\";i:1;s:10:\"pmmaxchars\";i:0;s:11:\"pmfloodtime\";i:60;s:9:\"pmperpage\";i:50;s:12:\"pmmaxperpage\";i:100;s:14:\"privallowicons\";i:1;s:15:\"privallowbbcode\";i:1;s:16:\"privallowsmilies\";i:1;s:20:\"privallowbbimagecode\";i:1;s:13:\"privallowhtml\";i:0;s:9:\"WOLenable\";i:1;s:10:\"WOLrefresh\";i:60;s:9:\"WOLguests\";i:1;s:10:\"WOLresolve\";i:0;s:13:\"enablespiders\";i:0;s:14:\"archiveenabled\";i:1;s:18:\"archive_threadtype\";i:1;s:22:\"archive_threadsperpage\";i:250;s:20:\"archive_postsperpage\";i:250;s:13:\"cpstylefolder\";s:18:\"vBulletin_3_Silver\";s:19:\"timeoutcontrolpanel\";i:0;s:15:\"adminquickstats\";i:0;s:18:\"cp_collapse_forums\";i:0;s:18:\"cp_usereditcolumns\";i:2;s:10:\"externaljs\";i:0;s:11:\"externalrss\";i:0;s:10:\"rsspodcast\";i:1;s:11:\"externalxml\";i:0;s:14:\"externalcutoff\";i:30;s:13:\"externalcache\";i:60;s:13:\"externalcount\";i:15;s:16:\"errorlogdatabase\";s:0:\"\";s:16:\"errorlogsecurity\";s:0:\"\";s:11:\"errorlogphp\";s:0:\"\";s:13:\"errorlogemail\";s:0:\"\";s:15:\"errorlogmaxsize\";i:1048576;s:17:\"disableerroremail\";i:0;s:11:\"enablehooks\";i:1;s:12:\"paymentemail\";s:23:\"jaxel@crookedjester.com\";s:15:\"vb_antispam_key\";s:0:\"\";s:17:\"vb_antispam_posts\";i:0;s:6:\"ipinfo\";i:60;s:13:\"ipinfo_groups\";s:5:\"5,6,7\";s:15:\"uac_notifyadmin\";i:1;s:8:\"gosterx1\";i:1;s:8:\"gosterx2\";i:0;s:8:\"gosterx3\";i:0;s:9:\"pemdata37\";s:900:\"a:3:{s:12:\"paulm_fci_37\";a:8:{s:9:\"productid\";s:12:\"paulm_fci_37\";s:5:\"title\";s:21:\"Flashchat Integration\";s:11:\"description\";s:42:\"Integration of Flashchat and vBulletin 3.7\";s:7:\"version\";s:7:\"3.7.005\";s:6:\"active\";s:1:\"1\";s:3:\"url\";s:0:\"\";s:15:\"versioncheckurl\";s:0:\"\";s:3:\"cvs\";s:4:\"3.15\";}s:12:\"paulm_wic_37\";a:8:{s:9:\"productid\";s:12:\"paulm_wic_37\";s:5:\"title\";s:31:\"Members who are using Flashchat\";s:11:\"description\";s:56:\"Display members who are currently chatting in Flashchat.\";s:7:\"version\";s:7:\"3.7.002\";s:6:\"active\";s:1:\"1\";s:3:\"url\";s:0:\"\";s:15:\"versioncheckurl\";s:0:\"\";s:3:\"cvs\";s:3:\"3.9\";}s:12:\"paulm_wvt_37\";a:8:{s:9:\"productid\";s:12:\"paulm_wvt_37\";s:5:\"title\";s:24:\"Members who have Visited\";s:11:\"description\";s:43:\"Display members who have visited the forum.\";s:7:\"version\";s:7:\"3.7.003\";s:6:\"active\";s:1:\"1\";s:3:\"url\";s:0:\"\";s:15:\"versioncheckurl\";s:0:\"\";s:3:\"cvs\";s:4:\"3.14\";}}\";s:7:\"wicmost\";i:1;s:6:\"wicall\";i:1;s:7:\"wicgrpz\";i:0;s:7:\"wicgrps\";s:1:\"0\";s:8:\"chatlang\";s:2:\"en\";s:6:\"wiccol\";i:0;s:10:\"chatfolder\";s:4:\"chat\";s:6:\"fcpath\";s:0:\"\";s:3:\"wic\";i:1;s:6:\"fcroom\";i:1;s:8:\"fcheight\";i:600;s:6:\"fclink\";i:2;s:10:\"enable_wic\";i:1;s:12:\"template_wic\";s:9:\"FORUMHOME\";s:8:\"text_wic\";s:28:\"<!-- end logged-in users -->\";s:5:\"wicao\";i:1;s:9:\"wicaogrps\";s:1:\"0\";s:22:\"wicao_forumhome_enable\";i:1;s:25:\"wicao_forumdisplay_enable\";i:1;s:23:\"wicao_showthread_enable\";i:0;s:24:\"wicao_whoisonline_enable\";i:1;s:20:\"wicao_profile_enable\";i:1;s:12:\"enable_wicao\";i:1;s:10:\"text_wicao\";s:7:\"$navbar\";s:22:\"automediaembed_disable\";i:0;s:20:\"automediaembed_limit\";i:50;s:22:\"automediaembed_resolve\";i:1;s:23:\"automediaembed_forumids\";s:0:\"\";s:25:\"automediaembed_usergroups\";s:0:\"\";s:19:\"automediaembed_open\";s:431:\"<div align=\"center\">\r\n<table class=\"tborder\" cellpadding=\"6\" cellspacing=\"1\" border=\"0\" width=\"400\" style=\"margin:10px 0\">\r\n<thead>\r\n <tr>\r\n <td class=\"thead\" colspan=\"2\" style=\"text-align:center\">\r\n <a href=\"$url\" title=\"$title\" target=\"_blank\">$title</a>\r\n </td>\r\n </tr>\r\n</thead>\r\n<tbody>\r\n <tr>\r\n <td class=\"panelsurround\" align=\"center\">\";s:20:\"automediaembed_close\";s:46:\"</td>\r\n </tr>\r\n</tbody>\r\n</table></div>\";s:26:\"ncode_imageresizer_enabled\";i:1;s:30:\"ncode_imageresizer_defaultmode\";s:8:\"floatbox\";s:30:\"ncode_imageresizer_warnbgcolor\";s:7:\"#FFFFE1\";s:31:\"ncode_imageresizer_warntxtcolor\";s:7:\"#000000\";s:34:\"ncode_imageresizer_warnbordercolor\";s:7:\"#CCCFFF\";s:32:\"ncode_imageresizer_hsoutlinetype\";s:13:\"rounded-black\";s:27:\"ncode_imageresizer_maxwidth\";i:500;s:28:\"ncode_imageresizer_maxheight\";i:0;s:35:\"ncode_imageresizer_resizesignatures\";i:0;s:31:\"ncode_imageresizer_maxwidthsigs\";i:0;s:32:\"ncode_imageresizer_maxheightsigs\";s:1:\"0\";s:35:\"ncode_imageresizer_sigsexcludgroups\";s:1:\"0\";s:25:\"ncode_imageresizer_albums\";s:1:\"1\";s:33:\"ncode_imageresizer_maxwidthalbums\";s:3:\"900\";s:34:\"ncode_imageresizer_maxheightalbums\";s:1:\"0\";s:26:\"ncode_imageresizer_attachs\";s:1:\"1\";s:38:\"ncode_imageresizer_resizebbcodeimglink\";s:1:\"1\";s:43:\"ncode_imageresizer_bbcodeimglink_killinsigs\";s:1:\"1\";s:30:\"ncode_imageresizer_useroptions\";s:4:\"none\";s:36:\"ncode_imageresizer_clearusersettings\";i:0;s:11:\"subfhome_on\";i:1;s:28:\"all_albums_default_sortfield\";s:15:\"lastpicturedate\";s:28:\"all_albums_default_sortorder\";s:4:\"desc\";s:27:\"all_albums_show_navbar_link\";i:1;s:27:\"all_albums_show_quick_links\";i:1;s:29:\"all_albums_shlow_navbits_link\";i:1;s:9:\"subucp_on\";i:1;s:12:\"subucp_nogrp\";s:1:\"6\";s:10:\"subexp_exp\";i:1;s:14:\"subexp_rct_exp\";i:0;s:8:\"subexp_1\";i:1;s:12:\"subexp_rct_1\";i:0;s:8:\"subexp_2\";i:1;s:12:\"subexp_rct_2\";i:0;s:8:\"subexp_7\";i:1;s:12:\"subexp_rct_7\";i:0;s:9:\"subexp_30\";i:1;s:13:\"subexp_rct_30\";i:0;s:10:\"subexp_lng\";i:1;s:14:\"subexp_rct_lng\";i:0;s:9:\"subexp_nn\";i:1;s:13:\"subexp_rct_nn\";i:0;s:13:\"subexp_rctnum\";i:5;s:14:\"subexp_rctdate\";i:0;s:12:\"tfseo_enable\";i:1;s:10:\"tfseo_type\";s:1:\"2\";s:14:\"tfseo_url_type\";s:1:\"1\";s:13:\"tfseo_rewrite\";i:7;s:9:\"tfseo_301\";i:7;s:10:\"tfseo_base\";s:22:\"http://www.8wayrun.com\";s:9:\"tfseo_chr\";s:1:\"0\";s:10:\"tfseo_page\";s:4:\"page\";s:11:\"tfseo_index\";i:0;s:12:\"tfseo_maxkey\";i:8;s:15:\"ae_ignore_users\";s:1:\"1\";s:13:\"ae_recipients\";s:5:\"Jaxel\";s:9:\"ae_sender\";i:1;s:9:\"ae_sendpm\";i:1;s:10:\"ae_forumid\";i:0;s:14:\"ae_startthread\";i:0;s:16:\"ae_ignore_groups\";s:5:\"5,6,7\";}', 1);

MySQL Error : Table 'datastore' was locked with a READ lock and can't be updated
Error Number : 1099
Request Date : Thursday, August 21st 2008 @ 10:54:28 PM
Error Date : Thursday, August 21st 2008 @ 10:54:30 PM
Script : http://www.8wayrun.com/admincp/cronadmin.php?do=runcron&cronid=19
Referrer : http://www.8wayrun.com/admincp/
IP Address : 68.197.175.128
Username : Jaxel
Classname : vB_Database
MySQL Version : 5.0.51a-community

[Jaxel]

text limit...

There were my settings:

<?php
/*
<!-- $Header: d:\cvs/3.7/Auto-backup/includes/mysqlbackupconfig.php,v 3.2 2008/01/06 15:32:44 pem Exp $ -->

Auto-Backup (Lite) for vBulletin 3.7 - Paul M - v 3.7.001
This lite version is adapted from the original 3.0 version by Trigunflame.
*/

// Combine all tables into one file
$backup['COMBINE'] = 1; // 0 = No, 1 = Yes

// Close Forum during Backup
$backup['SHUTDOWN'] = 1; // 0 = No, 1 = Yes
$backup['MESSAGE'] = "The forums are currently closed while the database is undergoing a routine backup process.";

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

// -----------------------------------------------------------------------------------------------//

// Backup Options
$backup['LOCK'] = 1; // 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

?>


I turned $backup['LOCK'] off, and then it worked. is there a reason why I cant lock?

[Jaxel]

NM... got it working.

[z0diac]

Nice, thanks.

i always forget to do them myself :D

I don't forget - me just tooo lazy :p

I'll grab this now.

[turbosatan]

ok so i have this working now. is there a way of automatically mailing the new db to myself each day after the backuphas completed?

i am sure i ahve read about using normal crons in cpanel to do this but i cant recall where and i dont seem to be able to find any info.

please let meknow if you can help and

Great Mod!! Thank Paul M

[blackwolf1962]

thank you i was getting a error but as soon as i got the correct path in config it worked fine thanks installed:D

[ogameclub]

Can be this hack zip file for backup?

[GeNeRaL NT]

thanks

[shlomot]

Dear Paul,

I set a second database on the forum for PhotoPost.

What would be the best technique to include this database in the auto-backup as well?

[Paul M]

You could not do that without editing the code.

[aciurczak]

Is the "combine" function working for folks? I've tried it like this:

// Combine all tables into one file
$backup['COMBINE'] = 1; // 0 = No, 1 = Yes

and I've tried it like this:

// Combine all tables into one file
$backup['COMBINE'] = 0; // 0 = No, 1 = Yes

and either way it creates 1 file per table in the backups directory. Haven't figured out which way I want to go yet, but it seems like I don't have a choice if the combine isn't working for me anyway.

[aciurczak]

Sorry, my bad. Seems like it was working to combine. I just hadn't refreshed the directory on the FTP program I was using.

[AryanMetha]

hi mate... good mod.. but it didn't worked for me, when the tables were unlock..
i set the tables = 1[lock]. then it worked like a charm... i think the same thing is happening with others..
for your info i've installed the mod on vBulletin 3.7.3. thanx

[MCAlexandre]

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

Great mod, but I have the quoted error. What do do? I CHMODed do 777 and nothing. :(

[Vinyljunky]

Great mod, but I have the quoted error. What do do? I CHMODed do 777 and nothing. :(

Are you sure that your path is correct?

[MCAlexandre]

Are you sure that your path is correct?
Yes, sure. Want me to try without the "./" or just the "." in the beggining of the path?

[Paul M]

It might help to post what path you have actually set. :)

[MCAlexandre]

It might help to post what path you have actually set. :)
x_x'

I tried those up there, but now I have this path: "includes/cron/cronbackup.php"

[Mr. Hoddz]

So I use this to backup a table, and then import that into phpmyadmin if I make a new database? Would that work?

Not clicked install yet as I'm asking before =D

[Paul M]

x_x'

I tried those up there, but now I have this path: "includes/cron/cronbackup.php"

Umm, I mean your backup path.

[MCAlexandre]

Umm, I mean your backup path.
That's... I don't know how to set it. Please tell me and I'll see if the errors continues showing up. Sorry for being a noob.

[Paul M]

Its set in the mods config file, with all the other options that come with the mod.

[ntrance]

Had a few issues with the install then managed to get it working using the relative path.
It wouldn't work inside the public_html folder. It works one dir above nicely ! i.e ROOT

Excellent mod !

Al

[aciurczak]

Are there step-by-step instructions somewhere about how to restore a vB database using a backup made with this mod? I'm assuming it's something like: load the txt file back up to the server to an area where phpmysql can see it, and point phpmysql to the file to rebuild the DB. But if someone could put together a list of:

- here's what you do (including actual sql commands) to restore the db if it all of the tables in one large combined file
- here's what you do to restore the db if the backup is in individual files by table

it might help folks out and make the overall use of this mod a bit more clear.

[Paul M]

If someone has the time to write one, they are free to do so, Im afraid I dont. :)

[woostar]

At the moment I have a cron setup to do backups, but this causes a 1 - 2 minute lag. Does this use a sleep function to resolve resource hogging on larger databases?

[PHILIPS-08]

thanx for the work mate good mod