Little vague, a mySQL question.

[}:8) Supermoo]

Ok, I know this is a little vague but my host communitech.net restricts access to MySQL;


For security purposes, CommuniTech.Net does not allow remote connections to the mySQL database server. However, you can connect to your mySQL databases via PHP as well as Perl using DBI and/or the mySQL Perl modules, both of which are provided on your account.

Now for a script I'm installing I need to put a sql file in their SQL database or use a command like this;


mysql dbase < file.sql

But of course that involves a remote connection. Can someone please help me out here... maybe tell me if you can write a script or something to do it. Thanks in advance!

[Koolguy]

Check out http://www.htmlwizard.net/phpMyAdmin/

[}:8) Supermoo]

k thanks... problem is just about solved.

[atlas]

Remote just means that a script let's say on my server (atlascgi.com) can't access the databases on your server.

So, to do that file just ssh or telnet to your account on CommuniTech and add the file with the normal command. That is a "local connection" since you are connecting the the mySQL daemon from a local location (since you sshed in)

mjk@atlascgi.com

[}:8) Supermoo]

Nope, telnet is considered remote access... that's how I found out. Anyway thanks to all the people who helped me!
3/4 Crazy & 100% Dumb
Koolguy

Thanks so much it's working! Thankyou!
And Atlas thanks for the ideas! Thanks world! :)

[Edited by }:8) Supermoo on 12-12-2000 at 09:58 PM]