vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Community Lounge (https://vborg.vbsupport.ru/forumdisplay.php?f=13)
-   -   Backing up your localhost database--how?? (https://vborg.vbsupport.ru/showthread.php?t=39868)

Velocd 06-15-2002 05:39 AM

Backing up your localhost database--how??
 
I have Vbuleltin installed on my computer localhost, but I have one problem--backing it up! I have tried using telnet and putty to backup my database but It gives me an error saying my computer rejected the connection. My guess is you can't do it. So is there an alternative way maybe? I'm not sure whether or not downloading a .sql file from the AdminCP is reliable or not even if its just my localhost.

SaintDog 06-15-2002 05:55 AM

If you have phpMyAdmin installed, you can download a backup of the database which vBulletin uses. If you do not have it installed or do not wish to install it, you can use the backup from the admin control panel. I have used a backup from the Admin CP many times and they are as reliable as phpMyAdmin is.

- SaintDog

Admin 06-15-2002 06:22 AM

Follow step 1:
http://www.vbulletin.com/manual/movingservers.html

Velocd 06-15-2002 03:57 PM

Heh, FireFly you seemed to misunderstand my scenario in Post #1, because I'm on a localhost, as in I've got Vbulletin installed on my computer. When I try to use telnet or putty to make connections to my localhost, in order to make a backup, my computer refuses connection. My guess is that you can't make telnet connections to your computer (it seems logical). Is there anyother way of backing up?

And restoring from phpmyadmin when you have a large database I've heard is not the safest thing to do..then again, I'm on localhost so maybe it will be fine. ;)

Logician 06-15-2002 09:33 PM

(For Windows: )

MSDOS Prompt(/cmd), go into MYSQL/bin dir and run this command:

mysql dbname > backup.sql

It can take sometime, after it finished you'll find the file backup.sql in your mysql/bin dir

fla5h 03-10-2003 09:06 PM

Sorry to jump on this thread as it is old but I thinnk its relevant.

Logican is there a way of restoring a sql backup to a localhost machine in a similar way ?

Thanks

filburt1 03-10-2003 10:01 PM

<a href="http://www.vbulletin.com/manual/movingservers.html" target="_blank">http://www.vbulletin.com/manual/movingservers.html</a>

It's identical whether it be Linux, Unix, OS X, Windows...

fla5h 03-11-2003 02:53 PM

thanks filbert, dont know a thing about SSH or Telnet, guess I'll have to find a dummies guie to doing it ?

think this is what I wanted though, same as what logican posted.

but the command is

mysql dbname < backup.sql


All times are GMT. The time now is 01:41 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.01008 seconds
  • Memory Usage 1,719KB
  • 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
  • (8)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