vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Administrative and Maintenance Tools - vBulletin Cron Based Database Backup (https://vborg.vbsupport.ru/showthread.php?t=231481)

DemOnstar 07-15-2013 01:29 PM

By default, where are these backups stored?

If I create a folder at the forum root and name it 'backup', what might the correct path read?

Grats...........

DemOnstar 07-17-2013 08:14 AM

Ok. Created a file (backups) at forum root (www) localhost..

Next, I used ./backups as my path...

Went to cron/Run Now

Code:

Processed Database in 1.513 seconds

Backup Completed Successfully
Done

Went to ./backups and found nothing there....

Which way did it go? Thanks all...

Edit: Nevermind.............got it now.

./backups/ works for me...

Ta.

WorldCraft 07-24-2013 10:41 PM

When I try to restore one of these backups via SSH, I get the following error

ERROR 1265 (01000) at line 100114: Data truncated for column 'method' at row 1

An other backup I tried I got the same error but at column 'datastore'

Running vBulletin 4.2.0 with innoDB setting enabled as I do have a few tables in this format.

Any ideas??

Paul M 07-25-2013 12:04 AM

What commands are you actually using to restore ?

WorldCraft 07-25-2013 03:45 AM

Quote:

Originally Posted by Paul M (Post 2435223)
What commands are you actually using to restore ?

mysql -u username -p databasename < /path/to/backup.sql

Paul M 07-26-2013 06:59 PM

Never tried that way before, no idea if it makes any difference, but try ;

mysql -u username -p

then once logged in

use databasename;
source /path/to/backup.sql

tbworld 07-27-2013 12:36 AM

@Paul, this is the only released MOD I actually run on my system. I have made a few changes for my particular situation, but in the early days of running, understanding vbulletin this mod saved my butt. Thanks for the continuing support for all these years. I use this as a third backup system, in case my transactional system fails. <grin>

Travis641 08-12-2013 11:28 AM

I just wanted to post to those having trouble with getting gzip to work, but are sure it is installed on their server, make sure that the exec command is not disabled in your php.ini.

I was having the same issue until I ran the gzip command separately in another php script to troubleshoot and it returned the "exec is disabled per safety reasons" error.

hunter22375 08-12-2013 02:26 PM

I have this mod installed and it was working just fine until I moved servers. Now, it doesn't work. I havn't changed anything so I am confused....any ideas on where to begin? Thanks in advance.

smirkley 08-13-2013 03:53 AM

Yes, quit moving servers.


All times are GMT. The time now is 06:58 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01858 seconds
  • Memory Usage 1,735KB
  • 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
  • (1)bbcode_code_printable
  • (1)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