Changing Hosts - Reloading vB

[bexie]

*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!

[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!

[DenzoForums]

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?

[bexie]

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.

[NTLDR]

Do you have SSH on the server you are trying to move the database too?

[bexie]

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

[NTLDR]

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.

[bexie]

I've discovered the backup/restore feature in Cpanel. Do you suggest this as an effective way of getting this database transferred?

[bexie]

*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*

[bexie]

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!

[bexie]

...*HITS HEAD*

One more question, then.

The orginal db had 44 tables. This new one has 17.

...?!?

[NTLDR]

I've never used the backup options in cPanel I'm afraid. Does cPanel give any messages/warnings when doing the restore?

[bexie]

No, it doesn't.

I ended up just throwing it over there table by table. I don't suggest anyone do this EVER because it SUCKS when it doesn't work, and you have to copy it all by hand and...gah. [/rant]

Thanks for the help, guys!

[Mudusa]

Hey bexie,

We had the same problems. Upgraded to vB 3 and then moved to a new server 3 days later. (I don't recommend doing this!)

Issues we had: our old site didn't use cPanel, we were on dialup, and there was a maximum-transfer size limit.

I tried sweet-talking the old host into doing the backup for me, because it failed time and time again. They did, but even with specific instructions, they repeatedly performed it all in .myd.myi file formats when I needed it in .sql.

Explained the situation to my new host, (which I would recommend to anyone, for the excellent tech support) They spent about an hour trying to access the old phpMyAdmin to do a dump and kept failing. They requested that I ask the server to transfer the full database contents (structure and data) to a file in the main directory and even then it took them almost half an hour to do the transfer, but it was installed smoothly and without a hiccup.

If you haven't been able to do the full database transfer, I'd suggest calling new host and requesting a direct server-to-server transfer.

Mudusa