Restore last night’s dump and assert on row counts

mysql -e 'DROP DATABASE IF EXISTS restore_check; CREATE DATABASE restore_check;'
zcat "$(ls -t /backup/shop-*.sql.gz | head -1)" | mysql restore_check

[ "$(mysql -Nse 'SELECT COUNT(*) FROM restore_check.orders')" -gt 0 ]