vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Programming Articles (https://vborg.vbsupport.ru/forumdisplay.php?f=188)
-   -   Tutorial: How to make a reliable database backup (https://vborg.vbsupport.ru/showthread.php?t=39558)

N9ne 08-31-2002 03:38 PM

windows XP

Reinstall what? SecureCRT?

N9ne 08-31-2002 05:45 PM

OK I just noticed something, after I type in the password and hit enter, it doesn't do anything but after a while comes up with the bash thing, after doing that I checked the backup folder and a backup was present! So the 20 minutes you say it takes was misleading, even though I have 50k posts, 5k threads, 1k members in my DB :p

great tut TECK, it's a very fast way of backing up.

One Question: Is this the equivalent of downloading the database everytime from the adminCP? Does this contain the exact same information, all users, posts, threads, template edits, stylesets etc?

TECK 08-31-2002 10:03 PM

it depends on your database size. if you have a small database, ya is fast. but on a large site it can last even 30min, so is not misleading.
I specified this clearly in the tutorial:
Quote:

NOTE: If you have a large database, it might take up to 20 minutes until your backup is done. Relax and smoke a cigarette or grab a snack.
When done, you will see in the SecureCRT window, the command prompt.
You will not see the prompt until the backup is done.
for your question, yes. it does contain all the time all data stored in your database. and the bigger is your database to higher will be the lap time until you complete it.

N9ne 09-02-2002 02:59 AM

I'm on broadband, should it be fast? It only takes me about 40 seconds to backup but if I download the DB from the AdminCP it's about 70MB however when I dump it it's only 38MB :confused:

TECK 09-02-2002 07:01 AM

i'm talking about databases that are 1gig. 70mb is really small.

Tim Wheatley 09-28-2002 05:14 PM

How can I import someone elses VB into mine without losing eithers posts?

TECK 09-28-2002 09:22 PM

there is no way to do this, until now. if i understood correctly, vB team works on a project like that...

Tim Wheatley 09-29-2002 09:28 AM

So I'd likely have to import the db table itself into a sub table, then transfer what I could by hand?

I'm more at home with the database than I am php code, I believe I could get some done.

Visionray 11-27-2002 02:02 AM

Trying to get this to work.

When I log on to CRT, I don't get [USERNAME HOSTNAME]$ _

I get
bash-2.04*$

Anyways, when I type in the mysql bla bla, it says

"no such file or directory exists.

This is the path Im typing
home/virtual/site376/fst/var/www/html/backup/blablabla.sql

This is the exact info I was given from the info.php file.
I know the directory is there, I can see it on my server, but CRT isn't recognizing it.

Any ideas?

JakeC 01-11-2003 07:54 PM

Should I turn off the board first? I've heard it both ways and I'm not sure if this is required or not. Thanks.

JakeC


All times are GMT. The time now is 11:51 PM.

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

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01801 seconds
  • Memory Usage 1,732KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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