mysqldump and restore without a data file

time mysqldump --single-transaction --no-create-info --compact zabbix trends_uint | gzip | ssh user@x.y.z.q "gunzip | mysql -u zabbix zabbix"