MySQL Forums
Forum List  »  Backup

Re: mySQL Dump & Restore dependency issue
Posted by: Peter Brawley
Date: October 07, 2019 11:02AM

Reported as a bug eight years ago, https://bugs.mysql.com/bug.php?id=61961, verified at that time, apparently never fixed. Consider adding to the bug report.

It's a circular dependency---a func references tables and a View references that func,

A workaround till it's fixed, for each db needing it ...

- run a query to produce a comma-separated list of information_schema.table_nameinformation_schema.table_name where table_type='view'

- run mysqldump set ignore-tables to that query resulkt --> script1

run it a 2nd time for just that table list to script2.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mySQL Dump & Restore dependency issue
349
October 07, 2019 11:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.