tag:blogger.com,1999:blog-8496800963525315493.post3906117562197558529..comments2023-08-13T05:38:21.676-07:00Comments on blog.josephhall.com: Importing the USDA SR22 into MySQLUnknownnoreply@blogger.comBlogger5125tag:blogger.com,1999:blog-8496800963525315493.post-65502554545360373642010-10-04T12:32:58.560-07:002010-10-04T12:32:58.560-07:00Hi Joseph,I've imported the ABBREV.txt file on...Hi Joseph,<br><br>I've imported the ABBREV.txt file only whit a sql script, whitout the perl script:<br><br>LOAD DATA LOCAL INFILE 'ABBREV.txt'<br>INTO TABLE ABBREV<br>FIELDS TERMINATED BY '^'<br>optionally enclosed by '~'<br>LINES TERMINATED BY '\n'<br><br>patricioplgomezhttp://patriciogomez.com.arnoreply@blogger.comtag:blogger.com,1999:blog-8496800963525315493.post-68061984599447636672010-09-09T03:00:37.347-07:002010-09-09T03:00:37.347-07:00Sorry, I forgot it was the abbrev data. Last time ...Sorry, I forgot it was the abbrev data. Last time I imported full dump. CheersLisakhttp://www.blogger.com/profile/12015675829844375240noreply@blogger.comtag:blogger.com,1999:blog-8496800963525315493.post-84861440948364591362010-09-09T02:58:12.659-07:002010-09-09T02:58:12.659-07:00hey,I've done what you said (i'm a linux a...hey,<br><br>I've done what you said (i'm a linux admin, not a newbie) and script ended without any log, but the database was empty, only empty schema in there. JakubLisakhttp://www.blogger.com/profile/12015675829844375240noreply@blogger.comtag:blogger.com,1999:blog-8496800963525315493.post-78554555254151118342010-07-28T22:45:34.040-07:002010-07-28T22:45:34.040-07:00Thanks! great work.Thanks! great work.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8496800963525315493.post-59940126882637156252010-03-08T10:05:17.023-08:002010-03-08T10:05:17.023-08:00Cheers for the work. Not being a perl guy I used t...Cheers for the work. Not being a perl guy I used the The Eloquent Geek's approach. And it worked out great.Michael Carøe Andersenhttp://www.blogger.com/profile/09539447126327623536noreply@blogger.com