mysqldump
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
mysqldump [2020/05/12 15:12] valerio |
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 \ | ||
| - | --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 </code> | ||
| - | |||
| - | |||
| <code> | <code> | ||
| - | mysql -u username INFORMATION_SCHEMA --skip-column-names --batch\ | + | mysqldump -uroot -p -f --add-locks --comments --create-options --disable-keys --dump-date --extended-insert\ |
| - | -e "select table_name from tables where table_type = 'VIEW' and table_schema = 'database'"\ | + | --log-error=/var/log/mariadb/dump/latest/dump.log --max-allowed-packet=32M --replace --routines --triggers\ |
| - | | xargs mysqldump -u username database > views.sql | + | --tab=/var/log/mariadb/dump/latest\ |
| + | --ignore-table=sprar_20200512_prod0.audit_user\ | ||
| + | sprar_20200512_prod0 > /var/log/mariadb/dump/latest/routines.sql | ||
| + | </code> | ||
| + | <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> | </code> | ||
| | | ||
| [[https://stackoverflow.com/questions/1658204/backing-up-views-with-mysql-dump|Sauce]] | [[https://stackoverflow.com/questions/1658204/backing-up-views-with-mysql-dump|Sauce]] | ||
mysqldump.1589289144.txt.gz · Last modified: 2020/05/12 15:12 by valerio
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
