mysqldump without "CREATE ALGORITHM" and "DEFINER"

mysql mysqldump database-backups

Sarke · Sep 19, 2014 · Viewed 7k times · Source

In my database backups and export I get something like the following:

/*!50001 DROP TABLE `vTime`*/;
/*!50001 DROP VIEW IF EXISTS `vTime`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`db_user`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `vTime` AS select ... */;

This causes problems when restoring since the "CREATE ALGORITHM" and "DEFINER" parts fail when trying to restore. Is there a way to make mysqldump just do a simple CREATE VIEW instead?
Bonus question: what do the /*!50001 parts mean?

EDIT: I should add that this is the error I'm getting:

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

EDIT 2: It appears that only the /*!50013 DEFINER= part is failing.