Details
Description
Customer has few legacy functions.
One of the function has some syntax error.
But more importantly customer is unable to take a dump of the function even with --force.
mysqldump --no-data --routines --events --triggers --force --databases xxxx> dump.sql
|
mysqldump: Couldn't execute 'SHOW CREATE FUNCTION `FF1`': Undeclared variable: DBPAY_DRAWING_AMT (1327) |
Force option is supposed to ignore the error, add a comment in the dump file and move on to the next object.
This doesnt happen for this particular function.
But the behaviour can be observed for "Views with missing tables" errors.