1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
Hello.
Have you set an IAM role for Aurora MySQL?
If you have not set it, please set it by following the steps in the document below.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.LoadFromS3.html#AuroraMySQL.Integrating.LoadFromS3.Authorize
Also, what command did you run?
To read the text, you need to specify the S3 URL as shown below.
LOAD DATA FROM S3 's3://mybucket/data.txt'
INTO TABLE table1
(column1, @var1)
SET table_column2 = @var1/100;
To connect to Aurora MySQL without using "Workbench" you need to use MySQL commands.
You need to run the below command below.
mysql -h "Aurora MySQL Endpoint" -u root -p
관련 콘텐츠
- 질문됨 7년 전
- AWS 공식업데이트됨 일 년 전
I did set the IAM role, and use the command with the S3 URL as in the example. Workbench appears to complain about the S3 part of the command, before even reaching the URL.
mysql command works - thank you. It sure would have been nice to be able to run this from the workbench.