BackUp DataBase As SQL Dump (DATA ONLY), also exports VIEWs data giving me in my case an
“Error Code: 1288 – The target table vordenesdepago of the INSERT is not updatable” error
Suposing my views where updatable, exporting its data is useless, resulting in bigger dump files and slower export/import.
There is an old post about this issue:
[topic=”3034″] Bug: Export Table Data Also Exports View Data[/topic]
It also dosen't ignore 5.x Objects check options, exporting VIEWs structures and routines (if checked), and I think it would cause an “VIEW/PROCEDURE already exist” error, in case that the import could reach that part of the script, because a data only dump is for sure going to be imported into existent database/s
Example file attached.
Thanks!