So I needed to migrate to a different hosting, I downloaded the database, import it to the new hosting database, and it would produce an error at
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_bounceVisits` AS select `5toy_wsm_pageViews`.`visitId` AS `visitId`,`5toy_wsm_pageViews`.`visitLastActionTime` AS `visitLastActionTime` from `5toy_wsm_pageViews` group by `5toy_wsm_pageViews`.`visitId` having (count(`5toy_wsm_pageViews`.`URLId`) = 1) ;
This was the error
Access denied; you need (at least one of) the SUPER privilege(s) for this operation
So in the sql file I deleted all of this:
-- Structure for view `5toy_wsm_bounceVisits`
--
DROP TABLE IF EXISTS `5toy_wsm_bounceVisits`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_bounceVisits` AS select `5toy_wsm_pageViews`.`visitId` AS `visitId`,`5toy_wsm_pageViews`.`visitLastActionTime` AS `visitLastActionTime` from `5toy_wsm_pageViews` group by `5toy_wsm_pageViews`.`visitId` having (count(`5toy_wsm_pageViews`.`URLId`) = 1) ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_dateWiseBounce`
--
DROP TABLE IF EXISTS `5toy_wsm_dateWiseBounce`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_dateWiseBounce` AS select date_format(convert_tz(`5toy_wsm_bounceVisits`.`visitLastActionTime`,'+00:00','+00:00'),'%Y-%m-%d') AS `recordDate`,count(0) AS `bounce` from `5toy_wsm_bounceVisits` group by date_format(convert_tz(`5toy_wsm_bounceVisits`.`visitLastActionTime`,'+00:00','+00:00'),'%Y-%m-%d') ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_dateWiseBounceRate`
--
DROP TABLE IF EXISTS `5toy_wsm_dateWiseBounceRate`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_dateWiseBounceRate` AS select `dwb`.`recordDate` AS `recordDate`,`dwb`.`bounce` AS `bounce`,`dwp`.`pageViews` AS `pageViews`,`dwv`.`visitors` AS `visitors`,((`dwb`.`bounce` / `dwp`.`pageViews`) * 100) AS `bRatePageViews`,((`dwb`.`bounce` / `dwv`.`visitors`) * 100) AS `bRateVisitors` from ((`5toy_wsm_dateWiseBounce` `dwb` left join `5toy_wsm_dateWisePageViews` `dwp` on((`dwb`.`recordDate` = `dwp`.`recordDate`))) left join `5toy_wsm_dateWiseVisitors` `dwv` on((`dwb`.`recordDate` = `dwv`.`recordDate`))) ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_dateWiseFirstVisitors`
--
DROP TABLE IF EXISTS `5toy_wsm_dateWiseFirstVisitors`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_dateWiseFirstVisitors` AS select date_format(convert_tz(`5toy_wsm_uniqueVisitors`.`firstVisitTime`,'+00:00','+00:00'),'%Y-%m-%d') AS `recordDate`,count(`5toy_wsm_uniqueVisitors`.`visitorId`) AS `visitors` from `5toy_wsm_uniqueVisitors` group by date_format(convert_tz(`5toy_wsm_uniqueVisitors`.`firstVisitTime`,'+00:00','+00:00'),'%Y-%m-%d') ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_dateWisePageViews`
--
DROP TABLE IF EXISTS `5toy_wsm_dateWisePageViews`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_dateWisePageViews` AS select date_format(convert_tz(`5toy_wsm_pageViews`.`visitLastActionTime`,'+00:00','+00:00'),'%Y-%m-%d') AS `recordDate`,sum(`5toy_wsm_pageViews`.`totalViews`) AS `pageViews` from `5toy_wsm_pageViews` group by date_format(convert_tz(`5toy_wsm_pageViews`.`visitLastActionTime`,'+00:00','+00:00'),'%Y-%m-%d') ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_dateWiseVisitors`
--
DROP TABLE IF EXISTS `5toy_wsm_dateWiseVisitors`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_dateWiseVisitors` AS select date_format(convert_tz(`5toy_wsm_logUniqueVisit`.`visitLastActionTime`,'+00:00','+00:00'),'%Y-%m-%d') AS `recordDate`,count(0) AS `visitors` from `5toy_wsm_logUniqueVisit` group by date_format(convert_tz(`5toy_wsm_logUniqueVisit`.`visitLastActionTime`,'+00:00','+00:00'),'%Y-%m-%d') ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_hourWiseBounce`
--
DROP TABLE IF EXISTS `5toy_wsm_hourWiseBounce`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_hourWiseBounce` AS select hour(convert_tz(`5toy_wsm_bounceVisits`.`visitLastActionTime`,'+00:00','+00:00')) AS `hour`,count(0) AS `bounce` from `5toy_wsm_bounceVisits` where (convert_tz(`5toy_wsm_bounceVisits`.`visitLastActionTime`,'+00:00','+00:00') >= '2021-01-22 00:00:00') group by hour(convert_tz(`5toy_wsm_bounceVisits`.`visitLastActionTime`,'+00:00','+00:00')) ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_hourWiseBounceRate`
--
DROP TABLE IF EXISTS `5toy_wsm_hourWiseBounceRate`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_hourWiseBounceRate` AS select `hwb`.`hour` AS `hour`,`hwb`.`bounce` AS `bounce`,`hwp`.`pageViews` AS `pageViews`,`hwv`.`visitors` AS `visitors`,((`hwb`.`bounce` / `hwp`.`pageViews`) * 100) AS `bRatePageViews`,((`hwb`.`bounce` / `hwv`.`visitors`) * 100) AS `bRateVisitors` from ((`5toy_wsm_hourWiseBounce` `hwb` left join `5toy_wsm_hourWisePageViews` `hwp` on((`hwb`.`hour` = `hwp`.`hour`))) left join `5toy_wsm_hourWiseVisitors` `hwv` on((`hwb`.`hour` = `hwv`.`hour`))) ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_hourWiseFirstVisitors`
--
DROP TABLE IF EXISTS `5toy_wsm_hourWiseFirstVisitors`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_hourWiseFirstVisitors` AS select hour(convert_tz(`5toy_wsm_uniqueVisitors`.`firstVisitTime`,'+00:00','+00:00')) AS `hour`,count(0) AS `visitors` from `5toy_wsm_uniqueVisitors` where (convert_tz(`5toy_wsm_uniqueVisitors`.`firstVisitTime`,'+00:00','+00:00') >= '2021-01-22 00:00:00') group by hour(convert_tz(`5toy_wsm_uniqueVisitors`.`firstVisitTime`,'+00:00','+00:00')) ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_hourWisePageViews`
--
DROP TABLE IF EXISTS `5toy_wsm_hourWisePageViews`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_hourWisePageViews` AS select hour(convert_tz(`5toy_wsm_pageViews`.`visitLastActionTime`,'+00:00','+00:00')) AS `hour`,sum(`5toy_wsm_pageViews`.`totalViews`) AS `pageViews` from `5toy_wsm_pageViews` where (convert_tz(`5toy_wsm_pageViews`.`visitLastActionTime`,'+00:00','+00:00') >= '2021-01-22 00:00:00') group by hour(convert_tz(`5toy_wsm_pageViews`.`visitLastActionTime`,'+00:00','+00:00')) ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_hourWiseVisitors`
--
DROP TABLE IF EXISTS `5toy_wsm_hourWiseVisitors`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_hourWiseVisitors` AS select hour(convert_tz(`5toy_wsm_logUniqueVisit`.`firstActionVisitTime`,'+00:00','+00:00')) AS `hour`,count(0) AS `visitors` from `5toy_wsm_logUniqueVisit` where (convert_tz(`5toy_wsm_logUniqueVisit`.`firstActionVisitTime`,'+00:00','+00:00') >= '2021-01-22 00:00:00') group by hour(convert_tz(`5toy_wsm_logUniqueVisit`.`firstActionVisitTime`,'+00:00','+00:00')) ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_monthWiseBounce`
--
DROP TABLE IF EXISTS `5toy_wsm_monthWiseBounce`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_monthWiseBounce` AS select date_format(convert_tz(`5toy_wsm_bounceVisits`.`visitLastActionTime`,'+00:00','+00:00'),'%Y-%m') AS `recordMonth`,count(0) AS `bounce` from `5toy_wsm_bounceVisits` group by date_format(convert_tz(`5toy_wsm_bounceVisits`.`visitLastActionTime`,'+00:00','+00:00'),'%Y-%m-') ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_monthWiseBounceRate`
--
DROP TABLE IF EXISTS `5toy_wsm_monthWiseBounceRate`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_monthWiseBounceRate` AS select `mwb`.`recordMonth` AS `recordMonth`,`mwb`.`bounce` AS `bounce`,`mwp`.`pageViews` AS `pageViews`,`mwv`.`visitors` AS `visitors`,((`mwb`.`bounce` / `mwp`.`pageViews`) * 100) AS `bRatePageViews`,((`mwb`.`bounce` / `mwv`.`visitors`) * 100) AS `bRateVisitors` from ((`5toy_wsm_monthWiseBounce` `mwb` left join `5toy_wsm_monthWisePageViews` `mwp` on((`mwb`.`recordMonth` = `mwp`.`recordMonth`))) left join `5toy_wsm_monthWiseVisitors` `mwv` on((`mwb`.`recordMonth` = `mwv`.`recordMonth`))) ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_monthWiseFirstVisitors`
--
DROP TABLE IF EXISTS `5toy_wsm_monthWiseFirstVisitors`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_monthWiseFirstVisitors` AS select date_format(convert_tz(`5toy_wsm_uniqueVisitors`.`firstVisitTime`,'+00:00','+00:00'),'%Y-%m') AS `recordMonth`,count(`5toy_wsm_uniqueVisitors`.`visitorId`) AS `visitors` from `5toy_wsm_uniqueVisitors` group by date_format(convert_tz(`5toy_wsm_uniqueVisitors`.`firstVisitTime`,'+00:00','+00:00'),'%Y-%m') ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_monthWisePageViews`
--
DROP TABLE IF EXISTS `5toy_wsm_monthWisePageViews`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_monthWisePageViews` AS select date_format(convert_tz(`5toy_wsm_pageViews`.`visitLastActionTime`,'+00:00','+00:00'),'%Y-%m') AS `recordMonth`,sum(`5toy_wsm_pageViews`.`totalViews`) AS `pageViews` from `5toy_wsm_pageViews` group by date_format(convert_tz(`5toy_wsm_pageViews`.`visitLastActionTime`,'+00:00','+00:00'),'%Y-%m') ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_monthWiseVisitors`
--
DROP TABLE IF EXISTS `5toy_wsm_monthWiseVisitors`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_monthWiseVisitors` AS select date_format(convert_tz(`5toy_wsm_logUniqueVisit`.`visitLastActionTime`,'+00:00','+00:00'),'%Y-%m') AS `recordMonth`,count(0) AS `visitors` from `5toy_wsm_logUniqueVisit` group by date_format(convert_tz(`5toy_wsm_logUniqueVisit`.`visitLastActionTime`,'+00:00','+00:00'),'%Y-%m') ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_pageViews`
--
DROP TABLE IF EXISTS `5toy_wsm_pageViews`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_pageViews` AS select `LV`.`visitId` AS `visitId`,`LV`.`URLId` AS `URLId`,`LV`.`keyword` AS `keyword`,`LV`.`refererUrlId` AS `refererUrlId`,`LU`.`countryId` AS `countryId`,`LU`.`regionId` AS `regionId`,count(0) AS `totalViews`,max(`LV`.`serverTime`) AS `visitLastActionTime` from (`5toy_wsm_logVisit` `LV` left join `5toy_wsm_logUniqueVisit` `LU` on((`LV`.`visitId` = `LU`.`id`))) group by `LV`.`visitId`,`LV`.`URLId` ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_uniqueVisitors`
--
DROP TABLE IF EXISTS `5toy_wsm_uniqueVisitors`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_uniqueVisitors` AS select `LU`.`id` AS `id`,`LU`.`visitorId` AS `visitorId`,sum(`LU`.`totalTimeVisit`) AS `totalTimeVisit`,min(`LV`.`serverTime`) AS `firstVisitTime`,`LU`.`refererUrlId` AS `refererUrlId` from (`5toy_wsm_logUniqueVisit` `LU` left join `5toy_wsm_logVisit` `LV` on((`LV`.`visitId` = `LU`.`id`))) group by `LU`.`visitorId` ;
-- --------------------------------------------------------
--
-- Structure for view `5toy_wsm_visitorInfo`
--
DROP TABLE IF EXISTS `5toy_wsm_visitorInfo`;
CREATE ALGORITHM=UNDEFINED DEFINER=`mbluhiqcygcjvfgk`@`10.%` SQL SECURITY DEFINER VIEW `5toy_wsm_visitorInfo` AS select `LV`.`
And it worked, it imported succesfully but im worried that it might broke something, I had a traffic/visitors plugin my best bet is that it was the data from that plugin, if it is, it doesnt matter. But if wsm means woocommerce stock manager that seems important