vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Restoring a Database (https://vborg.vbsupport.ru/showthread.php?t=64924)

Super Shadow 05-09-2004 07:46 PM
Restoring a Database
 
Hey,

I have a .sql database backup of my boards, since they crashed a little while ago. I was wondering if anyone could direct me as to how to restore the database using this backup file... Someone's told me I might encounter a few problems, seeing as the .sql file is 95.3 MB... :surprised:

Thanks in advance :nervous:

- Alexandre

Infopro 05-09-2004 08:41 PM
mysql -u myname_myname -p myname_databasename < /home/I/Backedup/The/DB_Import/Here/bkMay_09_04.sql

95.3 MB is not a big deal at all.
HTH

Fluous 05-09-2004 09:40 PM
ermm...i was wondering the same thing just incase. but what you just said sorta clucked my mind infopro. sorta care on explaining more? lol

Velocd 05-10-2004 03:15 AM
Download putty:
http://www.chiark.greenend.org.uk/~s.../download.html

Enter your host, and make sure SSH for protocol is selected.

It will prompt you for your server username and password.

Once logged in, run the command given by Infopro above.

Another thread for reference:
https://vborg.vbsupport.ru/showthread.php?t=39558

Super Shadow 05-13-2004 11:47 PM
Thanks a lot, Velocd, but I downloaded putty, set in the login, but it won't let me write in my password... I'd be typing on my keyboard, but nothing actually shows up on screen. What's with that?.

EDIT: Looked at the thread you posted, and I decided to try out Secure CRT 4.1 Only thing is that, it gives me an error whenever I try to connect. It says I don't have Shell Access enabled... Is that at the server?

ctsolutions 05-14-2004 10:13 PM
Quote:
Originally Posted by Super Shadow
Thanks a lot, Velocd, but I downloaded putty, set in the login, but it won't let me write in my password... I'd be typing on my keyboard, but nothing actually shows up on screen. What's with that?.


EDIT: Looked at the thread you posted, and I decided to try out Secure CRT 4.1 Only thing is that, it gives me an error whenever I try to connect. It says I don't have Shell Access enabled... Is that at the server?

first off all,did your host enable ssh for you ?


CtSolutions


All times are GMT. The time now is 08:15 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.01082 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)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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