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

vikaskashikar posted 2 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

Any ideas on how to solve this?
vikaskashikar posted 2 years ago
Resolved - I think i was doing something wrong.

Martinus posted 9 months ago
Hi Vikaskashikar,
I have the same problem, can you tell me how you solved this problem?

ansgar posted 9 months 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.

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