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