Hello,
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?

Thanks!

since views don't contain any data, it's not surprising that they aren't included in the dump

do you dump your CREATE TABLE statements too, or just the data?

I have two dumps one is just structure only, no data. This I want to have done on a daily basis since the schema can change fairly often, new tables etc. The other is data and structure.

for the views, you will have to write your own script

run a query against the INFORMATION_SCHEMA to pick up the view names, then use these to generate the SHOW CREATE VIEW statements