x_x'

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

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

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.

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

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

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.

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

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?

thanx for the work mate good mod

Hey everyone. I've been using this Mod for a while now and haven't had a single issue until now. This last week or so I get this error message now when it runs and it causes my forum to be shut off until I go in and turn it off and on again. I haven't changed anything so I'm not sure what the problem is and why this just started happening.

Database error in vBulletin 3.7.0:

Invalid SQL:
SHOW CREATE TABLE `postedithistory`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, September 15th 2008 @ 04:01:51 PM
Error Date : Monday, September 15th 2008 @ 04:02:02 PM
Script : http://www.extremebodybuilding.net/f...cron&cronid=35
Referrer : http://www.extremebodybuilding.net/f....php?do=modify

Perhaps you have a low mysql timeout value.

I'm on a shared server so I don't get to mess wtih any of those settings (at least I don't think). It's weird cause I haven't had an issue with this mod, even when I used the old one on 3.6.x

My site is pretty small so the backup usually completes really fast. Like 5,000 threads, 50,000 posts, and 3000 members

Stupid question but I want this mod to do backups just like vbulletin does. So I would set combine all tables to one file to yes right?

If thats what vb does then yes.

Got it working, thanks.

I've had a couple of occasions where the board did not get reopened after the backup.

i want it back up to ftp

where can i find that

finally i got it working .i was having this erorr : An error occured during the Backup : Could not open Destination SQL file for writing. even i gave my backup folder 777 and also providing the correct path . i have found that the problem was i changed

"Y-m-d"
in to
2008-10-01
Do not Change "Y-m-d" until u get it working for ya

that's why it was showing me this erorr
An error occured during the Backup : Could not open Destination SQL file for writing

Strange . So may be few guyz having this problem due to this edit "Y-m-d".

Installed Now. one thing if any one could tell me how to compress the backup in to zip or gzip ? thanks

Would be great if you can add this feature please. Thanks.

Do not change that at all unless you understand what you are doing. Its a generic date format, not something you set to specific dates.

You cant, at least not with this mod.

Sorry, nothing new will be added to this.

one thing i want to ask its making new folders every time it runs so how can overwrite on the same backup ?

i dont know how to set the settings :(

i want a daily backup settings

You could do what I do and change the time format to this ;

This creates a folder for each day (i.e. Monday, Tuesday etc) and they get overwritten each week.

It runs daily by default.

dose it run daily at 4 every day then and can u make it run you're self to test it ??

You can run any vb cron via the schedules area of the ACP.

Ok I am completely new at this and do not know code at all. I know from reading these post that this is nothing new to you. However if you will humor my ignorance and give me some suggestions as to how to make this mod work it would be greatly appreciated. I set the path to:

// 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'] = '/home/www.mywebsite.com/backups/'; // Path to backups folder, must have a trailing slash

This is the best I could interpret it from this thread. I loaded the includes folder into the home directory. When I ran the task I get an error message that reads this:


Automatic Database Backup for vBulletin 3.7

Warning: include_once([path]/./includes/cron/cronbackup.php) [function.include-once]: failed to open stream: No such file or directory in [path]/admincp/cronadmin.php on line 113

Warning: include_once() [function.include]: Failed opening '[path]/./includes/cron/cronbackup.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/admincp/cronadmin.php on line 113

Can one of you please tell me what I need to do to correct this situation to make this work?:confused:

Thank you in advance:)
Suenee

That is basically saying that the file cronbackup.php is not uploaded (to the correct place ?).

that I can fix can you tell me which file it should be in?

awsome worked a charm :)

great hack thx

I downloaded this and it was Y-M-d in the config, just an fyi.

thanks

but i have this error

what can i do ?

It is mentioned a bunch of times in this thread that this means either the path you put in config file is not being found, has not got write (777) permission or theres a permission issue at the server/host end. I set this up for a test run on my system and got that error many times, it was finally solved by using absolute path to the backup folder instead of relative as was suggested previously. It is working now and I think I'm probably going to keep it :)

thanks seax19

i did this

have got write (777) permission to folder backups in my www

this folder on

/home/myuser/public_html/backups/


but nothing happen

the error still appear

i change it to

mysite/backups/

but the error still appear too ..

Thank you Paul, yet another A+ modification.

i installed this and gave the directory permissions. Everything works fine.. it even shows "The Backup was completed successfully", but when the backup is completed and i browse to the backup directory. I find nothing inside it. Can you tell me where i am going wrong ??

im having a problem with it not running automatically, unless i missed a setting somewhere to set how often it backs up, but according to the cron script it should be every day.

I installed as shown here but I have no idea about where the output will be? and how will we restore when the forum crashes?

thank you.

This mod ROCKS! :D

Another clutch mod by Paul. Thanks!