Issue with inserting realtime.txt in mysqlDB
Posted: Thu 25 Jun 2015 2:37 pm
Hi...
I need some help
I am using cron job to insert realtime.txt data into mysql DB
php -q /home/xxxxx/public_html/utils/importCumulusFile.php type=realtime key=xxxx table=RealTime file=../data/realtime.txt
cron job works fine but the LogDateTime field is inserted with 0000-00-00 00:00:00 instead of current time stamp for the first time imsert and then no other records are inserted
Thanks in Advance
Raijin
I need some help
I am using cron job to insert realtime.txt data into mysql DB
php -q /home/xxxxx/public_html/utils/importCumulusFile.php type=realtime key=xxxx table=RealTime file=../data/realtime.txt
cron job works fine but the LogDateTime field is inserted with 0000-00-00 00:00:00 instead of current time stamp for the first time imsert and then no other records are inserted
Thanks in Advance
Raijin