by Cristian Balan | Oct 24, 2016 | WordPress
Weather Underground
<?php echo do_shortcode('[wunderground location="zmw:00000.1.16059" iconset="Incredibile" class="meteo" layout="current" measurement="c" language="IT" hidedata="search,conditions"]'); ?>
https://github.com/katzwebservices/Wunderground
by Cristian Balan | Oct 22, 2016 | Twitter
by Cristian Balan | Oct 21, 2016 | DB
The following command exports a MySQL database allowing to import the result in a second DB without dropping the existing tables.
mysqldump --single-transaction --no-create-info --insert-ignore DB TABLE --where="EXISTS(SELECT 1 FROM TABLE_NAME WHERE COLLUMN_NAME__datetime > now() - interval 6 month)" | pv | gzip > DUMPDB.sql.gz
pv DUMP.sql.gz | gunzip | mysql --force dbname