Web Hosting Talk







View Full Version : Help transfering Mysql databases to new webhost.


sblugh
06-01-2006, 10:05 PM
Hi every one,
I'm a real newbie. I hosted my organisation's website on micfo for the last two years. We are now trying godaddy because of inconsistent e-mail service.
The problem is however that I have to transfer 4 PHP MySql databases to the new account at godaddy.
I have no clue of the steps that i need to take. The four dbases were installed using fantistico and everything was automated. I don't want to lose the data in the forum, guestbooks and calendar that I already have.
Can you help me?

Dan Grossman
06-01-2006, 11:07 PM
Do you have access to phpMyAdmin on both hosts? Export from one, import to the other.

Sorry to say it, but you'll probably regret switching to GoDaddy.

Oceanworld
06-01-2006, 11:14 PM
micfo should be using Cpanel, so if Godaddy is also using Cpanel(which I don't think so), it'll be really easy to switch.

riverpast
06-01-2006, 11:18 PM
Use mySQL Front. Open both database, and do a Extra | Transfer.

sblugh
06-03-2006, 02:20 AM
No Godaddy doesn't have cpanel. It does have phpMyAdmin.
So I export in sql format and then import the text file with sql on the new site right?
That simple?

SmilieBG
06-03-2006, 06:19 AM
Basicly yes. Unless (here it comes) database larger is then 8 MB, as most hosting company's leave PHP limit for 8 MB upload. It should say it in PHPMyAdmin on the page where you are doing import.

There is a bit messy work around and it is to manually split exported file into more smaller ones (within 8 MB). Or export fewer tables per database, not reaching 8 MB.

If none of your DB's is over 8 MB, then it is really easy. As said: export on old host and import on new one.

Cheers,
Aleks

sblugh
06-04-2006, 12:36 AM
Thanks for the help.

I was able to do it.