because of the sheer number of errors i was getting from the navicat back i started to restore from a dump. It got all the way to the end and gave this error.
Code:
[Err] 1305 - FUNCTION peq.GetMobTypeByName does not exist
[Err] CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER 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`)));
[Msg] Finished - Unsuccessfully
--------------------------------------------------
i do not understand why this wouldn't work correctly this dump was made moments before i pulled the plug on my old ass hardware, saved to a flash drive and copied to the new hdd.
*edit*
so the world runs, and all the player data seems to have been restored and everything seems to be playing fine.. i sourced in the dump again but selected continue on errors, the above is the only one that i got at like 99%.. i am worried about that error however, what will it effect?