Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > General Hosting/Server Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Need help in moving large database to new server Details »»
Need help in moving large database to new server
Version: , by jayunsplanet jayunsplanet is offline
Developer Last Online: Dec 2014 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 01-15-2008 Last Update: Never Installs: 0
 
No support by the author.

A little background:
I run a forum for automobile enthusistast in Maryland.
www.mdstreetscene.com
www.mdstreetscene.com/forum
~2,000 users. 400 active. Maximum of 25 users online at any given time.
Shared Premium Hosting account w/ PHP/Perl w/ GoDaddy (yea yea, there's your problem, blah blah, I know)

Starting December 27, 2007, the forums, at various times, have been extremely slow. On that day the server load average hit 34.79 24.60 20.74 with 8 Users Online. I realize that those averages show the entire server, not just my site. Since that day, the load averages have hit 12.xx at various times. It will take 10-12 seconds (or sometimes longer) for the AdminCP to load or to do a "New Posts" search. About the same time to read a thread. Then again, sometimes the forum will be perfectly fine. However, even when the forums slow to a crawl, the averages may only be 2.x I have contacted GoDaddy and they say "everything" is as normal. I contacted them the other night, and they asked me to do a Trace Route to my site and send the results to them. I did it just to appease them. Well, the traceroute is going to mdstreetscene.com (the html site). The database is on http://mysql47.secureserver.net/ So I don't quite know how that is going to help them diagnose the problem. They probably just want to say that it's on my end with too many hops or something.

Anyway, I want to stop using GoDaddy for the database/forum part. They are alright for file hosting (I have 200GB of storage w/ 2TB of bandwidth. And my download speeds are ~750kb/s)

I have acquired a Virtual Server with Windows Administrator access. (I can install whatever program I want/need) I am running Apache w/ MySQL, PHP, etc. I want to upload/put my 400mb database on this server. I don't quite know how to do it. What file type should I be uploading and where? Using what program? I assume I would have to copy the actual vBulletin forum files to the new server too? That's fine, it'll take awhile, but it's doable.

Is there a way I can use a brand new vBulletin forum installation (which I currently have on this virtual server), and just add my database info such as users, posts, threads, and PM's? This way I kind of have a fresh start and I can build it up.

I know this may be a lot to ask, but thanks for any help you can give.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #12  
Old 01-18-2008, 04:13 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

mysql -uroot -p mdssvbulletin1 < C:/web/htdocs/mdssvbulletin.sql
Reply With Quote
  #13  
Old 01-18-2008, 09:05 PM
jayunsplanet jayunsplanet is offline
 
Join Date: Jun 2006
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I got this error @ the 89.8mb mark
ERROR 2006 (HY000) at line 1350359: MySQL server has gone away
Reply With Quote
  #14  
Old 01-18-2008, 09:32 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You need to check the mysql log file for what caused it, if nothing is there, you may need to tweak my.cnf and restart mysql, its most likely a default my.cnf from the install with nothing in it.
Reply With Quote
  #15  
Old 01-22-2008, 07:45 PM
Xorlev Xorlev is offline
 
Join Date: May 2006
Location: Colorado
Posts: 54
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by FRDS View Post
Windows hosting is just as reliable and secure as *nix hosting. Its the admins that run the servers that are the issue most the time.
Oh man, I haven't heard that good of a joke in ages. You should really be a stand-up comedian.
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 10:48 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.04723 seconds
  • Memory Usage 2,241KB
  • Queries Executed 21 (?)
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)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (4)postbit
  • (5)postbit_onlinestatus
  • (5)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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete