Re: mySQL Dump & Restore dependency issue
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.
Subject
Views
Written By
Posted
911
October 07, 2019 01:29AM
Re: mySQL Dump & Restore dependency issue
549
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.