vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Auto backup (https://vborg.vbsupport.ru/showthread.php?t=34471)

DelusionalMind 01-25-2002 06:02 AM

I was thinking it would be cool if there was a hack that would automatically backup your forums on the server at a specified interval

I haven't found this hack so far, but if it exists, don't yell at me

So what do you guys think?

FWC 01-25-2002 06:24 AM

If you are on a *nix box you just need to set up a cron job or two. My board backs up every 12 hours automatically. I just set up two cron jobs to run the appropriate mysqldump.

DelusionalMind 01-25-2002 11:03 PM

how do i set up the cron job?

i have the feature on my server, yet i don't know how to use it. hehe

help? :confused: :confused: :confused:

heh. thanks

DelusionalMind 01-26-2002 05:48 AM

anyone? :stupid:

FWC 01-26-2002 06:13 AM

If you enter:

0 0 * * * mysqldump --opt -udatabaseusername -pdatabasepassword databasename > /path/toyour/backupdirectory/backup.sql

It will backup your database at midnight every day. Obviously, you have to replace databaseusername, databasepassword, and the path with your values. Change the second 0 if you want to change the hour. It's 24 hour time. :)

DelusionalMind 01-26-2002 08:55 PM

thanks :)

FWC 01-26-2002 09:07 PM

No problem. :)

buster 02-16-2002 10:30 AM

does anyone know why - when using the admin page resulting output is 23 meg while using above cron method its 13 meg.

Is it because something needs to adjusted in my config or is vbulletins admin page doing the backup in a different way.

Scott MacVicar 02-16-2002 11:01 AM

If i remember correctly the vBulletin adds alot of comments in the sql output and some whitespace, not sure if this can accomodate for 10mb though, there is usually only a couple 100kb difference.

Are you selecting all the tables in the admin panel?

buster 02-16-2002 11:08 AM

Yes - all options are at yes.

I also assume that the difference is that the sqldump command simply takes the complete database - while the vbulletin php script does it category by category.

Still a bit puzzling though.

Just redid it to verify and result is exactly like that. The database is 200 users and 12000 posts with a few custom avatars.

I don't know enough about the innards to know if it is a cause for worry. Guess I will have to do a parallel installation and restore it to see.


All times are GMT. The time now is 12:34 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.01060 seconds
  • Memory Usage 1,720KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete