Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 584
  • Last Modified:

mysql sqlyog

mysql> LOAD DATA LOCAL INFILE 'member.txt' INTO TABLE member;

how do I do this command
also where does 'member.txt' have to be located

c:\member.txt
   
0
shopjd
Asked:
shopjd
  • 5
  • 4
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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;

Open in new window

0
 
shopjdAuthor Commented:
would this command also work for a .sql file
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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

Open in new window

0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
shopjdAuthor Commented:
the file name is c:\create.sql

I am using sqlyog query editor

what would I type
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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 ...
0
 
shopjdAuthor Commented:
if I use windows cmd
and naviagate to mysql

what would I type in
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
shopjdAuthor Commented:
what should I put for
{connection parameters here}
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you really did not look at the comment, resp to the link that I gave.
the doc contains all the information you need to establish the "connection parameters".

note: first, I cannot give you the connection parameters, because they contain your servername, login and password. you have them, and you alone should have them (I mean, they should not be visible here).

second: please understand that I try to guide you to find your solution, so you remember for good.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now