WeeKi Vale

**This is an old revision of the document!**

mysqldump -uroot -p --add-locks --comments --create-options --disable-keys --dump-date --extended-insert \
--log-error=/var/log/mariadb/sprar_prod191204/dump.log --max-allowed-packet=16M --replace --routines --triggers \
--tab=/var/log/mariadb/sprar_prod191204 \
--ignore-table=sprar_prod0.audit_user \
--ignore-table=sprar_prod0.letteraInserimentor \
--ignore-table=sprar_prod0.progettoRendicontazione \
--ignore-table=sprar_prod0.beneficiario_has_servizi \
--ignore-table=sprar_prod0.evento \
sprar_prod0 > routines.sql 

mysql -u username INFORMATION_SCHEMA --skip-column-names --batch\
 -e "select table_name from tables where table_type = 'VIEW' and table_schema = 'database'"\
 | xargs mysqldump -u username database > views.sql

Sauce