Differences

This shows you the differences between two versions of the page.

--- mysqldump [2019/12/04 12:49]
valerio created
+++ mysqldump [2020/07/15 16:17] (current)
valerio
@@ Line 1: / Line 1: @@
-<code>mysqldump -uroot -p --add-locks --comments --create-options --disable-keys --dump-date --extended-insert \
+<code>
---log-error=/var/log/mariadb/sprar_prod191204/dump.log --max-allowed-packet=16M --replace --routines --triggers \
+mysqldump -uroot -p -f --add-locks --comments --create-options --disable-keys --dump-date --extended-insert\
---tab=/var/log/mariadb/sprar_prod191204 \
+ --log-error=/var/log/mariadb/dump/latest/dump.log --max-allowed-packet=32M --replace --routines --triggers\
---ignore-table=sprar_prod0.audit_user \
+ --tab=/var/log/mariadb/dump/latest\
---ignore-table=sprar_prod0.letteraInserimentor \
+ --ignore-table=sprar_20200512_prod0.audit_user\
---ignore-table=sprar_prod0.progettoRendicontazione \
+ sprar_20200512_prod0 > /var/log/mariadb/dump/latest/routines.sql
---ignore-table=sprar_prod0.beneficiario_has_servizi \
+</code>
---ignore-table=sprar_prod0.evento \
+<code>
-sprar_prod0 > routines.sql </code>
+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
+</code>
+<code>
+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
+</code>
+[[https://stackoverflow.com/questions/1658204/backing-up-views-with-mysql-dump|Sauce]]

WeeKi Vale

User Tools

Site Tools

Differences

Page Tools