Sunday, 27 May 2012

Mysql and pyrit

using a mysql database linked with pyrit a text file containing 13636363636 or 150gig of data is taking over a week to import. once the first file is imported I will try and import directly from crunch. a very interesting command i came across while trying to find the amount of rows in a text file is awk '{n++} END {print n}' filename.txt this awks each record adding 1 into 'n' until it gets to the last row then it prints the number that is in n.(nice) Because i am now using linux on my main machine 24/7 I have installed KompoZer this is a wysiwyg editor although haven't really played with it yet. Will be looking into this soon. once I have created my database I will see if i can get it uploaded onto the internet for everyone :) am going to get my car stereo done now update Just after the post prematurely ended link from mysql and pyrit while updating database available: 4716825000 sed -n '4716825000{p;q}' filename.txt update Database size is 22.29G

No comments:

Post a Comment