I have changed my hosting Company and I have a backup of my SQL file. When I tried to import that to my new hosting Company via phpmyadmin, I get this error. How can I fix this problem?
SQL query:
/*!50001 CREATE ALGORITHM=UNDEFINED /
/!50013 [email protected] SQL SECURITY DEFINER /
/!50001 VIEW vwallorders AS select tbl_gf_codes.CodeId AS Id,cast(tbl_gf_codes.RequestedAt as date) AS OrderDate,tbl_gf_codes.UserId AS UserId from tbl_gf_codes union select tbl_gf_codes_slbf.CodeId AS Id,cast(tbl_gf_codes_slbf.RequestedAt as date) AS OrderDate,tbl_gf_codes_slbf.UserId AS UserId from tbl_gf_codes_slbf union select tbl_gf_log_requests.LogRequestId AS Id,cast(tbl_gf_log_requests.RequestedAt as date) AS OrderDate,tbl_gf_log_requests.UserId AS UserId from tbl_gf_log_requests */
MySQL said
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
SQL query:
/*!50001 CREATE ALGORITHM=UNDEFINED /
/!50013 [email protected] SQL SECURITY DEFINER /
/!50001 VIEW vwallorders AS select tbl_gf_codes.CodeId AS Id,cast(tbl_gf_codes.RequestedAt as date) AS OrderDate,tbl_gf_codes.UserId AS UserId from tbl_gf_codes union select tbl_gf_codes_slbf.CodeId AS Id,cast(tbl_gf_codes_slbf.RequestedAt as date) AS OrderDate,tbl_gf_codes_slbf.UserId AS UserId from tbl_gf_codes_slbf union select tbl_gf_log_requests.LogRequestId AS Id,cast(tbl_gf_log_requests.RequestedAt as date) AS OrderDate,tbl_gf_log_requests.UserId AS UserId from tbl_gf_log_requests */
MySQL said
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation