phpmyadmin and views

[aarushi2001]

Hi,

When we create *.sql for out database, does it not copy views. I created *.sql and imported it to phpmyadmin, but it is not showing the view.

Do I have to re-write the view or there is some other solution?

 

[TonyGroves]

Were those files produced by mysqldump? mysqldump apparently does not dump views (at least there is no mention of them on the manpage at

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

)

 

[aarushi2001]

Thanks Tony for the reply. I re-created my view