Hi jjhorner.

Good question. If you are running mySQL, you can use two primary tools. From the mySQL prompt enter:

mysql> LOAD DATA LOCAL INFILE "filename.txt" INTO TABLE tablename
[download]

Since mySQL isn't case sensitive, you need not use the same uppercase style as I did. The filename must be the same as the name of the table. Example:

mysql> LOAD DATA LOCAL INFILE "monks.txt" INTO TABLE monks
[download]

There must be no 'extra' characters before the .filetype. If so, mySQL will try to insert the data into the wrong table. The other tool is called 'mysqlimport' and it acts as a command line interface to LOAD DATA.

It works like this:

(system prompt) mysqlimport --local database_name datafile.txt
[download]

Hope this helps,
-Katie

---

---

• Are you posting in the right place? Check out Where do I post X? to know for sure.
• Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:

  <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>

• Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
• Want more info? How to link or How to display code and escape characters are good places to start.