why some views will be table please?

[expired user #11440]'s profile image [expired user #11440] posted 6 years ago in Import/Export Permalink

When I right click the database, and use export database as sql, I get a sql file.

Then, I delete the database, and use File->Run SQL file, I think I can import the database, but I see, some view will be a table, the table's engine is MyISAM, but it was a view before, and some lines in the sql file are:

DROP VIEW IF EXISTS `table_tchm`;
DROP TABLE IF EXISTS `table_tchm`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `table_tcm` AS SELECT
...

What is my wrong please?

Please login to leave a reply, or register at first.