GoDaddy Hosting - Import database into MySQL

[pchip]

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]

you have phpmyadmin?

 

[pchip]

Yes.

 

[G33K]

you have the database file?

 

[pchip]

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]

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]

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]

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]

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!

 

[member-35138]

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]

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]

Worked like a charm!

 

[member-35138]

=)