I use mysqlpump to backup database:
mysqlpump --single-transaction --add-drop-database --skip-definer \
--databases mydatabase --result-file /opt/myservice/backup/export.sql
My DB contains several views, and some of them are exported with totally incorrect SELECTs in the CREATE VIEW queries like this one:
CREATE VIEW `careerpulse-staging`.`user_view` AS SELECT 1 AS `id`, 1 AS `name`, 1 AS `department`, 1 AS `manager_id` ;
Why is it happening and how can I fix that?