Export to SQL does not create view definitions but tables of the same name.

2 posts

[expired user #7586] posted 10 years ago in General

I need to export data and views from a database to another location. Tables are getting exported will, however views are created as tables. I am having version 8.2.0.4675.

Any ideas on how to solve this?

2 posts

[expired user #7586] posted 10 years ago

Resolved - I think i was doing something wrong.

Closed.

6 posts

[expired user #8600] posted 9 years ago

Hi Vikaskashikar,
I have the same problem, can you tell me how you solved this problem?

Thanks,
Martin

10152 posts

ansgar posted 9 years ago

Views are exported in two rounds. The first round exports views as ordinary tables with their columns, so there is no server error complaining about not yet existent tables or columns referenced by the view. The second round is done when all tables are created. The old tables are dropped and the real view is created.

mysqldump does it the same way, btw.