mysql sqlyog

you have to start any tool that can run mysql statements.
that can be mysql command line (dos or unix prompt), that is what mysql> refers to...

and for a specific location, well, just specify it:

LOAD DATA LOCAL INFILE 'c:/member.txt' INTO TABLE member;

Select allOpen in new window

would this command also work for a .sql file

if you want to "run" what you have a sql statements in a .sql file, you need to do this:
http://dev.mysql.com/doc/refman/5.1/en/mysql.html

mysql {connection parameters here}  < yoursqlfile.sql

Select allOpen in new window

the file name is c:\create.sql

I am using sqlyog query editor

what would I type

as I don't use sqlyog, I am not sure.
I presume you need to use a "file -> open" command to open that file in the query browser, and the "run" it ...

if I use windows cmd
and naviagate to mysql

what would I type in

please reread my comment:
https://www.experts-exchange.com/questions/24373818/mysql-sqlyog.html?cid=1066&anchorAnswerId=24285155#a24285155

what should I put for
{connection parameters here}