distal-attribute
distal-attribute
distal-attribute
distal-attribute

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

vikaskashikar posted 1 year 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?
vikaskashikar posted 1 year ago
Resolved - I think i was doing something wrong.

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

Thanks,
Martin
ansgar posted 3 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.