![]() Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/corals/ |
use corals_mets-rebuild UPDATE wp_options SET option_value = replace(option_value, 'https://metras.co','https://mets-rebuild.corals.io/') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET guid = replace(guid, 'https://metras.co','https://mets-rebuild.corals.io/'); UPDATE wp_posts SET post_content = replace(post_content, 'https://metras.co', 'https://mets-rebuild.corals.io/'); UPDATE wp_postmeta SET meta_value = replace(meta_value,'https://metras.co','https://mets-rebuild.corals.io/'); UPDATE wp_options SET option_value = replace(option_value, 'http://127.0.0.1/wordpress','https://mets-rebuild.corals.io') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET guid = replace(guid, 'https://mets-rebuild.corals.io//','https://mets-rebuild.corals.io/'); UPDATE wp_posts SET post_content = replace(post_content, 'https://mets-rebuild.corals.io//', 'https://mets-rebuild.corals.io/'); UPDATE wp_postmeta SET meta_value = replace(meta_value,'https://mets-rebuild.corals.io//','https://mets-rebuild.corals.io/'); cd use corals_mets-rebuild select * from wp_posts where id = 5 ; select * from wp_posts where id = 5; show databases ; use corls_metras use corals_metras show tables; drop all tables; SELECT CONCAT('DROP TABLE IF EXISTS ', table_name, ';') FROM information_schema.tables WHERE table_schema = 'corals_metras'; SELECT CONCAT('DROP TABLE IF EXISTS ', table_name, ';') FROM information_schema.tables WHERE table_schema = 'corals_metras'; show tables; SELECT CONCAT('DROP TABLE IF EXISTS ', table_name, ';') FROM information_schema.tables WHERE table_schema = 'corals_metras'; DROP TABLE IF EXISTS wp_give_commentmeta; DROP TABLE IF EXISTS wp_*; DROP TABLE IF EXISTS wp_ppress_subscriptions; DROP TABLE IF EXISTS wp_give_commentmeta; | | DROP TABLE IF EXISTS wp_ppress_subscriptions; | | | DROP TABLE IF EXISTS wp_ppress_subscriptions; | DROP TABLE IF EXISTS wp_options; | | | DROP TABLE IF EXISTS wp_options; | DROP TABLE IF EXISTS wp_wpforms_tasks_meta; | | | DROP TABLE IF EXISTS wp_wpforms_tasks_meta; | DROP TABLE IF EXISTS wp_comments; | | | DROP TABLE IF EXISTS wp_comments; | DROP TABLE IF EXISTS wp_searchwp_index; | | | DROP TABLE IF EXISTS wp_searchwp_index; | DROP TABLE IF EXISTS wp_ppress_orders; | | | DROP TABLE IF EXISTS wp_ppress_orders; | DROP TABLE IF EXISTS wp_sbi_feed_caches; | | | DROP TABLE IF EXISTS wp_sbi_feed_caches; | DROP TABLE IF EXISTS wp_give_subscriptionmeta; | | | DROP TABLE IF EXISTS wp_give_subscriptionmeta; | DROP TABLE IF EXISTS wp_ppress_coupons; | | | DROP TABLE IF EXISTS wp_ppress_coupons; | DROP TABLE IF EXISTS wp_terms; | | | DROP TABLE IF EXISTS wp_terms; | DROP TABLE IF EXISTS wp_redirection_groups; | | | DROP TABLE IF EXISTS wp_redirection_groups; | DROP TABLE IF EXISTS wp_termmeta; | | | DROP TABLE IF EXISTS wp_termmeta; | DROP TABLE IF EXISTS wp_usermeta; | | | DROP TABLE IF EXISTS wp_usermeta; | DROP TABLE IF EXISTS wp_redirection_items; | | | DROP TABLE IF EXISTS wp_redirection_items; | DROP TABLE IF EXISTS wp_redirection_logs; | | | DROP TABLE IF EXISTS wp_redirection_logs; | DROP TABLE IF EXISTS wp_links; | | | DROP TABLE IF EXISTS wp_links; | DROP TABLE IF EXISTS wp_ppress_customers; | | | DROP TABLE IF EXISTS wp_ppress_customers; | DROP TABLE IF EXISTS wp_actionscheduler_claims; | | | DROP TABLE IF EXISTS wp_actionscheduler_claims; | DROP TABLE IF EXISTS wp_give_comments; | | | DROP TABLE IF EXISTS wp_give_comments; | DROP TABLE IF EXISTS wp_sbi_instagram_posts; | | | DROP TABLE IF EXISTS wp_sbi_instagram_posts; | DROP TABLE IF EXISTS wp_ppress_forms; | | | DROP TABLE IF EXISTS wp_ppress_forms; | DROP TABLE IF EXISTS wp_commentmeta; | | | DROP TABLE IF EXISTS wp_commentmeta; | DROP TABLE IF EXISTS wp_sbi_instagram_feeds_posts; | | | DROP TABLE IF EXISTS wp_sbi_instagram_feeds_posts; | DROP TABLE IF EXISTS wp_aioseo_cache; | | | DROP TABLE IF EXISTS wp_aioseo_cache; | DROP TABLE IF EXISTS wp_searchwp_status; | | | DROP TABLE IF EXISTS wp_searchwp_status; | DROP TABLE IF EXISTS wp_wpmailsmtp_tasks_meta; | | | DROP TABLE IF EXISTS wp_wpmailsmtp_tasks_meta; | DROP TABLE IF EXISTS wp_give_sessions; | | | DROP TABLE IF EXISTS wp_give_sessions; | DROP TABLE IF EXISTS wp_sbi_sources; | | | DROP TABLE IF EXISTS wp_sbi_sources; | DROP TABLE IF EXISTS wp_wpr_rucss_used_css; | | | DROP TABLE IF EXISTS wp_wpr_rucss_used_css; | DROP TABLE IF EXISTS wp_give_sequential_ordering; | | | DROP TABLE IF EXISTS wp_give_sequential_ordering; | DROP TABLE IF EXISTS wp_redirection_404; | | | DROP TABLE IF EXISTS wp_redirection_404; | DROP TABLE IF EXISTS wp_aioseo_posts; | | | DROP TABLE IF EXISTS wp_aioseo_posts; | DROP TABLE IF EXISTS wp_wt_iew_action_history; | | | DROP TABLE IF EXISTS wp_wt_iew_action_history; | DROP TABLE IF EXISTS wp_sbi_instagram_feed_locator; | | | DROP TABLE IF EXISTS wp_sbi_instagram_feed_locator; | DROP TABLE IF EXISTS wp_searchwp_tokens; | | | DROP TABLE IF EXISTS wp_searchwp_tokens; | DROP TABLE IF EXISTS wp_aioseo_notifications; | | | DROP TABLE IF EXISTS wp_aioseo_notifications; | DROP TABLE IF EXISTS wp_give_log; | | | DROP TABLE IF EXISTS wp_give_log; | DROP TABLE IF EXISTS wp_imagify_files; | | | DROP TABLE IF EXISTS wp_imagify_files; | DROP TABLE IF EXISTS wp_postmeta; | | | DROP TABLE IF EXISTS wp_postmeta; | DROP TABLE IF EXISTS wp_give_subscriptions; | | | DROP TABLE IF EXISTS wp_give_subscriptions; | DROP TABLE IF EXISTS wp_wpr_rucss_resources; | | | DROP TABLE IF EXISTS wp_wpr_rucss_resources; | DROP TABLE IF EXISTS wp_ppress_meta_data; | | | DROP TABLE IF EXISTS wp_ppress_meta_data; | DROP TABLE IF EXISTS wp_term_relationships; | | | DROP TABLE IF EXISTS wp_term_relationships; | DROP TABLE IF EXISTS wp_give_migrations; | | | DROP TABLE IF EXISTS wp_give_migrations; | DROP TABLE IF EXISTS wp_wt_iew_ftp; | | | DROP TABLE IF EXISTS wp_wt_iew_ftp; | DROP TABLE IF EXISTS wp_give_formmeta; | | | DROP TABLE IF EXISTS wp_give_formmeta; | DROP TABLE IF EXISTS wp_posts; | | | DROP TABLE IF EXISTS wp_posts; | DROP TABLE IF EXISTS wp_give_revenue; | | | DROP TABLE IF EXISTS wp_give_revenue; | DROP TABLE IF EXISTS wp_sbi_feeds; | | | DROP TABLE IF EXISTS wp_sbi_feeds; | DROP TABLE IF EXISTS wp_give_donors; | | | DROP TABLE IF EXISTS wp_give_donors; | DROP TABLE IF EXISTS wp_ppress_plans; | | | DROP TABLE IF EXISTS wp_ppress_plans; | DROP TABLE IF EXISTS wp_give_donationmeta; | | | DROP TABLE IF EXISTS wp_give_donationmeta; | DROP TABLE IF EXISTS wp_wpfm_backup; | | | DROP TABLE IF EXISTS wp_wpfm_backup; | DROP TABLE IF EXISTS wp_give_donormeta; | | | DROP TABLE IF EXISTS wp_give_donormeta; | DROP TABLE IF EXISTS wp_actionscheduler_groups; | | | DROP TABLE IF EXISTS wp_actionscheduler_groups; | DROP TABLE IF EXISTS wp_wpmailsmtp_debug_events; | | | DROP TABLE IF EXISTS wp_wpmailsmtp_debug_events; | DROP TABLE IF EXISTS wp_ppress_formsmeta; | | | DROP TABLE IF EXISTS wp_ppress_formsmeta; | DROP TABLE IF EXISTS wp_imagify_folders; | | | DROP TABLE IF EXISTS wp_imagify_folders; | DROP TABLE IF EXISTS wp_wt_iew_mapping_template; | | | DROP TABLE IF EXISTS wp_wt_iew_mapping_template; | DROP TABLE IF EXISTS wp_wt_iew_cron; | | | DROP TABLE IF EXISTS wp_wt_iew_cron; | DROP TABLE IF EXISTS wp_ppress_ordermeta; | | | DROP TABLE IF EXISTS wp_ppress_ordermeta; | DROP TABLE IF EXISTS wp_actionscheduler_logs; | | | DROP TABLE IF EXISTS wp_actionscheduler_logs; | DROP TABLE IF EXISTS wp_aioseo_terms; | | | DROP TABLE IF EXISTS wp_aioseo_terms; | DROP TABLE IF EXISTS wp_smush_dir_images; | | | DROP TABLE IF EXISTS wp_smush_dir_images; | DROP TABLE IF EXISTS wp_igp_images; | | | DROP TABLE IF EXISTS wp_igp_images; | DROP TABLE IF EXISTS wp_ppress_sessions; | | | DROP TABLE IF EXISTS wp_ppress_sessions; | DROP TABLE IF EXISTS wp_wpr_rocket_cache; | | | DROP TABLE IF EXISTS wp_wpr_rocket_cache; | DROP TABLE IF EXISTS wp_term_taxonomy; | | | DROP TABLE IF EXISTS wp_term_taxonomy; | DROP TABLE IF EXISTS wp_searchwp_log; | | | DROP TABLE IF EXISTS wp_searchwp_log; | DROP TABLE IF EXISTS wp_users; | | | DROP TABLE IF EXISTS wp_users; | DROP TABLE IF EXISTS wp_wfls_2fa_secrets; | | | DROP TABLE IF EXISTS wp_wfls_2fa_secrets; | DROP TABLE IF EXISTS wp_actionscheduler_actions; | | | DROP TABLE IF EXISTS wp_actionscheduler_actions; | DROP TABLE IF EXISTS wp_wfls_settings; | | DROP TABLE IF EXISTS wp_wfls_settings; show tables; DROP TABLE IF EXISTS wp_give_commentmeta; DROP TABLE IF EXISTS wp_ppress_subscriptions; DROP TABLE IF EXISTS wp_options; DROP TABLE IF EXISTS wp_wpforms_tasks_meta; DROP TABLE IF EXISTS wp_comments; DROP TABLE IF EXISTS wp_searchwp_index; DROP TABLE IF EXISTS wp_ppress_orders; DROP TABLE IF EXISTS wp_sbi_feed_caches; DROP TABLE IF EXISTS wp_give_subscriptionmeta; DROP TABLE IF EXISTS wp_ppress_coupons; DROP TABLE IF EXISTS wp_terms; DROP TABLE IF EXISTS wp_redirection_groups; DROP TABLE IF EXISTS wp_termmeta; DROP TABLE IF EXISTS wp_usermeta; DROP TABLE IF EXISTS wp_redirection_items; DROP TABLE IF EXISTS wp_redirection_logs; DROP TABLE IF EXISTS wp_links; DROP TABLE IF EXISTS wp_ppress_customers; DROP TABLE IF EXISTS wp_actionscheduler_claims; DROP TABLE IF EXISTS wp_give_comments; DROP TABLE IF EXISTS wp_sbi_instagram_posts; DROP TABLE IF EXISTS wp_ppress_forms; DROP TABLE IF EXISTS wp_commentmeta; DROP TABLE IF EXISTS wp_sbi_instagram_feeds_posts; DROP TABLE IF EXISTS wp_aioseo_cache; DROP TABLE IF EXISTS wp_searchwp_status; DROP TABLE IF EXISTS wp_wpmailsmtp_tasks_meta; DROP TABLE IF EXISTS wp_give_sessions; DROP TABLE IF EXISTS wp_sbi_sources; DROP TABLE IF EXISTS wp_wpr_rucss_used_css; DROP TABLE IF EXISTS wp_give_sequential_ordering; DROP TABLE IF EXISTS wp_redirection_404; DROP TABLE IF EXISTS wp_aioseo_posts; DROP TABLE IF EXISTS wp_wt_iew_action_history; DROP TABLE IF EXISTS wp_sbi_instagram_feed_locator; DROP TABLE IF EXISTS wp_searchwp_tokens; DROP TABLE IF EXISTS wp_aioseo_notifications; DROP TABLE IF EXISTS wp_give_log; DROP TABLE IF EXISTS wp_imagify_files; DROP TABLE IF EXISTS wp_postmeta; DROP TABLE IF EXISTS wp_give_subscriptions; DROP TABLE IF EXISTS wp_wpr_rucss_resources; DROP TABLE IF EXISTS wp_ppress_meta_data; DROP TABLE IF EXISTS wp_term_relationships; DROP TABLE IF EXISTS wp_give_migrations; DROP TABLE IF EXISTS wp_wt_iew_ftp; DROP TABLE IF EXISTS wp_give_formmeta; DROP TABLE IF EXISTS wp_posts; DROP TABLE IF EXISTS wp_give_revenue; DROP TABLE IF EXISTS wp_sbi_feeds; DROP TABLE IF EXISTS wp_give_donors; DROP TABLE IF EXISTS wp_ppress_plans; DROP TABLE IF EXISTS wp_give_donationmeta; DROP TABLE IF EXISTS wp_wpfm_backup; DROP TABLE IF EXISTS wp_give_donormeta; DROP TABLE IF EXISTS wp_actionscheduler_groups; DROP TABLE IF EXISTS wp_wpmailsmtp_debug_events; DROP TABLE IF EXISTS wp_ppress_formsmeta; DROP TABLE IF EXISTS wp_imagify_folders; DROP TABLE IF EXISTS wp_wt_iew_mapping_template; DROP TABLE IF EXISTS wp_wt_iew_cron; DROP TABLE IF EXISTS wp_ppress_ordermeta; DROP TABLE IF EXISTS wp_actionscheduler_logs; DROP TABLE IF EXISTS wp_aioseo_terms; DROP TABLE IF EXISTS wp_smush_dir_images; DROP TABLE IF EXISTS wp_igp_images; DROP TABLE IF EXISTS wp_ppress_sessions; DROP TABLE IF EXISTS wp_wpr_rocket_cache; DROP TABLE IF EXISTS wp_term_taxonomy; DROP TABLE IF EXISTS wp_searchwp_log; DROP TABLE IF EXISTS wp_users; DROP TABLE IF EXISTS wp_wfls_2fa_secrets; DROP TABLE IF EXISTS wp_actionscheduler_actions; DROP TABLE IF EXISTS wp_wfls_settings; show tables; use corals_metras UPDATE wp_options SET option_value = replace(option_value, 'http://127.0.0.1/wordpress','https://mets.corals.io') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET guid = replace(guid, 'https://metras.co','https://mets.corals.io'); UPDATE wp_posts SET post_content = replace(post_content, 'https://metras.co', 'https://mets.corals.io'); UPDATE wp_postmeta SET meta_value = replace(meta_value,'https://metras.co','https://mets.corals.io'); DELETE FROM wp_options WHERE option_name LIKE '_transient_%'; Select FROM wp_options WHERE option_name LIKE '_transient_%'; Select * FROM wp_options WHERE option_name LIKE '_transient_%';