vb.org Archive - Administrative and Maintenance Tools - vBulletin Cron Based Database Backup

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 and this: https://www.vbulletin.com/forum/show...265#post310265 You will need to talk to your host about this in order to get it resolved.

Paul M

01-02-2015 11:38 AM

Quote:

Originally Posted by Mariner1 (Post 2530010)

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/c...cron&cronid=95
Referrer : http://www.xxxxxxxxxxxx.com/admincp/....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

01-11-2015 06:00 AM

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

Paul M

01-11-2015 08:20 PM

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

01-20-2015 04:43 PM

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

Paul M

01-20-2015 06:12 PM

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

ebp123

01-23-2015 06:51 AM

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

01-23-2015 02:38 PM

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

Quote:

vBulletin Cron Based Database Backup

Quote:

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

01-23-2015 06:33 PM

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.

All times are GMT. The time now is 08:55 PM.

Page 102 of 107

102

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02187 seconds Memory Usage 1,740KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: