*uninstalled*

-fixed- ^^

I edit "mysqlbackupconfig.php" - to:
and i change "CHMOD" to "backups" folder to "0777" - and i still get this error:
help please,
yonatan :)

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?

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.

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

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

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

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

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

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,

Check inside the folders.

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

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.

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

I was check.
the folders is empty :(

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

In public_html


- - - - - - - - -

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

Thank you very much - works GREAT...

I try to backup(manually) in Safe Mod, and i get this error:
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

Nothing, dont use safe mode.

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

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.

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.

Sorry, I cant solve indivdual server configuration problems.

Installed and worked the first time! Awesome!!

~ Sean

uninstalled

Why? Did you run into any issues?

~ Sean

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.

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?

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.

Sorry, I cannot comment on database sizes.

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

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

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.

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

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.

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

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.