Yep. Working now and backing up a full 400 megs.

thx Paul good idee
but i have somthing not right

i make evry thing
and its wreit empty folder
nothing on it
i see the folder 2007-08-31
but its empty
can u help me pls
thx

I set backup schedule task time AM:6.
But backup time is not correct when it's run PM:1 or PM:8 etc...
How can I fix?
Please help...

Thanks. :)

Either it didn't run or you have a folder/files writing permissions error, most likely the second.

If you are having trouble with cron jobs then you need to ask on vbulletin.com as that's a standard part of vbulletin.

Thanks, Paul.

I'm running mysql 5, should I set this to 0

$backup['MYSQL4'] = 1; // Set to 1 if you are using MySQL4

Also, to make just one dump and not one for each table, should I set this to 1

$backup['COMBINE'] = 0;

And will this delete old backups?

edit-
I just tested it with combine both on and off and figured it out.

Also I read about the mysql option being for mysql 4 and up, so I leave it as 1? Or would 0 or other value be better for Mysql 5?

Thanks for this mod, I had it on vb 3.0 and it didn't work for ages. I still had the scheduled task there, and the files. And I think the task was enabled.

Set it to 1 on mysql4 and above.

Nothing in this mod deletes old backups, unless you run two backups on the same day.

Ok thank you.

Although, as others have mentioned, that would be an excellent addition to this add-on... deleting old backups after the new one is created or after a certain length of time (e.g., keep only the last 3 days or 7 days).

Is there a way to divide the backup job into several jobs, each one of those jobs backs up certain tables of the database?

I am not able to backup a large database because of large tables.

This is the out of memory message I get

Creating gzip file from SQL file

Fatal error: Out of memory (allocated 5242880) (tried to allocate 206317869 bytes) in /home/xxxxx/public_html/includes/mysqlbackup.php on line 534

Forgot to add, I had the memory limit set to 500mb and it did this
so I don't know what to do

Hi

Is there a way to have the script make 2 backups each day?
How would I do that?

I have lost 2 days of my forum a while back because the backup was done a short while after my database got corrupt.
To prevent that I really would like to have 2 Backups each day.

Any chance for that?

Thanks in advance

StarBuG

Can someone tell me why I keep getting that out of memory message?
I still can't do regular backups because of it

Fatal error: Out of memory (allocated 5242880) (tried to allocate 208268833 bytes) in

No idea, there is no gzip facility in this modification.

AFAIK, you cannot run one vb cron job just twice a day - you would need to create a second cron job to run at the hour you want.

You also need to change the config file to include the hour in the file name, otherwise one backup will overwrite the other.

I know that, but how do I add the hour into the filename in the config?
I am not a php programmer ;)

Edit the backup date config line ;

The format of the letters is here.

This adds the time to the folder as well

I rather would like to have the time added to the filename only so that I have one folder per day with X numbers of backups inside it.
How would I go for that?

You cannot, there is no seperate setting for that.

But wouldn't that be possible by editing the mysqlbackup.php file?
The name is generated there, isn't it?
I don't mind having it hardcoded and not as a config setting.

Whoohoo!!! i got it. lol.

where do you guys recomend that i put the backup file?

should i put it in a file at the same level (pardon my teminology) as the public_html file?
in the public_html file?
in a folder in the public_html file?

where would it be most secure?

i even added revens bit of code to get it in a zip file. :cool:
thanks paul, thanks reven :)
i would love to add revens coding to save it on an outside ftp, if i could get some help figuring out the filepaths. i read through this mod atleast three times but all the different filepath discriptions has got me all scared. :( lol

Always save backups outside of the public_html, you don't want people to be able to access them.

gotcha ;) you da man
i thought i had marked this mod installed ... but i didnt. got it now. :) thanks again

i went back a couple of pages to see if this was addressed but we run under windows server 2003 and apache/php. When I point the directory to the C: drive it backs up fine but we have a share drive that is run by our hosting company which we currently use to do backups since its off the server completly. But there is a permission issue writing the file there (it gives a permission error). im guessing apache/php has a user account which needs access but have no idea what it is.... was wondering if anybody could help.

and the section question.... what we really want is a single file that is created and it is overwritten every night. Is there anyway to have a single file that just gets overwritten or updated every night? (IE if i take out the date part would that do it).

I would imagine that if you did a default install of apache on W2000 then it's running under the system account so will not be able to access shared drives - you would need to create a dedicated user account, change the service to use that account, and go from there.

yesterday my database Was CRASHED !! Thanks this mod that i had a backup :)

thanks again Paul M

woOT. Test backup worked flawlessly. Hopefully we'll see tonight a fresh backup.
I think that many of these problems are based on a bad path if one is trying to place the backup folder outside of public_html.

@Paul

Can you please help me with the filename.
I really need multiple backups but I don't want each backup in its own folder instead I would like to have one folder per day containing multiple backup files.

Help would greatly be appreciated.

Thanks

StarBuG

This doesn't seem to do anything. I went to scheduled tasks to manually run the job, and it just cleared the box and said "Database Backup" at the top.

I shelled in and went to the location I selected it to store at... no file.

Oops, ok, it seems you can't get out of your forum root directory. I select /dir2 which is from my hard drive root, and it put it in my forum root (my forum is still a few subdirs deep below dir2).

Sorry, but I just don't do customised versions of any of my mods (unless you want to pay for my time of course) - it simply would not be practical, as so many people want little things changing here and there. It's enough to just keep up with supporting them as they are.

In the case of this mod, any changes would also take a little longer as I didn't write the original code, so I have to familiarise myself with how it works.

Hi there. Thanks for this useful tool. I have one inpt question on the permissions for the folder that this is writing the back up to, in terms of read and write and execute etc.

There are settings for owner, groups, public etc. What is the best way to lock this down so that the system can run the cron job successfully but also so that we can keep other's eyes out of there?

Also can you perhaps give us a screen shot that will show us a typical cron set up for a once a day or once a week backup?

thanks a lot :)

Hi Paul M,
I used :
We I try to run in from the ACP cron, I get this message:
What's a problem ?

thanks,,

That suggests that cronbackup.php is not in the includes/cron/ folder.

What does this mean?

XML Error: not well-formed (invalid token) at Line 2

Uhmm nvm mate my bad... i imported txt file instead xml.... sorry addon works great thanks allot for it!

PS. getting this error when backuping:

Database Backup
An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

That means you don't have permission to create the backup file. You need to sort out your write permissions.

Great tool. Thanks so much. :)

I upgraded to PHP 5.2.5 yesterday, and the forum didn't re-open after the backup last night. Any idea why that might happen?

Nope, no idea at all.

Thanks Paul. Hopefully it was just a fluke.