I have done a few searches but have not found what I'm looking for. I have a MySQL database and I want to do a nightly dump, for now. This is really not that hard, but what I'm seeing is not what I expect. My views are not in the SQL dump in any kind of format to restore the view. Is there a switch or something that will create the view sql statement in the dump file as well?