GoDaddy Hosting - Import database into MySQL

pchip · 02-28-2007, 07:52 PM

I wasn't sure where to post this but here goes... I'm trying to figure out how to import my database into MySQL. My hosting is through GoDaddy so they give me a web interface to create and edit my MySQL database/tables. I looked all over the place and wasn't able to find where I could import my database. I did see where I can export the data. Has anyone had any experience with this and can point my into the right direction?

Thanks for the help!

G33K · 02-28-2007, 09:04 PM

you have phpmyadmin?

pchip · 02-28-2007, 09:24 PM

Yes.

G33K · 02-28-2007, 09:39 PM

you have the database file?

pchip · 02-28-2007, 09:43 PM

Right now my data is in an access database. I assume i'll need to export this into something else (i.e. mysql, comma/tab delimited file, etc...)?

chicker · 03-01-2007, 12:05 AM

Godaddy has disabled the import file function, you need to open sql window on php my admin and copy the database dump into it. (make sure it is a mysql dump file)

Also make sure you have no char sets as godaddy does not allow it.

Godaday and database = Trouble
Hope that helps

pchip · 03-01-2007, 06:32 AM

Figures that they would disable the import function

I'll have to research this a bit but atleast I know which direction to head.

chicker, you mentioned that GoDaddy and databases don't mix, why type of problems have you seen that I might experience myself? Since I haven't went live with my website yet, I can still change hosting providers.

Thanks for the help!!!

chicker · 03-01-2007, 07:19 AM

As a php web developer and script installer I have had to move many clients away from godaddy due to several features,

They don't allow importing of files so you have to use the sql, ok for small databases but can take time.

They don't support charecture sets.

Their are many reasons and every time I come accross one I ask on behalf of the client for godaddy to address the problem and at the end of the day they turn arround with a no sorry or a use the sql feature which is not that good.

It is up to you but I would say godaddy is ok for domains but change the name servers to another host. Idearly one with cpanel, as for a begginer you will understand it alot more and the phpmyadmin features are not blocked.

pchip · 03-01-2007, 08:53 AM

Hmm, that doesn't sound good. While i'm playing around with myphpadmin, I'll research some other hosting providers. Thanks for the help chicker!

GoDaddy · 03-01-2007, 09:47 AM

pchip,

Try this method:

Load PhpMyAdmin, near the top left, click on the little "SQL" button. Then select the "Import Files" tab. Select your file and hit "Go".

Hope this helps!

pchip · 03-02-2007, 10:38 AM

There's the import files! Thanks GoDaddy!!! What type of files does myphpadmin support for importing files? It seems that I would need a sql dump as some of the others have mentioned. I'm in the process of migrating my access database over to mysql. Once i've done that, I will create a '.sql dump' from my local instance of mysqal and then import that file into my new database. Just wanted to check and make sure i'm heading in the right direction?

Thanks everyone!!

pchip · 03-03-2007, 12:50 PM

Worked like a charm!

GoDaddy · 03-04-2007, 02:14 PM

02-28-2007, 07:52 PM	#1 (permalink)
pchip NamePros Member Join Date: Feb 2007 Posts: 134 0.00 NP$ (Donate)	GoDaddy Hosting - Import database into MySQL I wasn't sure where to post this but here goes... I'm trying to figure out how to import my database into MySQL. My hosting is through GoDaddy so they give me a web interface to create and edit my MySQL database/tables. I looked all over the place and wasn't able to find where I could import my database. I did see where I can export the data. Has anyone had any experience with this and can point my into the right direction? Thanks for the help!

02-28-2007, 09:04 PM	#2 (permalink)
G33K NamePros Regular Join Date: Mar 2006 Posts: 413 131.40 NP$ (Donate)	you have phpmyadmin? __________________ Smoke Signals G33K.INFO WWW.BUBBLEFART.COM

02-28-2007, 09:39 PM	#4 (permalink)
G33K NamePros Regular Join Date: Mar 2006 Posts: 413 131.40 NP$ (Donate)	you have the database file? __________________ Smoke Signals G33K.INFO WWW.BUBBLEFART.COM

03-01-2007, 12:05 AM	#6 (permalink)
chicker NamePros Regular Join Date: Jul 2006 Location: England Posts: 721 11.75 NP$ (Donate)	Godaddy has disabled the import file function, you need to open sql window on php my admin and copy the database dump into it. (make sure it is a mysql dump file) Also make sure you have no char sets as godaddy does not allow it. Godaday and database = Trouble Hope that helps __________________ ReallyPay.com - Free online resource site for making money online. Ask About Stuff- Find your questions answer

03-01-2007, 07:19 AM	#8 (permalink)
chicker NamePros Regular Join Date: Jul 2006 Location: England Posts: 721 11.75 NP$ (Donate)	As a php web developer and script installer I have had to move many clients away from godaddy due to several features, They don't allow importing of files so you have to use the sql, ok for small databases but can take time. They don't support charecture sets. Their are many reasons and every time I come accross one I ask on behalf of the client for godaddy to address the problem and at the end of the day they turn arround with a no sorry or a use the sql feature which is not that good. It is up to you but I would say godaddy is ok for domains but change the name servers to another host. Idearly one with cpanel, as for a begginer you will understand it alot more and the phpmyadmin features are not blocked. __________________ ReallyPay.com - Free online resource site for making money online. Ask About Stuff- Find your questions answer

02-28-2007, 09:24 PM	#3 (permalink)
pchip NamePros Member Join Date: Feb 2007 Posts: 134 0.00 NP$ (Donate)	Yes.

02-28-2007, 09:43 PM	#5 (permalink)
pchip NamePros Member Join Date: Feb 2007 Posts: 134 0.00 NP$ (Donate)	Right now my data is in an access database. I assume i'll need to export this into something else (i.e. mysql, comma/tab delimited file, etc...)?

03-01-2007, 06:32 AM	#7 (permalink)
pchip NamePros Member Join Date: Feb 2007 Posts: 134 0.00 NP$ (Donate)	Figures that they would disable the import function I'll have to research this a bit but atleast I know which direction to head. chicker, you mentioned that GoDaddy and databases don't mix, why type of problems have you seen that I might experience myself? Since I haven't went live with my website yet, I can still change hosting providers. Thanks for the help!!!

03-01-2007, 08:53 AM	#9 (permalink)
pchip NamePros Member Join Date: Feb 2007 Posts: 134 0.00 NP$ (Donate)	Hmm, that doesn't sound good. While i'm playing around with myphpadmin, I'll research some other hosting providers. Thanks for the help chicker!

03-01-2007, 09:47 AM	#10 (permalink)
GoDaddy NamePros Member Join Date: Jul 2006 Location: Phoenix Posts: 31 0.00 NP$ (Donate)	pchip, Try this method: Load PhpMyAdmin, near the top left, click on the little "SQL" button. Then select the "Import Files" tab. Select your file and hit "Go". Hope this helps!

03-02-2007, 10:38 AM	#11 (permalink)
pchip NamePros Member Join Date: Feb 2007 Posts: 134 0.00 NP$ (Donate)	There's the import files! Thanks GoDaddy!!! What type of files does myphpadmin support for importing files? It seems that I would need a sql dump as some of the others have mentioned. I'm in the process of migrating my access database over to mysql. Once i've done that, I will create a '.sql dump' from my local instance of mysqal and then import that file into my new database. Just wanted to check and make sure i'm heading in the right direction? Thanks everyone!!

03-03-2007, 12:50 PM	#12 (permalink)
pchip NamePros Member Join Date: Feb 2007 Posts: 134 0.00 NP$ (Donate)	Worked like a charm!

03-04-2007, 02:14 PM	#13 (permalink)
GoDaddy NamePros Member Join Date: Jul 2006 Location: Phoenix Posts: 31 0.00 NP$ (Donate)	=)

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)