Linux Korn Shell 93 Connecting to a networked MySQL database.

Linux Korn Shell 93 Connecting to a networked MySQL database.

am 09.02.2006 01:33:12 von mm

I have several korn shell scripts I use with a MySQL database on the
same server (Solaris). I am moving to a Linux environment where the
MySQL database is on another server. I would like to convert the
database connection code to connect to the database on another Linux
server. I see alot of information on Perl DBI CLI and PHP DBI CLI but

cannot find any examples of Korn Shell connecting to a database on
another server.

Is there a way to accomplish a network connection to a MySQL database
from Korn Shell? Any examples or information would be much
appreciated!

mm

Re: Linux Korn Shell 93 Connecting to a networked MySQL database.

am 09.02.2006 04:24:36 von Bill Karwin

"mm" wrote in message
news:1139445192.736203.279980@g44g2000cwa.googlegroups.com.. .
> Is there a way to accomplish a network connection to a MySQL database
> from Korn Shell? Any examples or information would be much
> appreciated!

I'm not sure I understand how you are accessing the MySQL database from Korn
shell. Are you simply using the command-line tools that come with MySQL?
For instance, mysql, mysqldump, mysqladmin, etc.

Most of the command-line tools support a "-h hostname" option with which you
can specify a remote host on which to perform the MySQL operations.

Regards,
Bill K.