mysqldump - need to suppress some output

sneakyimp

I did a mysqldump from a database and see lines like this in the output:

/*!50001 CREATE ALGORITHM=UNDEFINED */

I'm getting an error when trying to restore this db dump into a new db that says I need SUPER priveleges to run this command.

I want to suppress any lines that involve creation of algorithms or any other operation requiring super privileges, but I have been unable to find any option in the mysqldump docs which will accomplish this.

Any advice would be much appreciated.

scrupul0us

http://resin.csoft.net/cgi-bin/man.cgi?sektion=1&topic=mysqldump

Options:

o --compact

      Produce less verbose output. This option enables the
      --skip-add-drop-table, --skip-add-locks,
      [B]--skip-comments[/B], --skip-disable-keys, and
      --skip-set-charset options.

sneakyimp

I've read the mysqldump documentation dozens of times. I checked all the options and none seem to apply to this particular type of output. I tried --skip-routines (or something like that) which seemed like the most appropriate and it didn't help.

The problem appeared to be the creation of views. I did --ignore-table=view_name on all the views and it's working now. Pain in the ass.

If you know of an option that prevents view creation, I would be glad to know which it is.