"mysqldump: Got error: 1017: Can't find file" when doing a mysqldump of the reporting database

Products

• Network Observability
• Spectrum

Issue/Introduction

Spectrum@HostName /e/win32app/Spectrum/mysql/bin $ mysqldump --defaults-file=../my-spectrum.cnf --opt table=reporting.v_ncm_config_diff --ignore-table=reporting.v_security_string_accessibility_by_landscape--ignore-table=reporting.v_user_report_security --compress --routines --ignore-table=reporting.v_active_user_model --ignore-table=reporting.v_alarm_activity 

 

mysqldump: Got error: 1017: Can't find file:

'alarmbucket104857600_1620887577597' (errno: 2 - No such file or directory) when using LOCK TABLES

Resolution

Add --ignore-table=<tablename> to the command for the various bucket tables that might be missing.

I.e.

Spectrum@HostName$ mysqldump --defaults-file=../my-spectrum.cnf --opt table=reporting.v_ncm_config_diff --ignore-table=reporting.alarmbucket104857600_1620887577597

--ignore-table=reporting.v_security_string_accessibility_by_landscape--ignore-table=reporting.v_user_report_security --compress --routines --ignore-table=reporting.v_active_user_model --ignore-table=reporting.v_alarm_activity