vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   2.3 Daily Backup (https://vborg.vbsupport.ru/showthread.php?t=55990)

gsk8 08-07-2003 11:55 PM

2.3 Daily Backup
 
Is there a good hack that can do this while you sleep?

Erwin 08-08-2003 12:52 AM

Just use a cronjob to copy your database files and php files to a backup directory. That's what I've been doing. You would need access to SSH.

Gary King 08-08-2003 01:36 AM

Might help:

http://www.vbulletin.com/forum/showt...highlight=cron

Dean C 08-08-2003 09:33 AM

I don't know how it's done but I asked my host to set up a daily cron to backup my database at midnight every night :)

- miSt

gsk8 08-09-2003 10:37 AM

Mist, who is your provider? They actually did it? No charge or hassle?

Dean C 08-09-2003 08:46 PM

I have my contacts so no ;)

joeboo 08-10-2003 05:58 AM

I dunno, i've heard that using cron jobs isnt such a good idea. If users are online at the same time that the backup is downloading, it can corrupt or delete something. In my case, it deletes random threads and users if I have the cron job on. :/

Erwin 08-10-2003 06:58 AM

Quote:

Today at 05:58 PM joeboo said this in Post #7
I dunno, i've heard that using cron jobs isnt such a good idea. If users are online at the same time that the backup is downloading, it can corrupt or delete something. In my case, it deletes random threads and users if I have the cron job on. :/
Backing up using cron jobs or any other method will always have some small risk in it if you keep your forums open during the backup. If you automate your backup, then obviously you are expecting to keep your forums online at that time as well. You minimize problems by backing up during off-peak times.

For myself, instead of exporting the database, I backup the actual mysql database files. :)

wooolF[RM] 08-10-2003 10:28 AM

]
Quote:

Today at 10:58 AM Erwin said this in Post #8 For myself, instead of exporting the database, I backup the actual mysql database files. :) [/B]
Can we please get some more details?

example of how do *I* backup my database (+250Mb w/o any attached files)

[high]mysqldump --opt -h localhost -uuser -p database_name | gzip -c --best > `date +%d_%m_%y`.Forum.SQL.gz[/high]

Worked fine in past 1.5-2 years... We moved twice and both times import/export worked flawessly

wooolF[RM] 08-11-2003 09:25 AM

*bump*


All times are GMT. The time now is 07:03 PM.

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.01971 seconds
  • Memory Usage 1,727KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (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