I have a dataset of around 200GB.
The sample is shown below:
Posted a new song: "Ensaio Don`t back anger & imagine- Stone Rocks " http://t.co/i9TqakT38t #music 460523675293196289 1308622848 0 0 Sun Apr 27 20:59:34 +0000 2014 nc f nr Posted a new song: "Led Zeppelin- Black Dog Feat. RockSauro" http://t.co/Scdo6ncIc1 #music 460454112694263809 13086228298 0 0 Sun Apr 27 16:23:09 +0000 2014 nc f nr
This data is in a text file. I have created a table and importing this data into mysql by using the command:
mysqlimport --local -u root -pxxx twitter_data '/home/abc/alltweet.txt'
How can I check how much data has been loaded in mysql table. Actually this command is running since 10 hours and count(*) is giving me zero count.