Mysql Error on importing View

[Michael Russotti]

I'm having problems importing a mysql database. It is generating an error at create view.



Heres the query from the dump file

/*!50001 DROP TABLE `v_categories`*/;
/*!50001 DROP VIEW IF EXISTS `v_categories`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`DBUSERNAME`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_categories` AS select `C`.`categoryID` AS `categoryID`,`C`.`mainCategoryID` AS `mainCategoryID`,`C`.`categoryName` AS `categoryName`,`M`.`name` AS

`name`,`C`.`visible` AS `visible`,`M`.`priority` AS `main_priority`,`C`.`Priority` AS `priority` from (`categories` `C` join `categories_main` `M`) where (`M`.`id` =

`C`.`mainCategoryID`) */;

--