mysqldump -uroot -p -f --add-locks --comments --create-options --disable-keys --dump-date --extended-insert\ --log-error=/var/log/mariadb/dump/latest/dump.log --max-allowed-packet=32M --replace --routines --triggers\ --tab=/var/log/mariadb/dump/latest\ --ignore-table=sprar_20200512_prod0.audit_user\ sprar_20200512_prod0 > /var/log/mariadb/dump/latest/routines.sql mysqldump -uroot -p --add-locks --comments --create-options --disable-keys --dump-date --extended-insert\ --max-allowed-packet=16M --replace --routines --triggers --tab=/var/log/mariadb/dump/latest\ --where="1 limit 100" sprar_20200512_prod0 audit_user mysql -uroot -p INFORMATION_SCHEMA --skip-column-names --batch\ -e "select table_name from tables where table_type = 'VIEW' and table_schema = 'sprar_20200512_prod0'"\ | xargs mysqldump -uroot -p -f sprar_20200512_prod0 > /var/log/mariadb/dump/latest/views.sql [[https://stackoverflow.com/questions/1658204/backing-up-views-with-mysql-dump|Sauce]]