vBulletin Cron Based Database Backup

[chikuru]

what could be the cause of the blank page?
i tried changing the var to mysql also.
is there any way to log the error?

[ozzy47]

Check your server error logs. If you don't know where they are, ask your host.

[john7911]

Hi,
When I download an sql my forum does not work :(
https://vborg.vbsupport.ru/external/2014/10/1.jpg
what is the problem?
Thank you ;)

[john7911]

any solution?

[tbworld]

You would have to leave us more details on what you did. How did you restore the database? What was the reason you had to restore your database from a backup?

:)

[john7911]

Advisor

Join Date: Oct 2008
Posts: 2,133
Design: Red Rum,Wide
You would have to leave us more details on what you did. How did you restore the database? What was the reason you had to restore your database from a backup?

Reply With Quote

I did a back up of my forum , before manipulating into the template, but i was not happy with the modification, and decided to restore the forum.
I have tried directly via phpmyadmin but it does not work properly , then I have used bigdump to do it.
All the table are in the database.

https://vborg.vbsupport.ru/external/2014/11/20.jpg

Thank you :)

[RichieBoy67]

Well this backs up only the database, not the files.

What do you mean it did not work? Do you have ssh access?

[ZeroDoom]

Hi, I'm still confused about the date format and directory of the backups.. Could anyone help? I want mine to backup daily and have the backups stored in public_html/backups

Thanks!

[Mariner1]

Hi. This has been working fine until a few days ago.When trying to do backups now i get this error in admincp

Database error in vBulletin 4.2.2:

Invalid SQL:
OPTIMIZE TABLE `filedata`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, January 2nd 2015 @ 05:54:35 AM
Error Date : Friday, January 2nd 2015 @ 05:55:08 AM
Script : http://www.xxxxxxxxxxx.com/admincp/cronadmin.php?do=runcron&cronid=95
Referrer : http://www.xxxxxxxxxxxx.com/admincp/cronadmin.php?do=modify
IP Address : xx.x.xxx.xx
Username : xxxxxxx
Classname : vB_Database
MySQL Version :

Any idea what this is and how to fix it pls

[charlesr]

Seems pretty straightforward - the database server was down when you tried to backup. Restart it.
On my linux server this is something like /etc/rc.d/init.d/mysqld restart.
Check logs to see if there's any clue why it was down. Maybe your server overloaded? If so, upgrade to one with more RAM or better IO. VB4 really needs 2GB RAM for a largish forum.

[Mariner1]

Thanks charlesr,server reboot worked.

[ozzy47]

Hi. This has been working fine until a few days ago.When trying to do backups now i get this error in admincp

Database error in vBulletin 4.2.2:

Invalid SQL:
OPTIMIZE TABLE `filedata`;

MySQL Error : MySQL server has gone away

Any idea what this is and how to fix it pls

I see you got it going by doing a server reboot, that's great. But you may run into the issue again.

MySQL Server has gone away" is a server issue. See this: https://www.vbulletin.com/docs/html/...mysql_goneaway (https://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway) and this: https://www.vbulletin.com/forum/show...265#post310265 (https://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265) You will need to talk to your host about this in order to get it resolved.

[Paul M]

Hi. This has been working fine until a few days ago.When trying to do backups now i get this error in admincp

Database error in vBulletin 4.2.2:

Invalid SQL:
OPTIMIZE TABLE `filedata`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, January 2nd 2015 @ 05:54:35 AM
Error Date : Friday, January 2nd 2015 @ 05:55:08 AM
Script : http://www.xxxxxxxxxxx.com/admincp/cronadmin.php?do=runcron&cronid=95
Referrer : http://www.xxxxxxxxxxxx.com/admincp/cronadmin.php?do=modify
IP Address : xx.x.xxx.xx
Username : xxxxxxx
Classname : vB_Database
MySQL Version :

Any idea what this is and how to fix it pls

It looks like optimizing that table took longer than your mysql timeout.

It should have run fine again next time.

You dont really need to have that [optimize] option enabled, I would turn it off.

[Daniel]

Hi :) Will this work for big boards (1mil+ posts & attachments allowed)?

[Paul M]

I have over two million posts.

Attachments will only be backed up if you store them in the database.
Thats generally not a good idea if you have a lot, as your database will be large.

[thunderclap82]

Is there a way to configure this so that the database is sent off server to something like Dropbox or Google Drive?

[Paul M]

Not unless there is a way to specify it as a server path.

[ebp123]

can someone explain to me how to actually run this backup program? I just installed it and set the backup folder location and am a bit confused.

[Paul M]

Well the title and description should give you a clue ;)

vBulletin Cron Based Database Backup
It is a simple vBulletin cron trigged php system that does a dump of your database


It runs automatically, thats the purpose of cron based systems. :)

[ebp123]

So once i set up the backup folder, it automatically puts back ups of my database in it? Forgive my ignorance, im just a lumberjack trying my hand at the internet.

[Paul M]

So once i set up the backup folder, it automatically puts back ups of my database in it?
Thats the idea, yes. :)

[hanm15]

Working with 4.2.2?

[Fields]

Working with 4.2.2?

Yes :)

[Marv]

Thats the idea, yes. :)

Paul,

I guess you know MySQLDumper. Any chance you could implement something similiar to MSQLD?s FTP-transfer into this mod? I?ld always like to have my backups on a secure location, like a dedicated ftp-server or repository, since our harddrive crashed last year and with it - of course - all of our backups were gone, too. What do you think? Makes sense?

[spd2612]

I installed this quite a while back on 4.2.0 and works very well, so well I keep forgetting about it and I keep filling up my HDD is there a way to limit the number of backups or is it just up to me to remember to clean up my backup folder?

[Marv]

Store your sitemaps in a separate partition of your hdd. So, if you forget to delete them, your site will still work. Elseif the hdd where your forum is on is full, your server will have major headaches - and so will you ;)

[MistViper]

Downloaded and marked as installed! I have a couple basic questions though. How do I find the back up after it is done? Also should I select yes for combining all tables into one backup file?

[CvP]

Paul,

I guess you know MySQLDumper. Any chance you could implement something similiar to MSQLD?s FTP-transfer into this mod? I?ld always like to have my backups on a secure location, like a dedicated ftp-server or repository, since our harddrive crashed last year and with it - of course - all of our backups were gone, too. What do you think? Makes sense?

I actually have added this functionality to this add-on years ago. I will see if I can release it here. In the mean time, you can check the add-on I published just now which works in conjunction with Paul's add-on.

[patracy]

[SIZE=2]1) Do I have to turn off my site to run this backup? No.

2) While running backup, does it affect the site performance (slow)? Depending on how large your database is will depend on how much time/server resources your backup will take. It's a cron job so just schedule it to run at the slowest time of the day for your site. A backup is a lot more important than worrying about slowing your site for few seconds or minutes at an off-peak time.


How would one setup the site to turn off during this backup process? Have a rather large db here (1gb zipped). Would rather have the site off, let the backup run, then turn the site back on.

[Dave]

How would one setup the site to turn off during this backup process? Have a rather large db here (1gb zipped). Would rather have the site off, let the backup run, then turn the site back on.

To be honest if your database is reaching a point where it's getting quite big, you should not rely on such plugin anymore but create your own OS based cronjob. In Linux you can make use of crontabs and create a basic bash script that executes the mysqlbackup command.

[patracy]

To be honest if your database is reaching a point where it's getting quite big, you should not rely on such plugin anymore but create your own OS based cronjob. In Linux you can make use of crontabs and create a basic bash script that executes the mysqlbackup command.

That's true. And actually that's the direction I've been meaning to go in. But I've not been able to find a method on scheduling vB on/off. I suppose I could cron apache on and off, but that'd leave users in the dark.

[shimei]

That's true. And actually that's the direction I've been meaning to go in. But I've not been able to find a method on scheduling vB on/off. I suppose I could cron apache on and off, but that'd leave users in the dark.

I began a thread here on the subject: Maintenance Page for Cron Backup (https://theadminzone.com/threads/maintenance-page-during-mysql-dump-code-for-cron.138681/#post-1037537)

[Davidinh]

seem something were missing in the Auto-backup.txt and base on my problem I would like to share to all

Installation
------------

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

2. Upload the product XML via the Product Manager.

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

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

5. To use the (experimental) MySQL backup option, you need to edit the mysqlbackup.php file.

Find var $DTYPE = 'php'; and change it to var $DTYPE = 'mysql'

In a case for new version of mysql you should add var $MYSQLI; (after var $MYSQL) in mysqlbackup.php then change var $DTYPE = 'mysqli' ;

6. Create the new folder as "backups" or what ever you desire for it then set permission as 777

if it is in the root website in AdminCP option should set ./backups/
if it is in the forum directory in AdminCP option should set ../backups/
and so on.

hope it helps

THANK YOU PAUL it is useful mode

[Paul M]

In a case for new version of mysql you should add var $MYSQLI; (after var $MYSQL) in mysqlbackup.php then change var $DTYPE = 'mysqli' ;
This isnt necessary, and wont do anything.
In fact, if you set $DTYPE = 'mysqli' you will end up using the php backup process.
You seem to be confusing variable names with actual database systems, the fact you are now using MySQLi doesnt affect the variable names.

For the backup path, you should never use a website location (i.e. one thats accessible via a url) such as the two examples you gave, otherwise anyone can potentially just download your backup files.

[twlMavRic]

Installed and ran backup in just over 11 secs. Works as advertised

[Manoel J?nior]

Advise not to use this product if you have a forum that goes from 1GB database, I recommend you look for something like mysqldump

[charlesr]

Any particular reason? Mine is 3.5GB and it works ok. It compresses to a 600MB .gz
I haven't tried restoring it for a while, but it worked a while back ok.

[Idawg]

I have used this mod for years, on many forums I set up/run for clients..

On my newest forum, I am on 4.2.3 and I uploaded to correct location, set everything under options and when I go to save, it gives me a 404 error????? What is up with that ??

[RichieBoy67]

File permissions set to 777?

[Idawg]

On what???

[RichieBoy67]

Three directory where the back up is to be placed need to he write permissions.

[Idawg]

Fixed the issue... I had one too many ../ on the path... Fixed that and it works a-okay now :)

[Paul M]

Advise not to use this product if you have a forum that goes from 1GB database, I recommend you look for something like mysqldump
Only just noticed this, which is complete rubbish.
My forum has been over 1GB for years, and happily using this for years.

(In fact, if you had bothered to check, it actually has an option to use mysqldump, rather than the php based dump routine, built in).

[elsa23]

Hi,
What is the difference between php and mysql? which one is recommended to use, to can restore in the future with "bigdump"
Because, with "var $DTYPE = 'php';"all its OK.
But when I confgure it to "mysql" , I got this error and the backup folder is empty:
Automatic Database Backup for vBulletin


PHP Warning: Invalid argument supplied for foreach() in ..../includes/mysqlbackup.php on line 626

Backup Completed Successfully
Fait

Thanks
4.2.3 PL2

[elsa23]

Also, I had set Scheduled Task to "3h" of the nignt, but It do it at "5h", 2 hours later

[Paul M]

What is the difference between php and mysql? which one is recommended to use, to can restore in the future with "bigdump"
Because, with "var $DTYPE = 'php';"all its OK.
But when I confgure it to "mysql" , I got this error and the backup folder is empty:

'mysql' will attempt to use mysqldump, which in your case looks like it wont work, so just stick to using 'php'.

[elsa23]

Also, I had set Scheduled Task to "3h" of the nignt, but It do it at "5h", 2 hours later

I'm off topic, but I found also that notifications, via emails, for new replays, arrives 2 hours later, It's a server bug ?

[elsa23]

I do not understand the time offset :(

[orangedays]

will this work with version 5?

[Paul M]

If you manually installed the files, and manually added the cron job, I think it probably would.

However, the product would not install using the normal ACP method.

[X-or]

after restoring a backup created with this product, my database was completely screwed up

this product has a charset bug somewhere, don't use it

I have created a simple cron job instead and it makes proper backups

[Paul M]

Utter nonsense.

I have restored backups from this for many years, without a single issue, as have many many other people.

[X-or]

Are you saying I'm lying?

Maybe it works on 100% english sites but on forums with any kind of foreign or special characters, this product will cause massive issues.

[Paul M]

Call it what you want.

This has been around for at least 12 years, if not longer.
(in Fact longer as it was originally written by Trigunflame for 3.0)
I think if it had "massive issues" it would be known about long ago.

Just because YOU had an issue it does not mean everyone else does.

[X-or]

Your product doesn't escape special characters properly
any query with a special character will be interrupted at the special character location
it's very easy to miss

just because I'm the only one who reported this doesn't mean I'm the only one who had issues, it means I'm the only one who noticed the issue AND reported it

Feel free to ignore my report good Sir, I'm just warning other users.

[Stratis]

Your product doesn't escape special characters properly
any query with a special character will be interrupted at the special character location
it's very easy to miss

just because I'm the only one who reported this doesn't mean I'm the only one who had issues, it means I'm the only one who noticed the issue AND reported it

Feel free to ignore my report good Sir, I'm just warning other users.


Some thing like your problem...
My issue was when i tried to restore, all forum was scrued up. No tables, errors and so on. Maybe because i do not use english language. as you say. I informed developer too.


Any way thanks.

[adkaush]

Advise not to use this product if you have a forum that goes from 1GB database, I recommend you look for something like mysqldump

How do you get that to work? Where to install it? Total newb here, please advice. Thanks!

[Paul M]

If you bothered to look, you would know this has the option of using mysqldump as well.

[X-or]

Are you talking about this?
v4.2.0.2 : 25-Nov-2013 : Fix php 5.3 deprecated warnings, added experimental mysqldump backup.

Dear Mr Paul M, we just can rely on experimental products for something as important as database backup.

With all due respect for the quality products you made available for everyone free of charge, this one particular product is a failure. It's your right to not fix it, I respect that, but please move it to the graveyard instead of risking compromising users databases.

[Paul M]

No.

If you dont want to use it, move on.
Its not a failure nor does it compromise anything.
So far I have tolerated your silly remarks, that stops now.

[tokads3]

Hello,

Sorry for my average English, I installed this mod on our forum and when I want to run the task, I get this error message

syntax error, unexpected 'new' (T_NEW) on line 18 in /home/*****/public_html/includes/cron/cronbackup.php
#0 {main}

We are in version 4.2.5 and php7.0

Thank you for your help

[Paul M]

Was that from the latest version above ?

That seems like something removed a while ago, but I have no way to check atm, as im on holiday.

[tokads3]

Thanks for the reply, I installed the mod again and it worked, thanks

[barnsi]

We are using this mod since the first day our forum started in 2011 and it is still working with vB4.2.5 and PHP7.

One thing i never could fix: gzip-Compression is not working, i always get this Error in apache-log:
"gzip: command not found"
mod_deflate is active.
What can i do to tell apache to use deflate?