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 04-27-2004, 03:08 PM
bexie bexie is offline
 
Join Date: Jun 2003
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Changing Hosts - Reloading vB

*waves* Hey guys, hope you can help me out here.

I'm in the process of switching hosts for my vB. All is going great, except moving the database itself. The backup was perfect, no worries there. The problem is reloading the database into the new host.

I created a new database with the same name and user. I then used phpmyadmin, and uploaded the backed-up database. It goes great, until it gets to 100% and then freezes. Nothing happens, no change. I've tried over and over, and I get the same results.

I'm running on PHP4, using localhost, blah blah, I don't have any idea what type of information you'd need for this, lol. If you could help me out, that'd be great. Thanks!
Reply With Quote
  #2  
Old 04-27-2004, 03:12 PM
bexie bexie is offline
 
Join Date: Jun 2003
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quick update: I just got this notice:

Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php on line 77

...D'oh!
Reply With Quote
  #3  
Old 04-27-2004, 03:14 PM
DenzoForums DenzoForums is offline
 
Join Date: Apr 2004
Posts: 73
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by bexie
Quick update: I just got this notice:

Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php on line 77


...D'oh!
contact the host.. see if they can help..
What host are you using anyway? are you dedicated, or on shared?
Reply With Quote
  #4  
Old 04-27-2004, 03:18 PM
bexie bexie is offline
 
Join Date: Jun 2003
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm using a dedicated Hostdime. They're helpful, but I do suggest THAT NO ONE USE THEM for vB. They're down every 2. effing 2 seconds...*twitch* I'm switching to a reseller plan on Netrillium.
Reply With Quote
  #5  
Old 04-27-2004, 03:26 PM
NTLDR's Avatar
NTLDR NTLDR is offline
Coder
 
Join Date: Apr 2002
Location: Bristol, UK
Posts: 3,644
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do you have SSH on the server you are trying to move the database too?
Reply With Quote
  #6  
Old 04-27-2004, 03:35 PM
bexie bexie is offline
 
Join Date: Jun 2003
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Cripes, I think so. Don't most hosts have that? But I didn't see it on the list...then again, I could be a fool of a Took, considering I don't even know what SSH is. Heh. *idiot*

Here's Netrillium's list of what I have:

True CGI Support
Server Side Includes
Sendmail Support
Perl 5.6.1
MySQL 3.23.56
PhpMyAdmin
PHP 4.3.3
.htaccess Abilities
Custom Error Pages
Free Script Installations
Reply With Quote
  #7  
Old 04-27-2004, 03:39 PM
NTLDR's Avatar
NTLDR NTLDR is offline
Coder
 
Join Date: Apr 2002
Location: Bristol, UK
Posts: 3,644
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you have cPanel there maybe an option to request SSH access in it if they allow it. Thats the best and most reliable way to import your database.
Reply With Quote
  #8  
Old 04-27-2004, 03:49 PM
bexie bexie is offline
 
Join Date: Jun 2003
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've discovered the backup/restore feature in Cpanel. Do you suggest this as an effective way of getting this database transferred?
Reply With Quote
  #9  
Old 04-27-2004, 04:04 PM
bexie bexie is offline
 
Join Date: Jun 2003
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

*twitch* Nevermind, this doesn't work either--it just takes my backed-up database and does some...really weird crap with it.

*searches endlessly for SSH*
Reply With Quote
  #10  
Old 04-27-2004, 04:23 PM
bexie bexie is offline
 
Join Date: Jun 2003
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

AHH! Woo, I got it! Finally Thanks to Lee and DenzoForums for your help!

Just incase anyone else would like to know how I did this....

1. Make sure you're using Cpanel for your current and new host.
2. Go to "Backup" on the Cpanel of your current host.
3. Under Download a MySQL Database Backup, click the database you want to move.
4. Download it wherever you want on your computer.
5. Go to your NEW SERVER'S (where you're moving the database to) cpanel.
6. Click "Backup"
7. Find Restore a MySQL Database
8. Browse for the databse you saved, and click "Upload"
9. Done!

Thanks again, guys!
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:25 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07313 seconds
  • Memory Usage 2,251KB
  • Queries Executed 11 (?)
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
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_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