My mysqldump DDL file is filled with tons of this:
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `my_trigger`...
I've searched to no avail for an option to silence this.
My understanding is that this kind of output is necessary so that the script can successfully recreate the schema in what may be another version of mysql server. For my scenario with a closed system of installations, I know that the version will be the same as the source of the dump.
Again, I need to be able to make edits (manual or scripted) in the dump, and these outputs make the task quite a bit more daunting.
Elsewhere at SO, I saw a couple of questions on this, but folks have concentrated on preaching about why the tokens should be left alone. Kinder people recommended parsing the output on the command line to filter them out. Note that when I dump with phpMyAdmin, these tokens are not there.
So, there really isn't a neater option to skip this kind of output? I work on Windows and with PowerShell.