09-05-2009
Trying to connect MYSQL server from HP-UX
Hi everyone,
I have an urgent requirement to get some table data from Linux-MYSQL server from HP-UX with oracle database.Is there any way we can get
connected through Shell script from HP-UX and issue select on mysql to get some table data?
Please help me out.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am getting the error "Can't call method "prepare" on an undefined value at..." with the following code:
<code>my %dbh;
my $dbh = DBI->connect("DBI:mysql:Customer_Data",
$username,
$password
) or die "Database connection... (1 Reply)
Discussion started by: vincaStar
1 Replies
2. Shell Programming and Scripting
Hi,
I want to connect perl with the mysql to select and so on but the connection don't work
code
#!/usr/bin/perl
BEGIN {
# PERL MODULES WE WILL BE USING
use DBI;
$dbh = DBI->connect('DBI:mysql:C:\Program Files\MySQL\MySQL Server 5.0\data\db1','','pass') or die $DBI::errstr;}
#... (1 Reply)
Discussion started by: eng_shimaa
1 Replies
3. UNIX for Dummies Questions & Answers
How to connect a MySQL database from unix using unix shell scripting ( people are using perl scrpt to connect the same database).
I want to access a MySQL database through a shell script (4 Replies)
Discussion started by: apsprabhu
4 Replies
4. Debian
Hello,
I wont to connect a MySQL database to debian:
I have installed libmyodbc package and after i have configured /etc/odbcinst.ini:
Description = MySQL driver
Driver = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
and /etc/odbc.ini :
Description =... (0 Replies)
Discussion started by: linux31
0 Replies
5. Linux
How to generate public key to connect from one ftp server to other server to use in scripting. (0 Replies)
Discussion started by: sridhardwh
0 Replies
6. UNIX for Advanced & Expert Users
How to generate public key to connect from one ftp server to other server to use in scripting. (1 Reply)
Discussion started by: sridhardwh
1 Replies
7. Shell Programming and Scripting
I am trying to connect to Windows server via Linux server through a script and run two commands " cd and ls " But its giving me error saying " could not start the program" followed by the command name i specify e g : "cd"
i am trying in this manner "
ssh username@servername "cd... (5 Replies)
Discussion started by: sunil seelam
5 Replies
8. Linux
Hi my name is Manju.
->I have configure the two way authentication on my linux server.
->Now I am able to apply two way authenticator on particuler user.
->Now I want to map this linux server to my AD server.
->Kindly tell me how to map AD(Active Directory) with this linux server.
... (0 Replies)
Discussion started by: manjusharma128
0 Replies
9. Shell Programming and Scripting
Hi
i am new to unix shell scripting i have the below requirement
connect to server B and then connect to mysql in the server B and query for a particular record and capture that value
but when i perform this i am facing an error
can u guys help me on this:confused::confused:
... (2 Replies)
Discussion started by: Hamdul
2 Replies
10. Programming
I am getting below error on executing the code.
<
<?php
$dbname = 'upload_ui';
$dbuser = 'nad';
$dbpass = 'nad';
$dbhost = '10.196.84.192';
$link = mysqli_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'");
}
?>
-->error:
<
PHP Warning: PHP Startup:... (2 Replies)
Discussion started by: nadeemrafikhan
2 Replies
LEARN ABOUT SUNOS
capture-schema
capture-schema(1m) Application Server Utility capture-schema(1m)
NAME
capture-schema - stores the database metadata (schema) in a file for use in mapping and execution
SYNOPSIS
capture-schema-dburl url-username name- password password-driver a_jdbc_driver [-schemaname name] [-table tablename]* [-out filename]
Stores the database metadata (schema) in a file. You can also use the Sun Java System Studio IDE to capture the database schema. Run cap-
ture-schema as the same database user that owns the tables, so that the -username and -schemaname options are given the same username.
Additionally, you can grant the database user running the capture-schema command the ANALYZE ANY TABLE privilege.
OPTIONS
-dburl JDBC URL expected by the driver for accessing a database.
-username user name for authenticating access to a database.
-password password for accessing the selected database.
-driver JDBC driver classname in your CLASSPATH.
-schemaname name of the user schema being captured. If not specified, the default will capture metadata for all tables from all
the schemas accessible to this user. Specifying this parameter is highly recommended. If more than one schema is
accessible to this user, more than one table with the same name may be captured which will cause problems.
-table name of the table; multiple table names can be specified.
-out output target; defaults to stdout. This parameter corresponds to the schema sub-element of the sun-cmp-mapping ele-
ment in the sun-cmp-mapping_1_1.dtd file.
EXAMPLES
Example 1: Using capture-schema
capture-schema -dburl jdbc:oracle:thin:@sadbuttrue:1521:ora817
-schemaname cantiflas -username CANTIFLAS -password enigma -driver
oracle.jdbc.driver.OracleDriver
asadmin(1M)
Sun Java System Application Server March 2004 capture-schema(1m)