vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   I've got an old .SQL file of my database and.... (https://vborg.vbsupport.ru/showthread.php?t=63932)

split-vizionz 04-15-2004 11:50 PM

I've got an old .SQL file of my database and....
 
I got the .sql file that I recieved when I was backing up my forum awhile ago... My site shut down for awhile and now Im having a brainfart. I want to ressurect it on vbulletin 3.0 but where do I upload the sql file to so that it will bring back my old database? like where within the server? keep in mind that this file is from an older version of vbulletin, will it still work.

djnoz 04-16-2004 12:13 AM

Here's what to do..

Upload the old sql file to a directory on your server (preferably outside the web directories - for security reasons)

Create a new, blank database or clear out an existing one.

Go into SSH and type the following command

mysql -u [mysql username] -p [.sql filename] > [name of database you created/cleared]

This restores the contents of the SQL file into the database.

Now download vb3, edit the file at includes/config.php, upload everything into your web directory and run the upgrade script, this will convert your forums to vb3.

split-vizionz 04-16-2004 12:27 AM

your the man! thanks for the help!

split-vizionz 04-16-2004 02:06 AM

is that the same way you do it onm a windows server? or is that strictly for linux

filburt1 04-16-2004 02:14 AM

It is effectively the same on Windows, although be sure to note that mysql.exe is in MySQL's bin directory and not in the path by default.


All times are GMT. The time now is 11:00 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.01019 seconds
  • Memory Usage 1,708KB
  • 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
  • (5)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