Modifying MySql Db [Archive] - Hostmonster Forums

PDA

View Full Version : Modifying MySql Db

mydanes

10-13-2006, 04:43 PM

malay32

10-13-2006, 04:51 PM

does any wann has link for da new vbulletin 3.6.2 setup bc i wann to transfer my site to vb . plz give me link

Koolkat

10-13-2006, 04:53 PM

does any wann has link for da new vbulletin 3.6.2 setup bc i wann to transfer my site to vb . plz give me link

Yeah www.vbulletin.com

malay32

10-13-2006, 04:56 PM

well ya'll hav to pay... i dont hav to pay i get for free..so ya. if any 1 has free setup...

mydanes

10-13-2006, 04:57 PM

I am sure HM does not want their forum used to find 'hack' sites for 'illegal software'

Your 'illiterate' post has NOTHING to do with the topic at hand.

malay32

10-13-2006, 04:58 PM

who cares?

IMAD

10-13-2006, 04:58 PM

if jhon catch u will close your site or to delate it

malay32

10-13-2006, 05:00 PM

well i didnt hack it i pay for my site so... ya they better dont close my site..

IMAD

10-13-2006, 05:02 PM

it's only 160 $

malay32

10-13-2006, 05:10 PM

i know thts not to much

malay32

10-13-2006, 05:11 PM

but dont i hav to pay for every week though?

marcusmaxximus

10-13-2006, 05:14 PM

not sure if it's possible to to connect over the net but aside from phpmyadmin (which i like) there's mysql administrator - a free GUI-ish admin tool available from mysql.org

WannabeArtist

10-13-2006, 05:15 PM

Oh my, what a good forum start, already the first joker asking for pirated scripts, off-topic as well.

Anyway, to add something on-topic: phpMyAdmin is actually the only server-side admin script for mysql I know, but afaik you can have your account set up to allow administration from your home PC. There are a ton of mysql GUIs and administration packages around to install on your PC and then connect remotely to the server. (e.g. http://www.mysql.com/products/tools/query-browser/ and others)

mydanes

10-13-2006, 05:20 PM

Thank you for ACTUALLY answering my question!!! I thought the same as you about the pirated scripts and off topic! Thanks WannabeArtist for replying!!

more Later,

Susan

phantom

10-13-2006, 05:37 PM

asian

10-13-2006, 05:47 PM

i bought this, but never got around to trying it. you might want to.

http://tufat.com/s_flash_phpmyadmin.htm

raavin

10-13-2006, 05:52 PM

Yeah the official MySQL tools are good for windows. I can't remember where I found the solution, but the text does something wierd and is really small with the default install so you have to edit a setting file (from memory??). Google for the fix. I've recently been moing toward Mac so CocoaMysql is good for that. The MySL tools package is still a bit flakey in the OSX version.

ps. just found the link to the 'small font' fix http://bugs.mysql.com/bug.php?id=19528 . It appears you may not have the problem if you haven't tried an earlier version.

Oh and remember that to hook into your hostmonster mysql account from home/work, you need to set things up from your cpanel to accept incoming requests from your home/work ip address. Haven't tried it yet with hostmonster so I'll leave that to you. Happy to help more if you get lost though. :)

vedia

10-14-2006, 02:40 AM

What tools are others using for modification to structure - I don't like the phpmyadmin tool very well and I have .sql files for creating new dbs but would love to know what others are using!!!

More Later,

Susan
Hi,

There is a nice desktop application named Navicat on web http://www.navicat.com/

But, to use it with HostMonster you should take help from hostmonster helpdesk to access your MySQL database with your IP (at home, at office etc).

Navicat is a perfect tool!

Regards...

linFox

10-14-2006, 03:30 AM

Yes, I use Navicat too. It's really a good program.

Unfortunately support have kind of gone quiet for a few days in the middle of me getting external access allowed, so I can't use it yet.

raavin

10-14-2006, 05:08 AM

While I appreciate the security measures, having to supply IPs when you are are on a dynamic IP plan is a pain. I should probably organise that now and hope I don't have to reset my modem :)

-=HotA=-4thHorseman

10-14-2006, 08:24 AM

While I appreciate the security measures, having to supply IPs when you are are on a dynamic IP plan is a pain. I should probably organise that now and hope I don't have to reset my modem :)

there is a way around all that.... http://www.dyndns.com/ you go there and download the program set up a account (all free) and now you have a ip that is stuck to your roaming ip...

as for the sql question here is another place http://www.webyog.com/en/ ...

WannabeArtist

10-14-2006, 08:41 AM

there is a way around all that.... http://www.dyndns.com/ you go there and download the program set up a account (all free) and now you have a ip that is stuck to your roaming ip...

Well, you get a subdomain on one of their domains linking to your IP then, but that doesn't magically create a permanent IP for you, so the problem remains. That is, unless the staff here is willing to set up access for whole subnets, or you can get a fixed IP from your ISP.

-=HotA=-4thHorseman

10-14-2006, 08:56 AM

Well, you get a subdomain on one of their domains linking to your IP then, but that doesn't magically create a permanent IP for you, so the problem remains. That is, unless the staff here is willing to set up access for whole subnets, or you can get a fixed IP from your ISP.

yes you are right you get a sub-domain , but your roaming ip is automaticly reassigned anytime it changes.

i guess i did not get the question.... lol

mydanes

10-14-2006, 11:24 AM

Thanks for the great links now I have some new tools to try out!!! I don't mind the listing the IP with HM deal because they add it instantly for me and it gives me some piece of mind having been hacked with other hosting companies myself the mild inconvenience is worth it!

mydanes

10-14-2006, 11:36 AM

WannabeArtist

10-14-2006, 11:45 AM

I have dyndns and I can't figure out how do I get a 'ip' address that it keeps for me? I have it where it gives me a account.dyndns.info

but can't figure out how to get a 'static' Ip from them I am sorry stupid question

As I had posted above, you don't get a static IP from dyndns, just a static address, and that won't help you any.

mydanes

10-14-2006, 12:18 PM

woops I see that now - SORRY - mybad. :)

I did put a support question to dyndns if they offer a 'paid service' for a 'IP' address instead of a name!

Also I talked to HM support and they said they will be adding a tool to be able to add our ip addresses ourselves in the not too distant future :)

Susan

WannabeArtist

10-14-2006, 12:55 PM

Also I talked to HM support and they said they will be adding a tool to be able to add our ip addresses ourselves in the not too distant future :)

Susan

Ah, that's good then. Although with software/scripts "not too distant" could still mean anything, but they got it in the works at least.

virtualahmad

10-15-2006, 02:27 PM

I use Navicat... love it.. has everything. I develop websites/ecommerce and its amazingly easy to transfer databases etc. using this.

As far as the whitelisting of IP's in order to access the db from anywhere other than localhost, you can whitelist an IP or even wildcard it from the control panel, BUT you must still contact support to allow it through their firewall. While the extra security is reassuring, it is a pain for me personally. You can request SSH access and this means you will no long have to worry about whitelisting IPs.... BUT you need to send them valid government photo ID (fax or email).

Prior to SSH access, it was a pain... now... very happy.