HWD to MySQL?

    Date: 08/13/06 (MySQL Communtiy)    Keywords: mysql, html, sql, web

    I have these files generated by a perl script, called something.hwd.

    Format of each file is the title separated by a pipe symbol and then the html of the article. Example:

    This is the title | Some html about the article goes here

    Does anyone know how to mass import about 500 of these files into MySQL as records in a single table? I was going to write a script that would grab the date and time stamp of each file and then make the file format like this

    2006-06-06 | Title | The HTML

    I almost had it working but some records were skipped, I was using mysql's import command.

    Anyway, if you can't figure it out, no problem. The client is willing to start with a fresh website.

    Source: http://community.livejournal.com/mysql/101402.html

« caching kicks ass || query help? »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home