hankknight
asked on
LOAD DATA INFILE from command line
Hello,
I have root access to a remote Linux server running CentOS with MySQL installed.
I want to populate a database from a text file at the command-line prompt.
This does NOT work:
mysql --user=user_user -password=password user_DB; LOAD DATA INFILE 'generated.txt' INTO TABLE myTable FIELDS TERMINATED BY '||';
What am I doing wroing?
I have root access to a remote Linux server running CentOS with MySQL installed.
I want to populate a database from a text file at the command-line prompt.
This does NOT work:
mysql --user=user_user -password=password user_DB; LOAD DATA INFILE 'generated.txt' INTO TABLE myTable FIELDS TERMINATED BY '||';
What am I doing wroing?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.