dropping a table leaves view redundant

Asked by masood alam

One of our developers dropped a table from the database, the table called table1. Some weeks later we took a mysqldump and restore the dump back to a test machine and the restore process breaks. Developer had no idea and DBA had to step in.

Actually the view was referencing to the table1 which no longer exist and quite rightly the restore had to break. I was wondering if it is possible that when we drop a table the drop statement should fail if a view exist.

Question information

Language:
English Edit question
Status:
Expired
For:
Percona Server moved to https://jira.percona.com/projects/PS Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Launchpad Janitor (janitor) said :
#1

This question was expired because it remained in the 'Open' state without activity for the last 15 days.