Views have changed to Tables? How can this happen?

[dstrange]

Received some errors from a client regarding some reports from a VB app that reads data from MySQL views and generates crystal reports. After receiving a backup I noticed that a lot of the views are now listed as Tables in the schema.

Has anyone ever experienced this? Is there anything to look out for configuration wise? I know to fix the issue is to drop the transformed view tables and re-run the create view scripts.

Thanks in advance.

 

[AdaHacker]

Just out of curiosity, where are you seeing the views listed as tables? Is this in the output of SHOW CREATE TABLE, the information schema tables, or the dump file?

If you're seeing it in the backup produced by mysqldump, then that's normal. If you look closer, you'll see that the table is dropped and a view created. This bug report has an explanation.

 

[dstrange]

Through MySQL query browser and MySql Administrator they are displaying as tables.