how to populate data into mysql database installed on EC2 in AWS

Viewed 21

I have installed MySQL database on EC2 instance.I am very new to database area.

  1. I used faker and generate fake data on my local computer called sales.csv.

  2. I created a database called sales

  3. I chose the database sales

  4. I created a table called sales with 2 columns

  5. I used the command line

load data local infile 'C:/Users/sansan/sales.csv' fields terminated by ','

I got the error that the file cannot be found or the syntax for fields terminated by is not right.

I tried many things like changing / to \ and copied pasted the path, put in IP address... nothing works. I looked up the fields terminated by syntax. I do not see any errors there either.

Your help is greatly appreciated.

0 Answers
Related