🗄️What WP Table Is This?
Home / WP All Import – Drag & Drop Import for CSV, XML, Excel & Google Sheets / wp_pmxi_imports

wp_pmxi_imports

Verified

Stores pmxi imports data created by this plugin.

CREATE TABLE Statement

CREATE TABLE `wp_pmxi_imports` (\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n  `parent_import_id` bigint NOT NULL DEFAULT '0',\n  `name` text COLLATE utf8mb4_unicode_520_ci,\n  `friendly_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\n  `type` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\n  `feed_type` enum('xml','csv','zip','gz','') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\n  `path` text COLLATE utf8mb4_unicode_520_ci,\n  `xpath` text COLLATE utf8mb4_unicode_520_ci,\n  `options` longtext COLLATE utf8mb4_unicode_520_ci,\n  `registered_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n  `root_element` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\n  `processing` tinyint(1) NOT NULL DEFAULT '0',\n  `executing` tinyint(1) NOT NULL DEFAULT '0',\n  `triggered` tinyint(1) NOT NULL DEFAULT '0',\n  `queue_chunk_number` bigint NOT NULL DEFAULT '0',\n  `first_import` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n  `count` bigint NOT NULL DEFAULT '0',\n  `imported` bigint NOT NULL DEFAULT '0',\n  `created` bigint NOT NULL DEFAULT '0',\n  `updated` bigint NOT NULL DEFAULT '0',\n  `skipped` bigint NOT NULL DEFAULT '0',\n  `deleted` bigint NOT NULL DEFAULT '0',\n  `changed_missing` bigint NOT NULL DEFAULT '0',\n  `canceled` tinyint(1) NOT NULL DEFAULT '0',\n  `canceled_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n  `failed` tinyint(1) NOT NULL DEFAULT '0',\n  `failed_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n  `settings_update_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n  `last_activity` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n  `iteration` bigint NOT NULL DEFAULT '0',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

Safe to delete?

If you have uninstalled WP All Import – Drag & Drop Import for CSV, XML, Excel & Google Sheets, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_pmxi_imports`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from WP All Import – Drag & Drop Import for CSV, XML, Excel & Google Sheets