vB Database Backup (Lite)

[Paul M]

Not much a can say to that :)

[Joe2288]

I'm also getting the error

An error occured during the Backup :

My backup path is ././backups/ and it does create folders with the current date when I manually start the process but nothing else.

Any ideas?

[Paul M]

././backups/ should really be ./backups/

You need to check folder permissions.

[Joe2288]

I have folder permission set at 777 and as I mentioned it does create subfolders with the current date so I think the permission is set correctly.

I changed the path to ./backups/ still the same error.

[Joe2288]

Ok, I checked a little further into this problem. It does have something to do with permissions.
Folder /backups/ permission is 0777 owner me
Folder /backups/2009-09-17 permission 0777 owner www-data ... does this matter?

So I went on and edited mysqlbackup.php in order to remove the creation of folder as this is somehow creating the problem for me ....

// Cron Based Automated Backup
function cronBackup()
{
/*
Set Full Dump Path.
*/
//$this->FULL_PATH = $this->DUMP_PATH.$this->DATE.'/'.$this->PREFIX.$this->DATE;
$this->FULL_PATH = $this->DUMP_PATH.'/'.$this->PREFIX.$this->DATE;

/* Short Path */

//$this->SHORT_PATH = $this->DUMP_PATH.$this->DATE;
$this->SHORT_PATH = $this->DUMP_PATH;

/*
Close Forum.
*/
if ($this->SHUTDOWN) { $this->forumStatus(0); }

/*
Remove previous SQL Files.
*/
//$this->removeDir($this->SHORT_PATH);
//$this->createDir($this->SHORT_PATH);

/* Clear Cache */
clearstatcache();
..............
............

I no longer have dated folders, but it is working now.

[Allan]

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

i have added two options :

IF you choose to "COMBINE FILES" Then:-

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

Installation :

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

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

[ChopSuey]

Tried everything, read all posts, getting an error.

[need2fart]

When I try it, it backs up everything but when it gets to my posts it just stops and says done?

Processing podcastitem (No Data)
Processing poll (218) : Processed 218 Rows in 0.016 seconds
Processing pollvote (8249) : Processed 8249 Rows in 0.327 seconds
Processing post (136557)

Thats all I see and it says done... I don't think it is right tho because it didn't say the time processed.

Can someone help me with this I think it timed out. =(

[ChopSuey]

How did you get it to work? Whats your path for it?

[Paul M]

Thats all I see and it says done... I don't think it is right tho because it didn't say the time processed.

Can someone help me with this I think it timed out. =(
That certainly looks like it failed, and timeout is the most likely reason.

[ChopSuey]

Well i can't get it to work, set path to ././backups it fails after.

[MagicThemeParks]

Just changed servers and the file path has to be changed. Where do I make the adjustment for that?

[ChopSuey]

Should be in your vBulletin options..

[MagicThemeParks]

I must be looking in the wrong place. Where in the vBulletin options should I look?

[need2fart]

That certainly looks like it failed, and timeout is the most likely reason.

Dear Paul M, do you know how I can fix the timeout error?

[Log on]

thank u

[Paul M]

Dear Paul M, do you know how I can fix the timeout error?Speak to your host, I cant help with individual server set-ups im afraid.

[need2fart]

Speak to your host, I cant help with individual server set-ups im afraid.

Wow thank you Paul M! I talked to them and they assisted me to use cpanel cron jobs haha, now no more timeout errors! They said it timed out because of the 30second limit in PHP. Now with cron job though cpanel, no more timeouts!

Thank you for all the help and advice,
and the lovely product,

- Kyle

[Cybershaolin]

I now also have timeouts problem with only 203 tables. It's strange because it worked before but not anymore? It just started recently to give me problems without completing the backup fully, missing the last tables in the database. What exactly do I have to look into my php.ini values in order to find out about the timeout value? What is a good value for timeout? Is there a setting we can adjust in the hack files about timeouts?

[Paul M]

The modification sets the timeout to 3600 (ie 1 hour). However, I believe this may be overridden by any "max_execution_time" setting in your php.ini file. The modification will most likely also timeout in safe mode.

[Cybershaolin]

I looked in the php.ini file and the max_execution_time value is set to 50000 in both local and master value. I guess this is not the problem then. Very weird.

[ChopSuey]

Tried everything, read all posts, getting an error.

Still no answer? Marked as installed and Nominated. Still dont work for me

[Paul M]

You have not supplied any useful information - just simply said it doesnt work.

You must give details of what does or does not happen, error messages etc.

However, please note that I cannot answer questions on individual server set-ups. If you have a permissions error then you need to sort that out yourself, or speak to your host.

[Alucard^]

Hi,

I have a question, sorry if this is answered but I didn't see nothing about that in the first page.

This plugin make a backup, good, but if I did it a backup (without this plugin) and I want to upload this backup, I can use this for that? or this is only to make backups?

Thanks and sry if I writed something wrong, my english isn't perfect.

[Paul M]

This is only to make backups, not restore them.

[euantor]

Great mod :) Backs up my forums perfectly.

[ChopSuey]

I fixed it, had to fix some of the files and do the config.php file with my own stuff

[Log on]

great

thank u

[ForumUser210]

Perfect!

Thank You!

[DontWannaName]

Worked for me but if we backup everyday to be safe, and it does this for a long time, it will take up a lot of space. How can we delete old backups every month?

[ForumUser210]

Worked for me but if we backup everyday to be safe, and it does this for a long time, it will take up a lot of space. How can we delete old backups every month?

I download my daily backup, and delete it right after I download.

In my experience, I figure I don't need more than one backup, so there is no reason to have a list of them piling up.

[ForumUser210]

Hi,

I have a question, sorry if this is answered but I didn't see nothing about that in the first page.

This plugin make a backup, good, but if I did it a backup (without this plugin) and I want to upload this backup, I can use this for that? or this is only to make backups?

Thanks and sry if I writed something wrong, my english isn't perfect.

To restore a backup, use BigDump:

http://www.ozerov.de/bigdump.php

[control1110]

I have a few questions,

1) I am assuming no but im going to ask to make sure, Can you compress in gzip format?

2) I set my to backup every hour with date format Y-m-d-G but it creates another folder for each backup not really a big detail but I would prefer one folder for each day. Any possible way to do this?

3) Is there a way to automatically delete backups more than a week old?

4) For the exclude list for tables can you use wildcards like prefix_*?

Thanks

[Paul M]

Hi,

1. No, tho I think someone posted some code to do this somewhere in the thread.

2. I use the format "l" (lowercase L) - this simply sets it to the day of the week, so you always have just 7 folders.

3. See 2.

4. Nope.

[gerbil249]

XML Error: syntax error at Line 3

[BlackJacket]

Paul i have this installed on my VB3 board but wanted to know if it would work with VB4 and if not, would you be able to make a version for VB4?

Thanks Paul! :)

[control1110]

Hi,

1. No, tho I think someone posted some code to do this somewhere in the thread.


Did search and just read through the entire thread no one has posted any code on how to gzip, or I just missed it, if someone finds it please like me know

[Paul M]

Paul i have this installed on my VB3 board but wanted to know if it would work with VB4 and if not, would you be able to make a version for VB4?

Thanks Paul! :)

I have no idea if it works with vb4 atm.

I suspect it probably will, since it doesnt rely on any templates or hooks.

I also expect there will be a vb4 version, when I have the time to look into it.

[BlackJacket]

I have no idea if it works with vb4 atm.

I suspect it probably will, since it doesnt rely on any templates or hooks.

I also expect there will be a vb4 version, when I have the time to look into it.

I tried it in VB4 and it did not work. This is the error message "An error occurred during backup"


I have installed this mod on two other boards so the setup was correct. I rechecked the directory and file permissions just to make sure which still did not work.

Thanks Paul. :)

[JVSP]

Working fine in 4.0 just tested it. Had to remove minversion and maxversion in the xml to install.

[GreenKman]

I can't seem to get this to work. When I click 'Run Now' I don't get an error code, I just get the following message:
Automatic Database Backup for vBulletin

An error occured during the Backup :

I'm not sure what's wrong. Do you think you can help?
Thanks in advanced. :D

[Paul M]

That message doesnt really help. 99% of problems are write permission errors on the folder.

[ChopSuey]

You need to set the path correctly
/home/user/backups/
Thats how i have mine set, i get backups everyday.
Works great. MAKE SURE its in the same place as public_html
Needs to be CHMODDED to 777.

[GreenKman]

You need to set the path correctly
/home/user/backups/
Thats how i have mine set, i get backups everyday.
Works great. MAKE SURE its in the same place as public_html
Needs to be CHMODDED to 777.
That did it! I had the directory wrong. Thanks a ton! This is a GREAT mod.

[Forumi Shqiptar]

Does it affect larger vbulletin boards? As i have to back mine up using shell as PHP and MYSQL keeps breaking the connection because of a larger information that my board holds and also photos too.

Waiting for a reply and many thanks in advance.

[Paul M]

Define "Larger".

[SilabGarza]

eh took 45 seconds for mine to make a backup, giant forum (in my opinion) still trying to figure out the way it saves lol

[SilabGarza]

it does all this loading and stuff when i click run now, but i can't find the location it saved it if it did....

heres wat i have in the vb option part

Backups Path
./recover/backups

[billb]

marked as Installed
many thanks Paul

[SilabGarza]

wats the directory it automaticly saves to..?
cuz i can't figure out wat the path is suppose to be..

[armthehomeless1]

Please support vB 4.0 :D

[McCarroll21]

Please support vB 4.0 :D
This works in vB 4. You have to go into the product XML file and remove the minversion and maxversion fields.

Change lines 10-12 in the XML file from this:
<dependencies>
<dependency dependencytype="vbulletin" minversion="3.8.0" maxversion="3.8.99" />
</dependencies>

to this:
<dependencies>
<dependency dependencytype="vbulletin" />
</dependencies>

After doing that, you should be able to import it just fine.

[cheat-master30]

Great work, so installed. Seems to work fine, the only long part is actually downloading the backup from the server my site is actually on.

[ayman1204]

thanks man
Installed

[itznfb]

So, if my forum is hosed and I can't access the forum main page or admin portal how can I restore the database directly?

[bleros]

bro look i create folder backups but why when i run manual from Scheduled Tasks one folder is created with backups2009 and date and the backups continues but is stoped with error in my admicp internal server error

see pic
http://img710.imageshack.us/img710/1308/80315426.png

[bleros]

Paul this thread is Supported i think . maybe u can edit thread and make it Unsupported thanks

[Paul M]

Nope, Im not editing it.

However, I do not support server level errors (for example permissions).

In this case I dont understand what your actual problem is.

[Mecho]

in last few days , it wont finish the backup . so forum would be closed until i came online and run it via Cpanel !

Any idea what should i check and fix ?

Thanks

p.s. i have my own dedi

[Paul M]

Run it manually and see what happens.

As for the closed option - turn that off - its not always reliable, and has been removed in the 4.0 version.

[flashwave]

Empty backup file...

I already read through the whole thread to get this Mod running on my forum, before asking.

When run manually:

Automatic Database Backup for vBulletin
An error occured during the Backup :

It's neither a backup folder path problem nor a write permission problem, since the [date] folder is created and the backup file inside is created as well. The backup file is empty, however (size= 1 byte).


My vb version is 3.8.4 PL2

Any help would be much appreciated. :)

[Paul M]

I have no idea - there is no error message which is strange in itself. Without admin/ftp access there is nothing I can tell you.

[bleros]

Ok Paul i change server now is work fine, but i not create folder the folder created his /home/user
is thir correct?

[Paul M]

Sorry, Im not sure what your asking. The folder can be any name you want.

[yoyoman]

Installed and marked!
Thanks for the MOD!

[samiro]

what about upgrading to vb4 ?

[yoyoman]

thanks and all workin now....hope so....having error using this ../../backups/

instead use this ././backups/ now its all okay...

will see how it work auto tommorrow...one thing is this going to have only 1 fresh backup daily? not the old way to have the daily back up files?...so everytime it backup our database...it gonna change the old one with the fresh and latest one?
if it is...great and better than before..


i'm not getting this...

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


million thanks Paul M

;)

Thanks a lot! Fixed my problem!
Guys, if you get the "An error occured during the Backup:" message and no error description whatsoever, them try changing ../../backups/ to ././backups/

Paul I think you should definitely add this to the description.
Thanks for the hack!

[Paul M]

The path is entirely down to your server and personal set-up, I cannot add that to the description.

You should note that ././backups/ is the same as ./backups/ and means the backup folder is within your publicly available website - which means anyone can potentially access your backups.

[slowphantom]

i got error after i used :v3.8.002 : Moved most of options to ACP.

Fatal error: Maximum execution time of 30 seconds exceeded
in includes/mysqlbackup.php on line 468
and some time on line 474
i never had error with the old one

any help pls

Thank you

[Paul M]

That is a server issue, your php is set to a 30 second limit.

[slowphantom]

Thanks Paul for answering
i change it on my php.ini to 120 sec and i got
Database error

Invalid SQL:
SHOW CREATE TABLE `postlog

but on the v3.8.001 : First version for vB 3.8. i never had error
and the execution time was 30 sec too

[Paul M]

Please post the full sql error message.

[slowphantom]

hello paul
here is it
Database error in vBulletin 3.8.4:

Invalid SQL:
SHOW CREATE TABLE `postlog`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, February 7th 2010 @ 07:35:55 AM
Error Date : Sunday, February 7th 2010 @ 07:38:55 AM
Script : http://www.mawane.com/vb/XxxX/cronadmin.php?do=runcron&cronid=82
Referrer : http://www.mawane.com/vb/XxxX/index.php?loc=plugin.php%3Fdo%3Dproduct
IP Address : XxxX
Username : XxxX
Classname : vB_Database
MySQL Version :

Thank You

[slowphantom]

Thank you paul
its working now

after i change the search option to full text search

so it seem that it cant backup when the the forum use the database serach option

[Paul M]

That error means your mysql connection timed out - you probably have a very low timeout value.

[slowphantom]

heu paul
Thank you again
do u mean
mysql.connect_timeout ?
cz i have it -1 means no limit

[Paul M]

No, mysql wait_timeout.

[slowphantom]

oh i dont think this is in php.ini
i think its the host thing

Thanks for replaying paul

have a nice day

[SilabGarza]

how do i make it so only i can access my backup?

[Paul M]

Store them in a place only you can access.

[SilabGarza]

for example?

like right now i have the folder set to 777, which means anyone can access it........ >.> that doesn't seem safe to me
how do i make it so only some1 with the password can access it? (or shuld i just make it into a random directory like....

public_html/alkjal3oo3dDDDie3/backups/
?

[Paul M]

No, you use a directory outside of public_html.

[SilabGarza]

how would i do that?

right now i have it set to this
./backups/

hmmm?

[SilabGarza]

still waiting? would the directory be something like....

home/silabgar(my host name)/backups
???

[Paul M]

I cannot generally answer server specific questions. Normally you would create a backups folder in the same location that your public_html is located, and reference it by ../../backups (which is the default setting).

[SilabGarza]

No, you use a directory outside of public_html.
u said that, how would i do that

[Blue91]

Paul,

I installed this. I have a backups folder in the same level as my public folder (in which my forums reside). It has correct write permissions.

I tried running this and get : An error occured during the Backup :

It has no actual error message and I made no changes to anything in your files.

Can you provide any help?

*edit* - fixed per post 318.

Regards,

[melbo]

From a restore standpoint, is it better to backup with your default separate tables or lump them into one? I've only restored with a xxxxx.sql.gz previously and was wondering what was the better way when using your method? I do have to untick 'extended inserts' when backing up manually and restoring via 'bigdump'.

Does this backup include extended inserts?

[Paul M]

No, this does not use extended inserts.

Personally I prefer to backup one file per table, so that if I need to restore one table I can do it easily.

If I need to restore them all then its easy enough to combine them all into one file first.

[melbo]

Excellent. Thanks a lot

[silentdub]

I installed it, I did not modify the config files.

I created a backups directory under the /public_html
I set the permissions to 777

When I click "Run Now" I get the following error:

I set the permissions to 777

Automatic Database Backup for vBulletin

An error occured during the Backup :

I changed the path to ././backups/ as defined in a previous post and still get the same error.

I do have the backups directory right under public_html Do I need to specify the entire path?

I know I am screwing something up, not sure what though.

[Paul M]

The path would depend on what path your forum is - but on a typical setup, from the info you have given, I would suggest you try ../backups/

[silentdub]

The path would depend on what path your forum is - but on a typical setup, from the info you have given, I would suggest you try ../backups/

Thanks, the forum is located under /public_html/forums

So should I create the directory under forums or public_html?

[silentdub]

Thanks, the forum is located under /public_html/forums

So should I create the directory under forums or public_html?


Thanks man, I got it working.

the backups directory needs to be under the forums directory when you use the ../backups/

Thanks again!

[MonkYZ]

Great mod ! Btw, how can i set it up so it doesn't keep anything but last 3 backups or so ? The database is really big and if i forget about backups, it takes too much space :) Thx in advance !

[romeo12]

Using the vB default "database backup" causes error frequently. Does this hack also ends up in error or this is safe to use?

[MonkYZ]

Great mod ! Btw, how can i set it up so it doesn't keep anything but last 3 backups or so ? The database is really big and if i forget about backups, it takes too much space :) Thx in advance !
We really need a way to change how many backups to be kept on server. I just got my drive full... and when i checked, it was filled with sql files made by vB Database Backup... Please, can you find a way for this ?

[Paul M]

This has already been posted before - but you can change the backup date options to limit the number of files - for instance I use a lowercase L, which means they are called Monday, Tuesday etc, so you only ever have 7 files - after that they overwrite each other. You can use other options (such as the day of the month).

[MonkYZ]

This has already been posted before - but you can change the backup date options to limit the number of files - for instance I use a lowercase L, which means they are called Monday, Tuesday etc, so you only ever have 7 files - after that they overwrite each other. You can use other options (such as the day of the month).
I don't understand what you mean. If i go in my Scheduled Task Manager and look for Automatic Database Backup for vBulletin i can only set what day of the week, day of the month and hour i want to backup. I don't understand how can i limit the number of files (what lowercase L means ? where do i find that ?)...

[Simon Lloyd]

This has already been posted before - but you can change the backup date options to limit the number of files - for instance I use a lowercase L, which means they are called Monday, Tuesday etc, so you only ever have 7 files - after that they overwrite each other. You can use other options (such as the day of the month).Paul, i'm also interested in doing this, i have my cron job set to every sunday, how do i get it to overwrite the previous weeks entry?

[Paul M]

I don't understand what you mean. If i go in my Scheduled Task Manager and look for Automatic Database Backup for vBulletin i can only set what day of the week, day of the month and hour i want to backup. I don't understand how can i limit the number of files (what lowercase L means ? where do i find that ?)...

vBulletin Options > vBulletin Automatic Backup > Date Format

(Setting for Backup file date format ).

Paul, i'm also interested in doing this, i have my cron job set to every sunday, how do i get it to overwrite the previous weeks entry?
As above - if the generated filename is/are the same, it will simply replace the existing file(s).

[Simon Lloyd]

vBulletin Options > vBulletin Automatic Backup > Date Format

(Setting for Backup file date format ).


As above - if the generated filename is/are the same, it will simply replace the existing file(s).Hi paul, i currently use this mod and it's already saved me a nightmare!, however i wanted the back-up performed every Sunday, you kindly gave the solution of using a lowercase L, i do now get a backup every sunday but it's a single file where the ones before gave me a dated folder with each component backed up separately, how do i get back to having each element backed up as before but just on a sunday?

[Zylantex]

Great add-on. Thanks OP.

[Paul M]

Hi paul, i currently use this mod and it's already saved me a nightmare!, however i wanted the back-up performed every Sunday, you kindly gave the solution of using a lowercase L, i do now get a backup every sunday but it's a single file where the ones before gave me a dated folder with each component backed up separately, how do i get back to having each element backed up as before but just on a sunday?

Just set the vb cron job to run once a week (on Sunday) using the standard date format.

[GoTTi]

getting this error:

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

[Zylantex]

Suggestion:

Daily backups are great but unless I download the backups and delete them promptly they eat up my disk space allowance on my host. The ability to do a backup on multiple selected days of the week would be really useful. It would let users back up weekly or twice a week, say Monday and Thursday, or any other combination of days that suits.

At the moment the only alternative to daily seems to be monthly and thats a bit risky imho.

[melbo]

Thanks for the update with gzip. I also just set my date code to 'l'. I used to go in weekly and delete all but 2 backups and now I don't have to anymore. Truly automatic! It does take up ~ 2.5 GB buts that's a small price to pay

[Simon Lloyd]

Paul, i love this mod and couldn't live without it now but i do experience a small problem more often than not, when using the option to close forum during back up i'll find that i sign on the next day and find that the forums are still closed, i then have to turn off your mod, CLOSE the forums in vboptions (yes i know its already closed) then open the forum again and reinstate your mod, any idea what could be causing the lock up, is there some way of adding an extra check to see if the back up activity has stopped then make the forum closed status time out?

Right now i leave the option off but it could spell disaster eventually as my database is over 2gb.

[Paul M]

That option has always had issues, and as I didnt write it, ive never had the time to look into why.

I suggest you simply dont use it (I dont). It was removed from the 4.0 version.

You can always use the lock tables option, but only do it at a very quiet period as visitors will experince the forum hanging while you do, and eventually you will start to get "too many connections" errors as the mysql process queue backs up waiting for write access.

[Simon Lloyd]

Thanks for coming back to me, i've also turned off the lock tables too now as i don't want to get a barrage of database error emails :)

[snowlion]

Hi Paul,
How do I make folder for combine SQL file? Cause I want to seperate everyday's backup file.
It worked with 3.8.002 but it didn't work with 3.8.004

[Paul M]

You cannot, that was always a bug, and got fixed as part of 3.8.004.

[snowlion]

You cannot, that was always a bug, and got fixed as part of 3.8.004.
Ok, Thanks :D

[slowphantom]

hey Paul

Thanks for keeping it up realy great work
and i have question pls

You cannot, that was always a bug, and got fixed as part of 3.8.004

that mean the new update will replace the backup every day ?

what about if some one hack it or somthing go s wrong and it will be be4 back up
so the backup will take the bad one and replace it with the one from the day be4 ?

[Paul M]

that mean the new update will replace the backup every day ?
No.

[slowphantom]

ok Paul
Thank you

u still my best developer :)
keep it up

[Phaedrus]

Wow... GZip. Thanks dude! That is quite an improvement.

[SorentoUltimate]

Hi all,

i install it but i have a problem, the backup never finish...

The procedure stop when backup a file with 60.000 records.

Any idea how i can solve that problem?

Waiting your help...

[Simon Lloyd]

That must be the limitations of your server configuration i.e PHP memory limit, MySql memory.....etc

I have forums with160,000+ threads and the backup has always completed for me.

[Paul M]

Most likely your host is imposing a timeout on php, which the mod is unable to override.

[Simon Lloyd]

Hi Paul, i have to say with the old version prior to the one with no gzip i had no problem backing up once a week (i had to check my backups after responding to the post above) but with the new version using gzip i find that doing a daily backup only backed up a small portion of my database, with the final file in the folder NOT being compressed.

Is there anyway i can have the previous xml to go back to please?

[Paul M]

There is no difference between them as far as actual backups are concerned.

[Simon Lloyd]

Hmm. it's odd then, i set the backup to be daily and every day it only backed up the first say 25 tables, i've deleted them now but how ever many it was it was exactly the same in each days folder and always the last file (which just happened to be attachments) wasn't compressed, i've set cron to just onday now and see how we go :)

[Paul M]

I just checked, and the only changes are for Gzip. What happens if you run it manually ?

[Simon Lloyd]

Just ran it manually, when using gzip i get this after it cas compressed 31 tables:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 21605379 bytes) in /home/thecodec/public_html/forumz/includes/mysqlbackup.php on line 498

So using GZIP is causing me to run out of memory?

EDIT: in fact i just turned off GZIP and get the same thing, it always ends on .............
Processing vb_announcementread (9) : Processed 9 Rows in 0.001 seconds
Processing vb_attachment (591)
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 21605379 bytes) in /home/thecodec/public_html/forumz/includes/mysqlbackup.php on line 498


EDIT2: here's my forum stats:Server Type Linux
Web Server Apache v2.0.63
PHP 5.2.9
MySQL Version 5.0.91-community-log
Data Usage 1.16 GB
PHP Max Post Size 50.00 MB
PHP Maximum Upload Size 50.00 MB
PHP Memory Limit 64.00 MB
MySQL Packet Size 64.00 MB
Index Usage 496.61 MB
Attachment Usage 76.69 MB
Avatar Usage 180.9 KB
Profile Picture Usage 74.0 KB

[Simon Lloyd]

UPDATE
I moved the attachments to the file system and can confirm that this mod works fine both with and without gzip.

I don't know if there was a work around to it but the post table was like 1.4Gb and it didn't stall at that and compressed it nicely to 331mb!

[larry suttles]

To set the date formate to a lower case "L" would is look like this??

Y-m-l

Or do I just put the lower case "l" by it's self?

l

[Simon Lloyd]

just the "l"

[slowphantom]

hi Pual

my host change my php.ini file

and since thay change it the hack dosnt work
i try it to run it but it give
An error occured during the Backup :

that is all it dosnt give any des about the error

so i looked at the old one and the new one
and saw

disable_functions it have code will pm u with it

Thanks

[Paul M]

hi Pual

my host change my php.ini file


Change it back.

Ive looked at what you sent me and tbh, its a wonder anything works, ive never seen a disable functions list so large, it would take me ages to check through all the entries in it.

[slowphantom]

ok Paul Thanks
i change it back and its working again now :)


Thank You

[d0zer]

Thanks Paul M :)

[Fynnon]

Is there a PRO version which sends the database to a mail address after beeing gzip-ed?

[faisalk]

Thank you Paul.

[Paul M]

Is there a PRO version which sends the database to a mail address after beeing gzip-ed?
Nope.

[ITDarasgah]

Install and run manual show this
Automatic Database Backup for vBulletin
Processing access (264) : Processed 264 Rows in 0.005 seconds
Processing action (No Row Data)
Processing adminhelp (1694) : Processed 1694 Rows in 0.045 seconds
Processing administrator (7) : Processed 7 Rows in 0 seconds
Processing adminlog (59083) : Processed 59083 Rows in 1.346 seconds
Processing adminmessage (No Row Data)
Processing adminutil (2) : Processed 2 Rows in 0 seconds
Processing album (4) : Processed 4 Rows in 0.001 seconds
Processing albumpicture (17) : Processed 17 Rows in 0 seconds
Processing albumupdate (No Row Data)
Processing announcement (2) : Processed 2 Rows in 0 seconds
Processing announcementread (154) : Processed 154 Rows in 0.002 seconds
Processing attachment (53112) : Processed 53112 Rows in 2.173 seconds
Processing attachmentcategory (No Row Data)
Processing attachmentcategoryuser (15217) : Processed 15217 Rows in 0.278 seconds
Processing attachmentpermission (25) : Processed 25 Rows in 0.001 seconds
Processing attachmenttype (18) : Processed 18 Rows in 0.001 seconds
Processing attachmentviews (No Row Data)
Processing avatar (No Row Data)
Processing bbcode (1) : Processed 1 Rows in 0 seconds
Processing bbcode_video (7) : Processed 7 Rows in 0 seconds
Processing bookmarksite (4) : Processed 4 Rows in 0 seconds
Processing cache (1) : Processed 1 Rows in 0 seconds
Processing cacheevent (3) : Processed 3 Rows in 0 seconds
Processing calendar (1) : Processed 1 Rows in 0 seconds
Processing calendarcustomfield (No Row Data)
Processing calendarmoderator (No Row Data)
Processing calendarpermission (No Row Data)
Processing contentpriority (No Row Data)
Processing contenttype (14) : Processed 14 Rows in 0.001 seconds
Processing cpsession (1) : Processed 1 Rows in 0.001 seconds
Processing cron (19) : Processed 19 Rows in 0.001 seconds
Processing cronlog (15362) : Processed 15362 Rows in 0.284 seconds
Processing customavatar (737) : Processed 737 Rows in 0.022 seconds
Processing customprofilepic (447) : Processed 447 Rows in 0.011 seconds
Processing cyb_logintouser (1) : Processed 1 Rows in 0 seconds
Processing datastore (32) : Processed 32 Rows in 0.081 seconds
Processing deletionlog (3683) : Processed 3683 Rows in 0.098 seconds
Processing discussion (No Row Data)
Processing discussionread (No Row Data)
Processing editlog (4348) : Processed 4348 Rows in 0.102 seconds
Processing event (5) : Processed 5 Rows in 0.001 seconds
Processing externalcache (No Row Data)
Processing faq (43) : Processed 43 Rows in 0.001 seconds
Processing filedata (14183) : Processed 14183 Rows in 0.607 seconds
Processing forum (193) : Processed 193 Rows in 0.02 seconds
Processing forumpermission (386) : Processed 386 Rows in 0.007 seconds
Processing forumprefixset (192) : Processed 192 Rows in 0.003 seconds
Processing forumread (No Row Data)
Processing groupmessage (No Row Data)
Processing groupmessage_hash (6) : Processed 6 Rows in 0.001 seconds
Processing groupread (No Row Data)
Processing holiday (No Row Data)
Processing humanverify (4) : Processed 4 Rows in 0 seconds
Processing hvanswer (No Row Data)
Processing hvquestion (1) : Processed 1 Rows in 0 seconds
Processing icon (36) : Processed 36 Rows in 0.001 seconds
Processing imagecategory (3) : Processed 3 Rows in 0 seconds
Processing imagecategorypermission (No Row Data)


Database error
******************************** database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www.itdarasgah.com home page, then try to open another page.
* Click the Back button to try another link.

The www.itdarasgah.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.
Database error in vBulletin 3.8.7 Beta 1: Invalid SQL: SHOW CREATE TABLE `indexqueue`; MySQL Error : Incorrect file format 'indexqueue' Error Number : 130 Request Date : Sunday, November 21st 2010 @ 07:08:16 AM Error Date : Sunday, November 21st 2010 @ 07:08:21 AM Script : http://www.*******.com/******/cronadmin.php?do=runcron&cronid=50 Referrer : http://www.********.com/******/cronadmin.php?do=modify IP Address : ********** Username : ****** Classname : vB_Database MySQL Version : 5.0.91-community

[Paul M]

You have an issue with a table called indexqueue - try repairing it.

Btw - that is not a standard table in vb 3.8.x

[ITDarasgah]

Can you help me how can repair it .
and in my board its not run auto

[Paul M]

Can you help me how can repair it .
and in my board its not run auto
Use phpmyadmin to repair it - or even the repair option in the vbulletin ACP.

I dont really understand the last part of your post.

[ITDarasgah]

Use phpmyadmin to repair it - or even the repair option in the vbulletin ACP.

I dont really understand the last part of your post.

Thank you Paul for reply , I mean this mod is not working for Automatic Backup just work manual but with the above errer . While I set time in Scheduled Task Manager

[ITDarasgah]

After delete that table and Run manual its work and stop after this is this is complete or not
Automatic Database Backup for vBulletin
Processing access (265) : Processed 265 Rows in 0.004 seconds
Processing action (No Row Data)
Processing adminhelp (1694) : Processed 1694 Rows in 0.037 seconds
Processing administrator (7) : Processed 7 Rows in 0.001 seconds
Processing adminlog (59227) : Processed 59227 Rows in 1.355 seconds
Processing adminmessage (No Row Data)
Processing adminutil (2) : Processed 2 Rows in 0 seconds
Processing album (4) : Processed 4 Rows in 0 seconds
Processing albumpicture (17) : Processed 17 Rows in 0.001 seconds
Processing albumupdate (No Row Data)
Processing announcement (2) : Processed 2 Rows in 0 seconds
Processing announcementread (154) : Processed 154 Rows in 0.002 seconds
Processing attachment (53150) : Processed 53150 Rows in 2.231 seconds
Processing attachmentcategory (No Row Data)
Processing attachmentcategoryuser (15217) : Processed 15217 Rows in 0.274 seconds
Processing attachmentpermission (25) : Processed 25 Rows in 0.001 seconds
Processing attachmenttype (18) : Processed 18 Rows in 0.001 seconds
Processing attachmentviews (No Row Data)
Processing avatar (No Row Data)
Processing bbcode (1) : Processed 1 Rows in 0 seconds
Processing bbcode_video (7) : Processed 7 Rows in 0 seconds
Processing bookmarksite (4) : Processed 4 Rows in 0 seconds
Processing cache (1) : Processed 1 Rows in 0 seconds
Processing cacheevent (3) : Processed 3 Rows in 0 seconds
Processing calendar (1) : Processed 1 Rows in 0 seconds
Processing calendarcustomfield (No Row Data)
Processing calendarmoderator (No Row Data)
Processing calendarpermission (No Row Data)
Processing contentpriority (No Row Data)
Processing contenttype (14) : Processed 14 Rows in 0.001 seconds
Processing cpsession (1) : Processed 1 Rows in 0.003 seconds
Processing cron (19) : Processed 19 Rows in 0.002 seconds
Processing cronlog (15391) : Processed 15391 Rows in 0.295 seconds
Processing customavatar (738) : Processed 738 Rows in 0.023 seconds
Processing customprofilepic (449) : Processed 449 Rows in 0.011 seconds
Processing cyb_logintouser (1) : Processed 1 Rows in 0 seconds
Processing datastore (32) : Processed 32 Rows in 0.018 seconds
Processing deletionlog (3683) : Processed 3683 Rows in 0.089 seconds
Processing discussion (No Row Data)
Processing discussionread (No Row Data)
Processing editlog (4353) : Processed 4353 Rows in 0.094 seconds
Processing event (5) : Processed 5 Rows in 0.001 seconds
Processing externalcache (No Row Data)
Processing faq (43) : Processed 43 Rows in 0.001 seconds
Processing filedata (14183) : Processed 14183 Rows in 0.59 seconds
Processing forum (193) : Processed 193 Rows in 0.019 seconds
Processing forumpermission (386) : Processed 386 Rows in 0.006 seconds
Processing forumprefixset (192) : Processed 192 Rows in 0.002 seconds
Processing forumread (No Row Data)
Processing groupmessage (No Row Data)
Processing groupmessage_hash (6) : Processed 6 Rows in 0 seconds
Processing groupread (No Row Data)
Processing holiday (No Row Data)
Processing humanverify (4) : Processed 4 Rows in 0.001 seconds
Processing hvanswer (No Row Data)
Processing hvquestion (1) : Processed 1 Rows in 0 seconds
Processing icon (36) : Processed 36 Rows in 0.001 seconds
Processing imagecategory (3) : Processed 3 Rows in 0 seconds
Processing imagecategorypermission (No Row Data)
Processing infraction (168) : Processed 168 Rows in 0.007 seconds
Processing infractionban (1) : Processed 1 Rows in 0 seconds
Processing infractiongroup (No Row Data)
Processing infractionlevel (4) : Processed 4 Rows in 0 seconds
Processing language (1) : Processed 1 Rows in 0.008 seconds
Processing mailqueue (No Row Data)
Processing memberviews (No Row Data)
Processing membervisits (No Row Data)
Processing moderation (74) : Processed 74 Rows in 0.001 seconds
Processing moderator (171) : Processed 171 Rows in 0.004 seconds
Processing moderatorlog (82662) : Processed 82662 Rows in 4.363 seconds
Processing notice (9) : Processed 9 Rows in 0.001 seconds
Processing noticecriteria (14) : Processed 14 Rows in 0.001 seconds
Processing noticedismissed (776) : Processed 776 Rows in 0.009 seconds
Processing package (1) : Processed 1 Rows in 0 seconds
Processing passwordhistory (25487) : Processed 25487 Rows in 0.367 seconds
Processing paymentapi (7) : Processed 7 Rows in 0.001 seconds
Processing paymentinfo (No Row Data)
Processing paymenttransaction (No Row Data)
Processing phrase (11999) : Processed 11999 Rows in 0.37 seconds
Processing phrasetype (67) : Processed 67 Rows in 0.002 seconds
Processing picture (17) : Processed 17 Rows in 0.005 seconds
Processing picturecomment (No Row Data)
Processing picturecomment_hash (No Row Data)
Processing picturelegacy (17) : Processed 17 Rows in 0.001 seconds
Processing plugin (251) : Processed 251 Rows in 0.01 seconds
Processing pm (300027) : Processed 300027 Rows in 6.285 seconds
Processing pmreceipt (14) : Processed 14 Rows in 0.001 seconds
Processing pmtext (15087) : Processed 15087 Rows in 0.695 seconds
Processing pmthrottle (No Row Data)
Processing podcast (No Row Data)
Processing podcastitem (No Row Data)
Processing poll (129) : Processed 129 Rows in 0.005 seconds
Processing pollvote (3190) : Processed 3190 Rows in 0.065 seconds
Processing post (726386) : Processed 726386 Rows in 38.915 seconds
Processing post_thanks (123861) : Processed 123861 Rows in 2.35 seconds
Processing postedithistory (9949) : Processed 9949 Rows in 0.421 seconds
Processing posthash (8) : Processed 8 Rows in 0.001 seconds
Processing postindex (9087571)


and please guide me how can set for daily backup on 2:00 AM

[Paul M]

No thats not complete. Processing 9 million records will take a long while, your browser may well time out.

Installing the mod creates the necessary [vb] scheduled task. You just need to alter the time of it.

[ITDarasgah]

No thats not complete. Processing 9 million records will take a long while, your browser may well time out.

Installing the mod creates the necessary [vb] scheduled task. You just need to alter the time of it.
Thanks for reply:)
I did not find that mod You can identify or give me the link

[Paul M]

What mod ?

[ITDarasgah]

No thats not complete. Processing 9 million records will take a long while, your browser may well time out.

Installing the mod creates the necessary [vb]

I am saying about that..:)

[snowlion]

I am saying about that..:)
He is talking about this mod :D

[Paul M]

I am saying about that..:)

He is talking about this mod :D

Yep. :)

[ITDarasgah]

He is talking about this mod :D

Yep. :)

:eek::p
Then give me an Advice about the time out, What should I do?

[Paul M]

TBH, I suggest you switch to using the mysql full text search, and empty out the old search tables (of which postindex is one).

[ITDarasgah]

TBH, I suggest you switch to using the mysql full text search, and empty out the old search tables (of which postindex is one).

Thank you :)

but how , Unfortunately I am not programmer can tell you in detail I am thankful to you.

I'm sorry to waste your time

[Paul M]

No programming necessary, its in the ACP.

vBulletin Options >> Search Type

[ITDarasgah]

No programming necessary, its in the ACP.

vBulletin Options >> Search Type

Great..................Thank you very much:up:
now its work like a..:cool:

Processed Database in 98.067 seconds

[Compressing Combined File] : Processed File Compression in 24.7 seconds

The Backup was completed successfully.

Done

[MjrNuT]

Hey Paul,

disclaimer: I'm using v.002

I believe since daylight savings time my issue has occurred. I have a backup done 1/week. It will close the forum and then reopen it. But, since daylight savings time, it does not seem to reopen the forum.

Any comment on this?

Thanks

[Paul M]

DST will not make any difference to opening and closing.

As to the option in general - see post #360 (https://vborg.vbsupport.ru/showthread.php?p=2101304#post2101304)

[MjrNuT]

Much appreciated.

[mp3president]

I looked at your website, but is it possible for you to give me a link to the pro version?
I'm running a forum with mostly pro versions, after testing the lite versions.

Greetings Ron.

[Paul M]

There is no pro version.

The name "lite" is historical, and not intended to imply there is any other version.

[mp3president]

Thank you Paul, for your quick answer and information.
Shame there is no pro version of it, but i'll do okay with the lite.

[Simon Lloyd]

Thank you Paul, for your quick answer and information.
Shame there is no pro version of it, but i'll do okay with the lite.What would you expet in the "pro" version? this does everything you'll need!

[Scalemotorcars]

Im sorry but where the heck are the instructions? :confused::o

[Paul M]

In the zip.

[Scalemotorcars]

Yep, I see those but nothing about the actual settings in the ACP (Control Panel) . Maybe something a little more descriptive for the novice...:o

Installation.

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

2. Upload the product XML via the Product Manager.

2. Set your choice of options in the ACP (vBulletin Options).

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

Note: There are some advanced options available in the uploaded config file.

[Paul M]

As I recall they are pretty self explanatory, and generally dont need to be changed. What option are you referring to ?

[Scalemotorcars]

Files Prefix = Forum- ??? My site uses another forum prefix. Not the default vb3. Do I change this to my database prefix?

Backups Path = ../../backups/ Do I create this Dir or will the program do it? Should it be 644 ~ 777? Relative path ??? Not exactly sure what a relative path is. Ill know- Google it.

InnoDB Tables ??? No ideal if I have them or not. How would I make sure?

Thanks Paul for your time. I just want to make sure 100% its done correctly and it doesn't hurt having the info here for others to use. :D

[Simon Lloyd]

Files Prefix = Forum- ??? My site uses another forum prefix. Not the default vb3. Do I change this to my database prefix?This is simply how you want the file identified after its created so you could call it "my really long name for back up" and it will appear as "my really long name for back up - MyForum.Sql.zip"....etc

Backups Path = ../../backups/ Do I create this Dir or will the program do it? Should it be 644 ~ 777? Relative path ??? Not exactly sure what a relative path is. Ill know- Google it.the example shown here is for a folder called backups and will be above public_html level (i.e the folder that houses public_html) but you can have the folder wherever you want and change the path, and yes the folder should b CHMOD 777 which again is why it should be at /home level rather than /public_html level

InnoDB Tables ??? No ideal if I have them or not. How would I make sure?

Thanks Paul for your time. I just want to make sure 100% its done correctly and it doesn't hurt having the info here for others to use. :DIgnore Innodb, if you have not specifically changed these tables in phpmyadmin or via ssh then they will be MYISAM by default.

[Paul M]

Well, that pretty much covers it - thank you Simon. :D

[Scalemotorcars]

Thanks guys I really appreciate it.:up:

[Simon Lloyd]

Well, that pretty much covers it - thank you Simon. :DYou're welcome :), i remember when i was scared to change or touch anything on my server or in VB, but now that i have broken it and fixed it so many times i like to help those who fear it get in the same mess :D

[mp3president]

What would you expet in the "pro" version? this does everything you'll need!

Maybee it had some extra functions in it, like always in pro versions.
But i'm not complaining about this plugin, it works perfectly, thank you.

[XFSImperial]

Works perfectly and the gzip feature really helps increase the number of past backups I can keep on the server.

[Dingo14]

could this be done for version 3.7 thanks

[HMBeaty]

could this be done for version 3.7 thanks
https://vborg.vbsupport.ru/showthread.php?t=167276

[Dingo14]

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

thanks for reply nice one

[Vcize]

When I attempt to run it I just get the following error:

An error occured during the Backup :

With no message..

[Paul M]

Not much i can tell you with no message, other than its likely a server issue.

[Simon Lloyd]

It's almost certainly down to your timeout on the server or your settings for PHP memory or MySql packets....etc

[newguy]

When I attempt to run it I just get the following error:



With no message..

That happened to me until I got my directory correct where it was supposed to put the backup.

Lets say you forum root is forums and you dump your back up in forums/folderx what i did is enter in folderx/ in the backup path and it works and make sure foderx has 777 permissions. I also did password protect that directory also. Not sure if 777 permissions is the one to use though???

[Simon Lloyd]

Having your folder at public level is not a good idea as explained by PaulM in his mod, your folder should be at least one level up, that way there is no need to password protect it or worry about folk accessing your entire database details. PaulM has already provided a path, simply put your backup folder there.

[newguy]

Having your folder at public level is not a good idea as explained by PaulM in his mod, your folder should be at least one level up, that way there is no need to password protect it or worry about folk accessing your entire database details. PaulM has already provided a path, simply put your backup folder there.

I am sorry I did change mine to one level above the public_htlm. That is good right?

[Simon Lloyd]

I am sorry I did change mine to one level above the public_htlm. That is good right?
;) yep thats right!

[crouzmind]

sir can you assist me about this error .

An error occured during the Backup :

i have vbulletin 3.8 and i did not know how can i edit my config file please tell me where i need to put the full path of the folder where i want to put the backup dump .

thanks in advanced .

[Simon Lloyd]

sir can you assist me about this error .

An error occured during the Backup :

i have vbulletin 3.8 and i did not know how can i edit my config file please tell me where i need to put the full path of the folder where i want to put the backup dump .

thanks in advanced .If you read the text that came with the mod and look at the mod settings you will see where Paul M has already set the folder path you simply need to use this (make sure a folder of that name appears in that location as the mod doesn't create one) or change the folder name and location to yours.

[Vcize]

Having your folder at public level is not a good idea as explained by PaulM in his mod, your folder should be at least one level up, that way there is no need to password protect it or worry about folk accessing your entire database details. PaulM has already provided a path, simply put your backup folder there.

Perhaps that is my problem. I use dreamhost, so there is no public_html folder or anything like that.

When I log into the root of my server, I just see a folder for each of my sites. Inside each of those folders are the sites files.

So, I created my backup folder in the root, so now the root of my server looks like.

site1.com
site2.com
site3.com
site4.com
backups

Is that right?

[Simon Lloyd]

It should be, if you use a file manager, when you click on the folder or check it's properties what does it show?

[Vcize]

It should be, if you use a file manager, when you click on the folder or check it's properties what does it show?

I'm using filezilla.

Don't see an option for properties. That permissions are 777.

[Fynnon]

i get an errorr:

Database error in vBulletin 3.8.6:

Invalid SQL:

INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('cbu_crontask',
1319406226,
'An error occured during the Backup : ',
0);

MySQL Error : Table 'cronlog' was locked with a READ lock and can't be updated
Error Number : 1099
Request Date : Sunday, October 23rd 2011 @ 11:43:46 PM
Error Date : Sunday, October 23rd 2011 @ 11:43:46 PM
Script : http://www.xxx.com/admincp/cronadmin.php?do=runcron&cronid=45
Referrer : http://www.xxx.com/admincp/cronadmin.php?do=modify
IP Address : xx.xx.xx.xxx
Username : xxx
Classname : vB_Database
MySQL Version : 5.0.77

[Walter Ronny]

there is a version working for 4.2?

Thanks!

[Paul M]

Yes.

Just click on my title (Dr Pepper ..) and it will take you to the modification list in my profile.

[trotskid]

Hi. It would be possible rewrite the backup file to avoid having to delete every day the accumulate files in the database?

Thanks

[valdet]

Paul,
Is there an easy way to clone the mod, so besides taking daily SQL backups, we can also set a cron job so it takes a monthly backup?

I currently have the Date Format field as d which makes backups in date based directories.

However I'd like to know if it's possible to have another cronjob set up so it takes the monthly backups (e.g. on day 1 of each month) and the Date Format would be M

M A short textual representation of a month, three letters Jan through Dec

Thanks for excellent mod.

[Paul M]

If you copied the files and created a new cron task there isnt any reason you could not do that.

[valdet]

If you copied the files and created a new cron task there isnt any reason you could not do that.

I thought of that, but the problem is the settings on vB Admin Panel. My current setting is
Date Format: d

How to make them differentiate for two backup options that we need: Daily and Monthly.

How to add another option so besides taking daily backups, it also takes backups on 1-st of every month. Or maybe I'm missing something too obvious.

Please advise.

Thanks

[Paul M]

You would need to override the options in the copies you make (hard code them).

[valdet]

You would need to override the options in the copies you make (hard code them).

Ok thanks,

From your mysqlbackup.php file, I see these rows referencing the settings

$this->DATE = date($this->OPTIONS['cbu_date']);
$this->PREFIX = &$this->OPTIONS['cbu_prefix'];
$this->DUMP_PATH = &$this->OPTIONS['cbu_path'];

Should they be hardcoded on to a new mysqlbackup2.php like

$this->DATE = date($M);
$this->PREFIX = &monthly-backup;
$this->DUMP_PATH = &/home/user/my-custom-path/;

Please advise what would be the correct hardcoded part

Thanks

[valdet]

Ok this is how you do it.

1. Make copies of the two product files: mysqlbackup2.php and cron/cronbackup2.php
2. Add three extra settings to product:
cbu_date2: M
cbu_prefix2: monthly-backup and
cbu_path2: /home/user/my-custom-path/
3. Make this change at mysqlbackup2.php
From
// File Information
$this->DATE = date($this->OPTIONS['cbu_date']);
$this->PREFIX = &$this->OPTIONS['cbu_prefix'];
$this->DUMP_PATH = &$this->OPTIONS['cbu_path'];
to
// File Information
$this->DATE = date($this->OPTIONS['cbu_date2']);
$this->PREFIX = &$this->OPTIONS['cbu_prefix2'];
$this->DUMP_PATH = &$this->OPTIONS['cbu_path2'];
4. Make this change inside cronbackup2.php
From
require_once(DIR.'/includes/mysqlbackup.php');
to
require_once(DIR.'/includes/mysqlbackup2.php');
5. Add new Scheduled Task to start at first day of each month and to run it from cronbackup2.php
6. Done

It was too easy once you figure out, but thanks to Paul for giving the hints. Step 2 was key.

I hope someone finds this useful.