← prev | next →
TheQuotidian 2019-12-16 20:59:01
Any help possible?
TheQuotidian 2019-12-16 20:59:01
MYSQL is hosted on AWS RDS
MasterZiv 2019-12-16 20:59:30
TheQuotidian 2019-12-16 20:59:01
Any help possible?
too little info, needed more info
MasterZiv 2019-12-16 21:00:23
TheQuotidian 2019-12-16 20:59:01
MYSQL is hosted on AWS RDS
Most probably you need to setup VPN or ssh tunnel first , to reach to that host.
because very rarely they allow DBMS to show up at the public IP
TheQuotidian 2019-12-16 21:01:48
Mysql is in AWS RDS instance
VPN working
That is accessible using IP and port using Mysql Workbench
That MySQL is also accessible through MySQL for Excel
But when 32 bit ODBC driver is used to Get Data in MYSQL error crops up
TheQuotidian 2019-12-16 21:03:36
Error – usernsme@ip does not have access with Password = yes
TheQuotidian 2019-12-16 21:03:58
Password isn’t yes though
TheQuotidian 2019-12-16 21:04:25
MasterZiv 2019-12-16 21:00:23
Most probably you need to setup VPN or ssh tunnel first , to reach to that host.
because very rarely they allow DBMS to show up at the public IP
VPN up
MasterZiv 2019-12-16 21:04:56
TheQuotidian 2019-12-16 21:01:48
Mysql is in AWS RDS instance
VPN working
That is accessible using IP and port using Mysql Workbench
That MySQL is also accessible through MySQL for Excel
But when 32 bit ODBC driver is used to Get Data in MYSQL error crops up
then just specify internal MySQL ‘s IP and port and other connection data and that is it
TheQuotidian 2019-12-16 21:05:22
Internal mysql ip? Kindly help
TheQuotidian 2019-12-16 21:05:27
What is that
TheQuotidian 2019-12-16 21:05:37
The ip I have is AWS provided
MasterZiv 2019-12-16 21:06:19
TheQuotidian 2019-12-16 21:05:22
Internal mysql ip? Kindly help
The IP by which MySQL is accessible at the VPN network
TheQuotidian 2019-12-16 21:06:39
Any help on how to find that out?
MasterZiv 2019-12-16 21:07:13
TheQuotidian 2019-12-16 21:05:37
The ip I have is AWS provided
There can be 2 IPs , in the public network and in the VPN network. You should use the one in the VPN network
MasterZiv 2019-12-16 21:07:50
TheQuotidian 2019-12-16 21:06:39
Any help on how to find that out?
You just should know it, from AWS admins probably…
TheQuotidian 2019-12-16 21:08:00
Okie
TheQuotidian 2019-12-16 21:08:07
Thx a ton boss 👍
Madhukar Parne 2019-12-21 18:53:34
Could some advice me for mysql exam
iatharva 2019-12-23 09:49:09
can anyone tell me how to access mysql database of pc1 on the same local network from pc2 ?
iatharva 2019-12-23 09:49:56
i already searched but its saying to install mysql client and mysql server to the respective pcs but I cant seem to find it both ?
MasterZiv 2019-12-23 10:40:54
iatharva 2019-12-23 09:49:56
i already searched but its saying to install mysql client and mysql server to the respective pcs but I cant seem to find it both ?
This is correct information, except that the server you kinda must already have installed, as you are trying to reach it.
MasterZiv 2019-12-23 10:43:39
iatharva 2019-12-23 09:49:09
can anyone tell me how to access mysql database of pc1 on the same local network from pc2 ?
This is written in any starting guide , in any study book, just do it!
I can’t understand what is it that impossible to understand there.
Do in steps, step 1 — setup mysql client on that machine
MasterZiv 2019-12-23 10:44:39
https://dev.mysql.com/doc/mysql-getting-started/en/
2019-12-23 13:12:14
How we can import data csv to table using stored procedure?
smlkw 2019-12-23 13:15:20
2019-12-23 13:12:14
How we can import data csv to table using stored procedure?
You can use this statement in the stored procedure: LOAD DATA INFILE ‘/root/data.csv’ INTO TABLE CSVImport;
2019-12-23 13:19:10
smlkw 2019-12-23 13:15:20
You can use this statement in the stored procedure: LOAD DATA INFILE ‘/root/data.csv’ INTO TABLE CSVImport;
Thanks but its not working
2019-12-23 13:19:38
I got this error
smlkw 2019-12-23 13:19:49
2019-12-23 13:19:10
Thanks but its not working
Actually your mysql server should be configured properly to run this statement.
Neeraj Khatak 2019-12-23 13:20:19
Do anyone have book for programming in oracle?
Neeraj Khatak 2019-12-23 13:20:38
Pdf
2019-12-23 13:20:42
smlkw 2019-12-23 13:19:49
Actually your mysql server should be configured properly to run this statement.
Load data is not working in stored procedure
smlkw 2019-12-23 13:21:01
2019-12-23 13:20:42
Load data is not working in stored procedure
Yes, and the error message says you what is the problem
2019-12-23 13:21:36
Without load data how we cam import file using stored procedure
smlkw 2019-12-23 13:22:23
2019-12-23 13:21:36
Without load data how we cam import file using stored procedure
I think there is no another way to reach this goal
2019-12-23 13:23:02
smlkw 2019-12-23 13:22:23
I think there is no another way to reach this goal
So we can’t import data from stored procedure
smlkw 2019-12-23 13:27:44
iatharva 2019-12-23 09:49:09
can anyone tell me how to access mysql database of pc1 on the same local network from pc2 ?
You should have an installed MySQL instance on the pc1 machine and the mysql client on the pc2 machine. MySQL Client can be a GUI tool or the official CLI program (called mysql). On the connection step enter the IP address of your pc1 machine. Also, be sure that the pc2 machine can access the pc1 machine.
2019-12-23 13:28:36
smlkw 2019-12-23 13:27:44
You should have an installed MySQL instance on the pc1 machine and the mysql client on the pc2 machine. MySQL Client can be a GUI tool or the official CLI program (called mysql). On the connection step enter the IP address of your pc1 machine. Also, be sure that the pc2 machine can access the pc1 machine.
Ok thanks for your help
smlkw 2019-12-23 13:29:04
2019-12-23 13:28:36
Ok thanks for your help
It was a reply to another member.
iatharva 2019-12-23 13:29:58
i will try and let you know if i have any problem
MasterZiv 2019-12-23 13:36:02
2019-12-23 13:12:14
How we can import data csv to table using stored procedure?
There is nothing here to do for a stored procedure
smlkw 2019-12-23 13:41:45
MasterZiv 2019-12-23 13:36:02
There is nothing here to do for a stored procedure
What?
2019-12-23 13:42:56
smlkw 2019-12-23 13:29:04
It was a reply to another member.
😛 sorry
MasterZiv 2019-12-23 13:44:21
smlkw 2019-12-23 13:41:45
What?
I mean one doesn’t need a stored procedure to do this
smlkw 2019-12-23 13:45:37
MasterZiv 2019-12-23 13:44:21
I mean one doesn’t need a stored procedure to do this
I think he wants to regularly call the procedure and import a CSV file, so it is a understandable task.
Syedjafer 2019-12-24 10:02:58
Hi all
Syedjafer 2019-12-24 10:03:23
How to convert oracle stored procedures to mysql stored procedure
MasterZiv 2019-12-24 10:04:44
Syedjafer 2019-12-24 10:03:23
How to convert oracle stored procedures to mysql stored procedure
Just re-write from scratch, imitating same logic.
This is not done automatically, only manual programming
MasterZiv 2019-12-24 10:05:01
Syedjafer 2019-12-24 10:03:23
How to convert oracle stored procedures to mysql stored procedure
So this is not converting but creating
TheQuotidian 2019-12-24 10:07:33
Syedjafer 2019-12-24 10:03:23
How to convert oracle stored procedures to mysql stored procedure
http://www.sqlines.com/download
Download Tools – SQLines Tools –
SqlinesHere you can download SQLines tools: SQLines SQL Converter SQLines SQL Converter helps you convert database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers. You can also try it Online. SQLines SQL Converter – Evaluation Note:
← prev | next →