Create script to import text file into MySql

Running MySql version 5.6.17 on a ML350 G5 server.  The operating system is Small Business Server 2008

Please understand I am learning Mysql .  I am not an expert.

Each day a text file must be imported into table Pivot.tblPivotTxt.

The command to do this is:
LOAD DATA INFILE 'd:\Investing – Programming\MySql\TxtData\PivotValues.csv'
INTO TABLE Pivot.tblPivotTxt
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 ROWS

I must type this each and every day.  I have searched for a way to write this as some script but it seems this instruction cannot be put into a sql script file.   I guess the CREATE PROCEDURE command does not allow LOAD DATA INFILE in a sql script.  [This is my guess]

I have a batch file which will start the Mysql command line interface (I guess that's what it is called).
I have to type in the password then I see the mysql > 
Then I have to type in the commands shown above.

There must be a better way.  
Q1.)  How can I turn this into a batch file of some sort so I can schedule it to run at a certain time?  

Q2.)  What code would you write to start the Mysql command line interface?  I am assuming it must be started first before any script is executed.  My assumption could be totally wrong.

Q2.)  Where would  I look for a log file to tell me if the procedure failed or succeeded?

Remember I am not an expert.  Please give me a detailed answers.  If you have a better way to do this then please explain how.

Useful links are always appreciated.

Thank you.
donpickAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
You could use mysqlimport to do that

(something like: mysqlimport -u root -ptmppassword --local test employee.txt)
 
and as you run it on SBS 2008 you can put a scheduled task to run your command batch file.

http://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lcohanDatabase AnalystCommented:
Or you could load mysql client and run your command via that utility like:
start client: http://www.dummies.com/how-to/content/how-to-use-the-mysql-client.html
and from the client: https://dev.mysql.com/doc/refman/5.6/en/loading-tables.html

All these can be combined into a CMD file (unless you don't want to use the easier above method mysqlimport) and you execute it via a scheduled task.
0
donpickAuthor Commented:
Thank you Icohan for the prompt answer   I appreciate your help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.