hi
i have saved all of my CREATE VIEW syntaxes wirh comments in one .txt file, but after a notepad++ crush on my pc, i lost all the data in that file.
now i have all the VIEWS in local mysql, but the export version of these views are not exactly the same thing i wrote (result is the same, but it's not similar to syntax that i wrote).
I wonder is mysql save the original syntax of my views some where in it's log?

i think you're out of luck

what parts of the CREATE VIEW statement are missing?