How to add the weather in WordPress

<?php echo do_shortcode('[wunderground location="zmw:00000.1.16059" iconset="Incredibile" class="meteo" layout="current" measurement="c" language="IT" hidedata="search,conditions"]'); ?>

Exporting MySQL into a second DB without replacing tables

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