Answers for "reset memberpress table"

reset memberpress table

TRUNCATE TABLE wp_mepr_subscriptions;
TRUNCATE TABLE wp_mepr_transactions;
TRUNCATE TABLE wp_mepr_events;
TRUNCATE TABLE wp_mepr_members;
TRUNCATE TABLE wp_mepr_jobs;
TRUNCATE TABLE wp_mepr_rule_access_conditions;
TRUNCATE TABLE wp_mepr_tax_rates;
TRUNCATE TABLE wp_mepr_tax_rate_locations;

reset memberpress table

DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('memberpresscoupon','memberpressgroup','memberpressproduct','mp-reminder', 'memberpressrule'));

DELETE FROM wp_posts WHERE post_type IN ('memberpresscoupon','memberpressgroup','memberpressproduct','mp-reminder', 'memberpressrule');

DELETE FROM wp_options WHERE option_name LIKE '%mepr%';