dump data only works
mysqldump -v --no-create-info --single-transaction zgx > /backup/zgx_data.sql
dump create info without data also works
mysqldump -v -d -R --triggers --result_file=/backup/zgx_ddl.sql zgx
mysqldump -v --dump-date --events --routines --triggers --result-file=/tmp/zgx.sql zgx
with --events causes 100% cpu and freezes
last part of log:
– Sending SELECT query...
– Retrieving rows...
– Retrieving table structure for table zgx_zorgverzekeraars_audit...
– Sending SELECT query...
– Retrieving rows...
^C
mysqldump -v --dump-date --routines --triggers --result-file=/tmp/zgx.sql zgx
without --events runs ok
last part of log:
– Retrieving view structure for table zgx_zorgprofielen_wlz...
– It's base table, skipped
– Retrieving view structure for table zgx_zorgverzekeraars...
– It's base table, skipped
– Retrieving view structure for table zgx_zorgverzekeraars_audit...
– It's base table, skipped
– Disconnecting from 127.0.0.1...
mysqldump -v -d -R --events --triggers --result_file=/backup/zgx_ddl.sql zgx
running mysqldump without data (DDL only) with --events also freezes
mysqldump -v -d --events --result_file=/backup/zgx_ddl.sql zgx
dumping --events only causes freeze and 100% cpu
after updating the last modified event and rerun
mysqldump -v -d --events --result_file=/tmp/events.sql zgx, the mysqldump runs ok.
So it seemed the problem is caused by an incorrectly
saved event.
Please close this issue.