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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment