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)

doogie88 04-05-2014 06:28 PM

I found about 40gigs of backups for everyday for the last year. Is there any way to delete them automatically after a few days?

Skyrider 04-21-2014 02:28 PM

Quote:

ERROR 1062 (23000) at line 3555885: Duplicate entry '37560' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555886: Duplicate entry '37561' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555887: Duplicate entry '37562' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555888: Duplicate entry '37563' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555889: Duplicate entry '37564' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555891: Duplicate entry '37565' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555892: Duplicate entry '37566' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555893: Duplicate entry '37567' for key 'PRIMARY'
ERROR 1062 (23000) at line 3555894: Duplicate entry '37568' for key 'PRIMARY'
Quote:

ERROR at line 3555919: Unknown command '\"'.
ERROR at line 3555919: Unknown command '\"'.
ERROR at line 3555919: Unknown command '\"'.
ERROR at line 3555919: Unknown command '\"'.
When I attempt to 'import' a database through shell.. Used this cron to make a backup. The duplicate entry errors, getting tons of them... And with tons, I mean thousands (and more). Importing it into an empty database. What exactly is wrong?

EDIT:

There's more...

Quote:

ERROR 1064 (42000) at line 3555895: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '37569','-1','viewing_users_album','wol','Viewing User\'s Album','vbulletin','vBu' at line 1
Quote:

ERROR 2005 (HY000) at line 3555919: Unknown MySQL server host 'size="2">A' (1)
ERROR at line 3555920: Can't connect to the server

bzcomputers 04-21-2014 06:56 PM

Quote:

Originally Posted by doogie88 (Post 2491683)
I found about 40gigs of backups for everyday for the last year. Is there any way to delete them automatically after a few days?

Under options:
Combine Files set to: Yes
Date Format enter: D
GZip Files: Yes

This will save your backups like this:
Prefix-Mon-Full-Backup.sql.gz
Prefix-Tue-Full-Backup.sql.gz


....this way you will only have 7 daily backups (one for each day of the week) that will overwrite each other the following week.

Soapchick 04-27-2014 07:17 PM

Paul M, I can't tell you how many times this mod has saved my butt. The backups work perfectly with bigdump. I just wanted to say thank you.

Pyanepsion 05-28-2014 03:41 PM

Hi,

I installed Auto-Backup for Vbulletin 4.2.2 patch level 1 but that doesn't work. When I start instant backup this message error appears :

Backup Error : Could not write to destination file ( ../../backups/wmp-2014-05-28-Full-Backup.sql )

You can see my configuration on there screnshots :
http://img11.hostingpics.net/pics/578120backup.jpg
http://img11.hostingpics.net/pics/391972backup2.jpg

RichieBoy67 05-28-2014 04:07 PM

Quote:

Originally Posted by Pyanepsion (Post 2499798)
Hi,

I installed Auto-Backup for Vbulletin 4.2.2 patch level 1 but that doesn't work. When I start instant backup this message error appears :

Backup Error : Could not write to destination file ( ../../backups/wmp-2014-05-28-Full-Backup.sql )

You can see my configuration on there screnshots :
http://img11.hostingpics.net/pics/578120backup.jpg
http://img11.hostingpics.net/pics/391972backup2.jpg

Check your file permissions. Usually that folder has to be set to chmod 777 so it can be written to. Either that or your file path is wrong. And you do not need to put the name of the file in the file path if that is what you did..

Go into Vbulletin under maintanance, phpinfo and get your path there. Yours is wrong.

Pyanepsion 05-28-2014 04:48 PM

The visible path was not good. Thank you very much RitichieBoy67.

RichieBoy67 05-28-2014 05:10 PM

Quote:

Originally Posted by Pyanepsion (Post 2499814)
The visible path was not good. Thank you very much RitichieBoy67.

My pleasure. :)

tironcitironci 05-29-2014 09:12 PM

Warning: Assigning the return value of new by reference is deprecated in ..../includes/cron/cronbackup.php on line 18
Backup Error : Could not write to destination file ( ../backups/2014-05-29/Forum-2014-05-29-Access.sql )

i got this :/

Paul M 05-30-2014 12:03 AM

You need to update to the latest version (4.2.0.2).

Quote:

v4.2.0.2 : 25-Nov-2013 : Fix php 5.3 deprecated warnings, added experimental mysqldump backup.


All times are GMT. The time now is 12:43 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.02095 seconds
  • Memory Usage 1,746KB
  • 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
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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