GoDaddy Hosting - Import database into MySQL

pchip · 02-28-2007, 08: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, 10:04 PM

you have phpmyadmin?

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

Yes.

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

you have the database file?

pchip · 02-28-2007, 10: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, 01: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, 07: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, 08: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.
????: NamePros.com http://www.namepros.com/programming/299836-godaddy-hosting-import-database-into-mysql.html

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, 09: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, 10: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, 11: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, 01:50 PM

Worked like a charm!

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

02-28-2007, 08:52 PM	THREAD STARTER #1 (permalink)
pchip NamePros Regular Join Date: Feb 2007 Posts: 210	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!

03-01-2007, 01:05 AM	#6 (permalink)
chicker NamePros Regular Join Date: Jul 2006 Location: England Posts: 722	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, 08:19 AM	#8 (permalink)
chicker NamePros Regular Join Date: Jul 2006 Location: England Posts: 722	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. ????: NamePros.com http://www.namepros.com/programming/299836-godaddy-hosting-import-database-into-mysql.html 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

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

02-28-2007, 10:04 PM	#2 (permalink)
G33K NamePros Regular Join Date: Mar 2006 Posts: 434	you have phpmyadmin?

02-28-2007, 10:24 PM	THREAD STARTER #3 (permalink)
pchip NamePros Regular Join Date: Feb 2007 Posts: 210	Yes.

02-28-2007, 10:39 PM	#4 (permalink)
G33K NamePros Regular Join Date: Mar 2006 Posts: 434	you have the database file?

02-28-2007, 10:43 PM	THREAD STARTER #5 (permalink)
pchip NamePros Regular Join Date: Feb 2007 Posts: 210	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, 07:32 AM	THREAD STARTER #7 (permalink)
pchip NamePros Regular Join Date: Feb 2007 Posts: 210	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, 09:53 AM	THREAD STARTER #9 (permalink)
pchip NamePros Regular Join Date: Feb 2007 Posts: 210	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, 10:47 AM	#10 (permalink)
GoDaddy NamePros Member Join Date: Jul 2006 Location: Phoenix Posts: 31	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, 11:38 AM	THREAD STARTER #11 (permalink)
pchip NamePros Regular Join Date: Feb 2007 Posts: 210	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, 01:50 PM	THREAD STARTER #12 (permalink)
pchip NamePros Regular Join Date: Feb 2007 Posts: 210	Worked like a charm!

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