Skip to content

Instantly share code, notes, and snippets.

@trey8611
Last active December 2, 2020 14:23
Show Gist options
  • Save trey8611/46c48168b165b2f79525f809fc944b09 to your computer and use it in GitHub Desktop.
Save trey8611/46c48168b165b2f79525f809fc944b09 to your computer and use it in GitHub Desktop.
How to delete all history log entries in WP All Import | Custom SQL Query

You can manually delete the physical log files via FTP by deleting the sub-folder(s) inside the /wp-content/uploads/wpallimport/logs/ folder. As for the history log entries in the database (what you see on the "History Logs" page), you'll need to run an SQL query to delete them in bulk (you can run queries with this: https://wordpress.org/plugins/ari-adminer/). For example:

DELETE
FROM `wp_pmxi_history`

Some things to keep in mind here:

  1. Always back up your database before deleting things like this.

  2. This deletes all history log entries for every import. Add a WHERE clause to specify an import ID if necessary:

DELETE
FROM `wp_pmxi_history`
WHERE `import_id` = '2'
  1. Change the "wp_" prefix if you use a different one in your install.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment