Phpmyadmin export VIEW without DATABASE_NAME or ALGORITHM <p>When exporting a sql dump with phpmyadmin it creates the VIEW table like this:</p> <pre><code>CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `database`.`table` etc.. </code></pre> <p>Each time I have to manually edit the sql dump to remove the <code>root</code> user and <code>database</code> name. </p>