When trying to publish to web host, I get the error —
There was an error while importing your database data. Please make sure that your remote server meets the requirements and the user account you provided has read AND write privileges on that machine. (Error: 709 - Cannot delete or update a parent row: a foreign key constraint fails) Error code: -3017
IF I drop all rows from the table that I am publishing to, it works. All privileges are applied to the database user acct.
Is there a setting somewhere that can help resolve this issue?