apr 2016 15:18:09 :Not able to connect to database with Username: abc abc Password: kjopsprosesser_utv4 DB HostName: Port: 1521 SID: TEST_Sħ. I have tried to create an ssh tunnel and then do the dump, but this does not seem to work. I would like to use the mysqldump on my machine to connect to the remote database and do the dump on my machine. apr 2016 15:18:09 :Starting Sql auto run script.ħ. I need to do a mysqldump of a database on a remote server, but the server does not have mysqldump installed. When I tryto connect directly from terminal connection string works, but from shell script it fails. Url="(description=(address_list=(address=(protocol=TCP)(host=)(port=1521)))(connect_data=(service_name=TEST_S)))"Ä®cho "`date` :Checking DB connectivity." Ä®cho "exit" | sqlplus -S | grep -q "Connected to:" > /dev/nullÄ®cho "`date` :Status: $"."Ä®cho "`date` :Starting Sql auto run script."Ä®cho "`date` :Sql auto run script execution completed." # Pre-Req: sqlplus client shall be installed already.ÄriverClassName= # Shell script to run sql files from command line. Script for connecting to database is given below: #!/bin/bash Enter the following command: GRANT ALL ON .In the Server Port, leave as it is '3306' unless you have changed the port of MySql in your server. Connect to the MySQL database as the root user. In the Hostname, enter your server IP address. Second, we will need to allow remote access through our system firewall. First, we will need to setup the MySQL service to be accessible from remote machines by configuring a public bind address in the MySQL configuration file. I am trying to connect to an oracle database from a shell script. In the Connection Method field, select 'Standard TCP/IP'. Allowing remote connections to your MySQL database is a three step process.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |