I use simple
mysqldump with only parameters are login and db details. No option of anykind is set. Now, when I recieve the dump file, it export the view in steps (I am sure you all know it, but just for my clarification)
- Placeholder table in top of file with other tables.
- then at end, it drop this table and create View with
This works good if I have to upload this database back to original server. But how I handle this when I have to import this data in development server where I do not get the same username as defined in production database? Is there any option I can use to elimmiate the "definer" in view. Why doesn't it simply use "Create View as..." syntax?
I try to read about it, but doesn't found any good information, Please enlight me on the topic thanks.