in reply to Convert script to use MySQL
mysqlimport is an easy way to load such a file as you describe into a mysql table. Alternatively, you can use LOAD DATA INFILE in the mysql shell, or in a script for it.
Another way of getting your work done is via phpmyadmin, but of course you would need to install php first. PhpMyAdmin lets you create tables and import data from files.
Once you have your data in MySQL see: DBI recipes, or just post another question ;)
|
|---|