NamePros
Welcome, Guest! Ready to make a name for yourself in the domain business? We welcome both the hobbyist and professional domainer to join the discussion as part of the NamePros community.

Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
FAQ & TOS Register Search Today's Posts Mark Forums Read

Go Back   NamePros.com > Website Development Discussion Forums > Programming
Reload this Page GoDaddy Hosting - Import database into MySQL

Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics.

Advanced Search


Closed Thread
 
LinkBack Thread Tools
Old 02-28-2007, 08:52 PM THREAD STARTER               #1 (permalink)
NamePros Regular
 
pchip's Avatar
Join Date: Feb 2007
Posts: 210
pchip has a spectacular aura aboutpchip has a spectacular aura about
 



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!
pchip is offline  
Old 02-28-2007, 10:04 PM   #2 (permalink)
NamePros Regular
 
G33K's Avatar
Join Date: Mar 2006
Posts: 434
G33K will become famous soon enoughG33K will become famous soon enough
 



you have phpmyadmin?
G33K is offline  
Old 02-28-2007, 10:24 PM THREAD STARTER               #3 (permalink)
NamePros Regular
 
pchip's Avatar
Join Date: Feb 2007
Posts: 210
pchip has a spectacular aura aboutpchip has a spectacular aura about
 



Yes.
pchip is offline  
Old 02-28-2007, 10:39 PM   #4 (permalink)
NamePros Regular
 
G33K's Avatar
Join Date: Mar 2006
Posts: 434
G33K will become famous soon enoughG33K will become famous soon enough
 



you have the database file?
G33K is offline  
Old 02-28-2007, 10:43 PM THREAD STARTER               #5 (permalink)
NamePros Regular
 
pchip's Avatar
Join Date: Feb 2007
Posts: 210
pchip has a spectacular aura aboutpchip has a spectacular aura about
 



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...)?
pchip is offline  
Old 03-01-2007, 01:05 AM   #6 (permalink)
NamePros Regular
Join Date: Jul 2006
Location: England
Posts: 722
chicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to all
 


Save The Children
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
chicker is offline  
Old 03-01-2007, 07:32 AM THREAD STARTER               #7 (permalink)
NamePros Regular
 
pchip's Avatar
Join Date: Feb 2007
Posts: 210
pchip has a spectacular aura aboutpchip has a spectacular aura about
 



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!!!
pchip is offline  
Old 03-01-2007, 08:19 AM   #8 (permalink)
NamePros Regular
Join Date: Jul 2006
Location: England
Posts: 722
chicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to all
 


Save The Children
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.
chicker is offline  
Old 03-01-2007, 09:53 AM THREAD STARTER               #9 (permalink)
NamePros Regular
 
pchip's Avatar
Join Date: Feb 2007
Posts: 210
pchip has a spectacular aura aboutpchip has a spectacular aura about
 



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!
pchip is offline  
Old 03-01-2007, 10:47 AM   #10 (permalink)
NamePros Member
Join Date: Jul 2006
Location: Phoenix
Posts: 31
GoDaddy is an unknown quantity at this point
 



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!
GoDaddy is offline  
Old 03-02-2007, 11:38 AM THREAD STARTER               #11 (permalink)
NamePros Regular
 
pchip's Avatar
Join Date: Feb 2007
Posts: 210
pchip has a spectacular aura aboutpchip has a spectacular aura about
 



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 is offline  
Old 03-03-2007, 01:50 PM THREAD STARTER               #12 (permalink)
NamePros Regular
 
pchip's Avatar
Join Date: Feb 2007
Posts: 210
pchip has a spectacular aura aboutpchip has a spectacular aura about
 



Worked like a charm!
pchip is offline  
Old 03-04-2007, 03:14 PM   #13 (permalink)
NamePros Member
Join Date: Jul 2006
Location: Phoenix
Posts: 31
GoDaddy is an unknown quantity at this point
 



=)
GoDaddy is offline  
Closed Thread


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


Liquid Web Smart Servers  
All times are GMT -7. The time now is 09:49 AM.

Managed Web Hosting by Liquid Web
Domain name forum recommended by Domaining.com Powered by: vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0 Ad Management plugin by RedTyger