topic Re: mysql [database connectivity] in shell scripting hpux in Operating System - HP-UX

mysql [database connectivity] in shell scripting hpux

Vinayak_HPUX — Tue, 29 Apr 2008 05:37:38 GMT

I have setup mysql server and client both are working fine.I am having problem of database connectivity.....plz let me know how to do the db[mysql connectivity] thru shell scripting?

Re: mysql [database connectivity] in shell scripting hpux

Rasheed Tamton — Tue, 29 Apr 2008 06:41:14 GMT

The question is not clear. But can you please post how you manually connect to mysql from the command prompt. So, it would be easy for us to automate.

Re: mysql [database connectivity] in shell scripting hpux

Steven E. Protter — Tue, 29 Apr 2008 08:03:08 GMT

Shalom,

The mysql client/database server manager is at a different location than Linux. But the command line and interactive commands are the same, they were merely ported and compiled on HP-UX, by HP, if you used mysql from the HP Web suite on http://software.hp.com (search Internet Express).

SEP

Re: mysql [database connectivity] in shell scripting hpux

Vinayak_HPUX — Tue, 29 Apr 2008 09:20:55 GMT

For java language there is block of jdbc.odbc connection code ....similarly is there any block code to open , connect database in shell scripting?

Re: mysql [database connectivity] in shell scripting hpux

Rasheed Tamton — Tue, 29 Apr 2008 09:56:37 GMT

If I get your question clearly, yes - the databases can be connected through the script. Few of them, using the scripts to start and stop the databases.

I had an old note reg. mysql for Linux. May be you can try it from the command prompt.

mysqladmin -uUSERNAME -pPASSWORD

Check in /sbin/init.d whether there is a script related to mysql (mysql.server, etc.)

Re: mysql [database connectivity] in shell scripting hpux

Vinayak_HPUX — Tue, 29 Apr 2008 10:38:28 GMT

My clear Q? is I want to access database [mysql] tables thru shell script ...how to do ?

Re: mysql [database connectivity] in shell scripting hpux

Rasheed Tamton — Tue, 29 Apr 2008 11:04:11 GMT

You can do it. You do the sequence of commands you use manually line by line in the script file and automate it. The end point is you connect to database and pass the SQL statements from the script.

Something like this:

#!/usr/bin/sh
mysql -u username -ppassword -D dbname <SELECT * from table;
EOF

Save and execute script as follows:
$ chmod +x script.sh
$ ./script.sh

Re: mysql [database connectivity] in shell scripting hpux

Vinayak_HPUX — Mon, 31 Aug 2009 05:38:13 GMT

I got solutions