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

It looks as though you may not have permissions to create views on your live server. If you are able to you should try adjusting the permissions that you have to allow for create view.

In the download area for PowerStore there is a known issues fix for users that do not have the ability to create views. You can download the files and read the read me for instructions on where to put the files.

These files are designed to be put in place before the store is installed. It is not recommended to manually install the store on your server. If you had gone through the installer on your server you would have been warned that you did not have the permissions to create the view.

I ran into the same exact problem when trying to connect my database that I was using for my local server to the remote server. I have already done the installation wizard through the local host. I updated the 5 or so files:

# install/2.php
# install/scripts/db.sql
# Admin/Update_ProductCoupons.php
# Admin/Products_Results.php
# WA_DataAssist /WA_AppBuilder_PHP.php

I made these updates and then tried to re-upload them to the remote server through FTP software. I am still getting the same error: #1227 - Access denied; you need the SUPER privilege for this operation.

Will I have to completely remove my files from my hosting provider and start over??? This seems a little troublesome, as I have been spending a week or so now adding products and such to my store. Please help me out.

-Mike

The installation must run with the updated files in order to get past the limitation of not being able to create views. If you ran it locally first then the db was created with the view. You will need to run the installation on your live server. Once you do that you can then export all of the tables that you have in your db to the live server, just make sure that you don't try to export the view or you will have problems.