Database upload error
I set up store on my local server, then uploaded it to server. Changed the powerstoreconnection.php and went through database file to change database name and user to match what i have set up with my host. When trying to import my database from local server i get the following error.
SQL query: Documentation
-- --------------------------------------------------------
--
-- Table structure for table `ps3_coupondelete`
--
CREATE ALGORITHM = UNDEFINED DEFINER = `myusername`@`localhost` SQL SECURITY DEFINER VIEW `p15s6pfm_shop`.`ps3_coupondelete` AS (
SELECT `p15s6pfm_shop`.`ps3_couponproducts`.`CouponProductID` AS `CouponProductID` , `p15s6pfm_shop`.`ps3_couponproducts`.`CouponID` AS `CouponID` , `p15s6pfm_shop`.`ps3_couponproducts`.`ProductID` AS `ProductID` , concat( `p15s6pfm_shop`.`ps3_couponproducts`.`CouponID` , _latin1 '_', `p15s6pfm_shop`.`ps3_couponproducts`.`ProductID` ) AS `JoinedKey`
FROM `p15s6pfm_shop`.`ps3_couponproducts`
MySQL said: Documentation
#1227 - Access denied; you need the SUPER privilege for this operation