Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 09-03-2003, 04:54 PM
EVO VIII Chris EVO VIII Chris is offline
 
Join Date: Aug 2003
Location: Portland, OR
Posts: 46
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default How do I restore my SQL database on my own server?

This is a simple question I have but I do not know how to do it. I run my own server out of my home and I am simply wondering how I restore my vBulletin MySQL database. I tried to using phpmyadmin but the file is so huge it timesout after like 30 seconds. Since this is my own server I obviously dont need to use Telnet so I am wondering how I go abotu restoring this. I would really, really appreciate it if someone could give me a step by step walkthrough as I am not to knowledgeable with programming code and DOS and what not.

Thanks!
Chris
Reply With Quote
  #2  
Old 09-03-2003, 05:26 PM
lasto lasto is offline
 
Join Date: Jan 2002
Posts: 1,514
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

phpmyadmin crashes out after 1.5 meg (cant handle files any bigger)

If your host allows outside connections use this program

MYSQLFRONT - (put name into google cause its listed everywhere)

now enter username and pass /ip and database name and you can export it to your comp or import it.

If you are running the server on your comp then still use same program - does the job just as good except your ip will be localhost.

LInk - to mysqlfront

http://mysqlfront.venturemedia.de/in...t=ST&f=2&t=328

let us know how u get on
Reply With Quote
  #3  
Old 09-03-2003, 05:41 PM
SmEdD's Avatar
SmEdD SmEdD is offline
 
Join Date: Mar 2003
Location: Ontario, Canada
Posts: 381
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 02:26 PM lasto said this in Post #2
phpmyadmin crashes out after 1.5 meg (cant handle files any bigger)
Since when? I've uploaded a db that was just under a gig. It took a long ass time but it still went.

@EVO VIII Chris What OS are you useing?
Reply With Quote
  #4  
Old 09-03-2003, 05:43 PM
EVO VIII Chris EVO VIII Chris is offline
 
Join Date: Aug 2003
Location: Portland, OR
Posts: 46
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Im using Win 2k
Reply With Quote
  #5  
Old 09-03-2003, 05:43 PM
assassingod's Avatar
assassingod assassingod is offline
 
Join Date: Jul 2002
Posts: 3,337
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 07:41 PM SmEdD said this in Post #3
Since when? I've uploaded a db that was just under a gig. It took a long ass time but it still went.
How did you manage that? phpMyAdmin always times-out
Reply With Quote
  #6  
Old 09-03-2003, 05:46 PM
EVO VIII Chris EVO VIII Chris is offline
 
Join Date: Aug 2003
Location: Portland, OR
Posts: 46
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

So what exactly does MySQLFront do since I am having a hard time understanding what exactly it does that phpmyadmin doesnt. I dont even know why they call it phpmyadmin it seems like it has nothing to do with php anyways. Well does anyone know perhaps if there is just a way for me to do this via DOS or something instead of having to DL a program, Ive got way to many programs on my computer its to hard to keep track of them all.

Chris
Reply With Quote
  #7  
Old 09-03-2003, 06:08 PM
lasto lasto is offline
 
Join Date: Jan 2002
Posts: 1,514
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

you cant upload 1 gig using phpmyadmin

i dont claim to know much and was only offering my help in here and mysqlfront is a top program but i have never heard of phpmyadmin doing 1 gig files LOL its total crap for anything but the basic stuff

Edit

well i suppose you could do it if the file was cut into different smaller sizes but are we talking 1 gig 1 file ?

also mysql is so easy m8 if you cant be bothered to download it then its your loss.Ive used it from day 1 since someone recommended it to me and now im doing the same.You want things that are easy well theres your choice.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:55 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.05081 seconds
  • Memory Usage 2,215KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete