Skip to content
  • Solutions
    By Role
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    By Infrastructure
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
  • Product
    • Plesk Features
    • Plesk Editions
    • What’s new
    • Pricing
    • Roadmap
    • Lifecycle Policy
    • Extensions Catalogue
  • Pricing
  • Extensions
    Featured Extensions
    • SocialBee
    • WP Toolkit
    • WP Guardian
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Premium Email
    • Email Security
    • SocialBee
    • WP Toolkit
    • WP Guardian
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Premium Email
    • Email Security
    Bundles and packs:
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack

    See all Extensions

  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • WP Guardian
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • WP Guardian
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
Plesk 360 login
Free Trial

Knowledge Base

Clone operations fail in the WP Toolkit: Unable to import database.

 
applications extensionscloningdatabasedatabase serverlinux

Symptoms

  • Plesk Obsidian running on a Linux-based operating system
  • One of the following errors is displayed after an attempt to perform a Smart update or Clone a WP instance (both actions involve a database cloning attempt via a new temporary database user):

    Failed to clone the installation: 'Unable to import database. Error message: ERROR 1227 (42000) at line 357 in file: '/var/www/vhosts/example.com/.wp-toolkit/2617/db_2617_rvtbwu.sql': Access denied; you need (at least one of) the SUPER privilege(s) for this operation

    [2024-04-02 12:29:44.723] 3686411:660bfa22315c5 ERR [extension/wp-toolkit] ERROR 1142 (42000) at line 94 in file: '/var/www/vhosts/reallygoodmarquees.co.uk/.wp-toolkit/49/db_49_ixb0ml.sql': TRIGGER command denied to user 'wp_bv7iv'@'localhost' for table `wp_test1`.`NcLp1_comments`

Cause

WP Toolkit is using a temporary user to import the database during the cloning process (which is always launched during the Smart Updates procedure) and fails if there is a trigger, which always has a DEFINER specified, because the definer will never match the WPTK temporary user's name.

For example the following could be seen in a database:

# MariaDB [wordpress_db]> show triggers like '%' G;
*************************** 1. row ***************************
Trigger: after_insert_comment
Event: INSERT
Table: wp588_comments
Statement: BEGIN
IF NEW.comment_content LIKE '%are you struggling to get comments on your blog?%' THEN
SET @lastInsertWpUsersId = (SELECT MAX(id) FROM `Sql1490171_1`.`wp588_users`);
SET @nextWpUsersID = @lastInsertWpUsersId + 1;
...
...
END IF;
END
Timing: AFTER
Created: NULL
sql_mode: NO_AUTO_VALUE_ON_ZERO
Definer: jdoe777@localhost
character_set_client: utf8mb4
collation_connection: utf8mb4_general_ci
Database Collation: utf8_general_ci

Resolution

  1. Connect to the server via SSH

  2. Create a dump for the database of the website that is being cloned:

    # plesk db dump wordpress_db > wordpress_db.sql

  3. Enter the database server, select the related database and remove the trigger:

    # plesk db 

    mysql > use wordpress_db;

    mysql > drop trigger after_insert_comment;

  4. Perform the upgrade or clone operation and restore the trigger manually (or import the whole original database dump).
Read the full article
Related Posts

How to Check Open Ports in Linux (Simple Commands & Tools)

Read More »

Linux Logs Explained

Read More »

Plesk with Centralized Database and Network File System

Read More »
Knowledge Base

Duplicate entries in Plesk WP Toolkit: nginx: [emerg] duplicate location “/fake-hotlink-stub”

Read More »

WP Toolkit Cloning hangs or stops after 60 seconds on a Plesk server

Read More »

Different actions in WP Toolkit fail with the error: Argument #1 ($callback) must be a valid callback, array must have exactly two members

Read More »

Unable to clone WordPress instance in WP Toolkit : PHP Fatal error: Uncaught Error: Class “WP_Upgrader_Skin” not found

Read More »

Hosting Wiki

  • Server Redundancy
  • Linux Containers
  • AMP
  • Bare Metal Server
  • MySQL
  • Oracle VM Server
  • Server Virtualization Software
  • Windows Server
  • Linux
  • SQL
  • Joomla! Toolkit
  • WP Toolkit
  • Plesk
  • SQL database
  • NoSQL Database
  • Web Server
  • DNS Server
  • SSH
X-twitter Linkedin Youtube Reddit Github
  • Product
  • Login
  • Pricing
  • Editions
  • For Partners
  • Partner Program
  • Contributor Program
  • Affiliate Program
  • Plesk University
  • Company
  • Blog
  • Careers
  • Events
  • About Plesk
  • Our Brand
  • Resources
  • User and Admin guides
  • Help Center
  • Migrate to Plesk
  • Contact Us
  • Hosting Wiki
  • Forum
  • Legal
  • Legal
  • Privacy Policy
  • Imprint

© 2025 WebPros International GmbH

Part of the WebPros®  Family