Client Support Community Server Status Contact Us Client Login
Email Hosting Website Hosting Reseller Hosting VPS Hosting Dedicated Servers
    Join our Community      Check your private messages       Profile       Search       FAQ       Memberlist       Log in

updating mysql from local pc

  
Post new topic   Reply to topic    NetHosted Community Index -> FTP/SQL Support
Z Reply with quote
 NetHosted Customer

 

 Joined: 29 Jan 2005
 Posts: 285
 
PostPosted: Fri Aug 10, 2007 7:54 am    Post subject: updating mysql from local pc
 
is this possible? I have set up a mysql database on my server but would like to run something on my pc to insert records. What would the host be? just my base domain url?


TIA
_________________
Getting the hang of it slowly (subject to comment)
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 5655
 
PostPosted: Fri Aug 10, 2007 9:14 am    Post subject:
 
Hi,

This is possible.

Yes your base domain. You will need to add your local IP address to the allowed hosts in the MySQL tool in cPanel first though.

Thanks,

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
Z Reply with quote
 NetHosted Customer

 

 Joined: 29 Jan 2005
 Posts: 285
 
PostPosted: Fri Aug 10, 2007 9:18 am    Post subject:
 
cool. how do I get my local IP address?
_________________
Getting the hang of it slowly (subject to comment)
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 5655
 
PostPosted: Fri Aug 10, 2007 9:20 am    Post subject:
 
http://www.whatsmyipaddress.com/ 

Thanks,

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
Z Reply with quote
 NetHosted Customer

 

 Joined: 29 Jan 2005
 Posts: 285
 
PostPosted: Fri Aug 10, 2007 10:10 am    Post subject:
 
lol...obvious really. Does that change though?
_________________
Getting the hang of it slowly (subject to comment)
Back to top
View user's profile Send private message
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 5655
 
PostPosted: Fri Aug 10, 2007 10:20 am    Post subject:
 
It would seem in your case yes (phpBB shows me which IP addresses you have posted from). If you don't want the hassle of adding a new IP every time you want to login to MySQL remotely I'd advise asking your ISP for a static IP.

Thanks,

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
Z Reply with quote
 NetHosted Customer

 

 Joined: 29 Jan 2005
 Posts: 285
 
PostPosted: Fri Aug 10, 2007 10:28 am    Post subject:
 
I was thinking it changed. Oh well, I can output the data to a .txt file instead and work on it that way

thanks Andrew
_________________
Getting the hang of it slowly (subject to comment)
Back to top
View user's profile Send private message
Post new topic   Reply to topic    NetHosted Community Index -> FTP/SQL Support
Page 1 of 1

User Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum

 
Jump to: