Moving Databases

Postaldude · #1 01-19-2008, 09:51 PM

Anyone here have any experience with importing databases? I tried to import my database from my old webhost but it seems to give me an acess error and wont completing import the database. Anyone can help me with this?

Postaldude

JeremiahB · #2 01-19-2008, 10:23 PM

Hi Postaldude,

What database are you trying to import from to, including versions etc..
What are the errors will be helpful as well in figuring out what went wrong.

Thx

gtgeorge · #3 01-20-2008, 07:06 AM

Also might want to post what the DB size is.

Sam · #4 01-20-2008, 07:08 AM

It sounds like your database dump is large, so phpmyadmin timesout.

If you ticket support, they will import it for you.

Postaldude · #5 01-20-2008, 09:07 AM

what i did was upload the database file, onto my domain and told support where it was and also gave them the name of my previous database on the old server so that they could recreate that. Is that the right procedure?

Sam · #6 01-20-2008, 09:10 AM

Quote:

Originally Posted by Postaldude

what i did was upload the database file, onto my domain and told support where it was and also gave them the name of my previous database on the old server so that they could recreate that. Is that the right procedure?

Yes, upload the .sql file to your account with HG and tell them what database you want it imported into and the path to the .sql file

Postaldude · #7 01-20-2008, 09:13 AM

alright, i guess its good to go then. how long does this normally take? im kinda of sad at the moment since my site is like dead lol. i guess ill just take the my time and make sure all the files are ftped into HG.

calum · #8 01-20-2008, 09:51 AM

They shouldn't take more than an hour, normal tickets seem to take around 30 mins for me.

Live chat might be able to do it for you instantly, but I am not sure, they might just tell you to ticket support.

Postaldude · #9 01-20-2008, 09:54 AM

oh cool thx for the info.

Postaldude · #10 01-20-2008, 01:13 PM

If i have all the same files from my old webhost and a database containing all the tables should my site load up like how it use to?

GvilleRick · #11 01-20-2008, 01:15 PM

Did your old host use cPanel? If so then you should ask HG to transfer the account over. That would include all databases, email accounts, etc. You can make the request at https://secure.hostgator.com/transfer.php.

Postaldude · #12 01-20-2008, 01:23 PM

how long would that take? i dont know what domain and IP to put in for my old host, since the domain now points to my HG account.

GvilleRick · #13 01-20-2008, 01:32 PM

You would have to supply the IP address and the old cPanel login info to have the account transferred. If you have a complete backup you can upload that to your account here and ask HG to restore it. If you only have the database backups then you would need to create the databases in your cPanel and then ask HG to restore the backups.

Postaldude · #14 01-20-2008, 02:35 PM

I guess ill have to wait for support to help me. I made all the DB tables and transfered all my files over but yet none of them will run. -_-