Unable to clone a WordPress instance that contains VIEW with a database user as DEFINER in its database: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

As a workaround, delete the view containing database user as a definer:

1. Connect to a Plesk server via SSH.

2. Retrieve name of the source instance database:

   # grep DB_NAME /var/www/vhosts/example.com/httpdocs/wp-config.php
   define( ‘DB_NAME’, ‘wp_source’ );

3. Create a dump of the affected WordPress database from the error:

   # plesk db dump wp_source > wp_source.sql

4. Find the view name:

   # grep “view structure” ./wp_source.sql
   — Final view structure for view `random_view`

5. Log in to MySQL and select the affected WordPress database:

   # plesk db
   mysql> USE wp_source;

6. Copy the view, so it can be recreated on the source database and on the cloned database after deleting. Save the output of the following command:

   mysql> show create table random_viewG

7. Delete the view:

   mysql> DROP VIEW random_view;
   mysql> exit;

8. Clone the WordPress instance in Plesk.

9. Log in to MySQL and recreate the view in both original and cloned databases by pasting the output of the command that goes after “Create Table:” in step 6.