When I export a database on my development PC, for import on my webhost, it contains the following line:
--
-- Table structure for table `vi_sr_videntity_0`
--
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY INVOKER VIEW `starrise`.`vi_sr_videntity_0` AS select `starrise`.`t_sr_u_identityfingerprint`.`c_r_Identity` AS `c_r_Identity`,`v_sr_videntityfingerprint`.`ID` AS `ID`,`v_sr_videntityfingerprint`.`FingerPrintID` AS `FingerPrintID`,`v_sr_videntityfingerprint`.`FingerPrintFingerPrint` AS `FingerPrintFingerPrint` from (`starrise`.`v_sr_videntityfingerprint` join `starrise`.`t_sr_u_identityfingerprint` on((`starrise`.`t_sr_u_identityfingerprint`.`c_id` = `v_sr_videntityfingerprint`.`ID`)));
Presumably because it says 'root'@'localhost', my hosted server won't accept the import. I'm stuck and I don't know what to do. Please help me know how to correctly transfer this database to my server.