Error
Error Code:
3067
MySQL Error 3067: Invalid Replication Filter Pattern
Description
This error occurs when a MySQL replication filter, such as `replicate-wild-do-table` or `replicate-wild-ignore-table`, is configured with a pattern that does not conform to the required 'db_pattern.table_pattern' format. It typically prevents replication from starting or functioning correctly.
Error Message
Supplied filter list contains a value which is not in the required format 'db_pattern.table_pattern'
Known Causes
3 known causesIncorrect Pattern Syntax
The provided `db_pattern.table_pattern` uses invalid characters, misplaced wildcards, or does not adhere to MySQL's specific format rules.
Missing Database-Table Separator
The critical dot (`.`) separator between the database pattern and the table pattern is absent, or an incorrect character is used instead.
Malformed Configuration Entry
The replication filter pattern in the `my.cnf` or `my.ini` file is improperly quoted, escaped, or contains syntax errors that lead to misinterpretation.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service