Just posting info as I can, maybe some will find it useful.
mysqldump need to add --routines option to get the views dumped.
Did that to my working test server and get the 4 bot Views but have an issue sourcing the vmgroups VIEW.
Final Structure from dump:
Code:
-- Temporary table structure for view `vwgroups`
--
DROP TABLE IF EXISTS `vwgroups`;
/*!50001 DROP VIEW IF EXISTS `vwgroups`*/;
/*!50001 CREATE TABLE `vwgroups` (
`groupid` int(4),
`mobtype` varchar(1),
`name` varchar(64),
`mobid` int(4),
`level` int(8) unsigned
) ENGINE=MyISAM */;
-- Final view structure for view `vwgroups`
--
/*!50001 DROP TABLE `vwgroups`*/;
/*!50001 DROP VIEW IF EXISTS `vwgroups`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `vwgroups` AS select `g`.`groupid` AS `groupid`,`GetMobTypeByName`(`g`.`name`) AS `mobtype`,`g`.`name` AS `name`,`g`.`charid` AS `mobid`,ifnull(`c`.`level`,`b`.`BotLevel`) AS `level` from ((`group_id` `g` left join `character_` `c` on((`g`.`name` = `c`.`name`))) left join `bots` `b` on((convert(`g`.`name` using utf8) = `b`.`Name`))) */;
The other 3 VIEW's get created fine but dies here, starts with "GetMobTypeByName".
Will look over skema and see what I come up with. At least I think the mysqldumps with the --routines will get all the database so next time....
Michael