Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm not sure if this can affect(someone correct me if I'm wrong), but check the order of the tables are restored, if the system try to restore a view before of the real table it will through an error
–
jcho360May 11 '12 at 13:36

1

@jcho360 views are always processed last (after all tables) in a mysqldump.
–
RolandoMySQLDBAMay 11 '12 at 14:15

I wasn't sure, and I read it somewhere, thanks anyway
–
jcho360May 11 '12 at 14:22

this problem may occur if one view references another, and the order the views are created don't take account of that
–
mcmillabJan 18 at 23:56