Home > Mobile >  MYSQL DB - New tables are created randomly
MYSQL DB - New tables are created randomly

Time:10-30

My DB has increased in size very much, above 10GB.

I see these tables:

  • emcxmp_wp_posts
  • zjrqwg_wp_posts
  • qtlmkn_wp_posts
  • shcjpe_wp_posts
  • stzbcj_wp_posts
  • tymbkf_wp_posts
  • ursnzw_wp_posts
  • vkhjml_wp_posts
  • oyjfup_wp_posts
  • voxfcz_wp_posts
  • xlhpaz_wp_posts
  • ybazlk_wp_posts
  • yjmify_wp_posts
  • ymsaun_wp_posts
  • yojkzl_wp_posts
  • yqlfun_wp_posts
  • wouevx_wp_posts
  • msyfsp_wp_posts
  • kqbjhz_wp_posts
  • kqjsio_wp_posts
  • lnfjsf_wp_posts
  • asvpky_wp_posts
  • bltyyt_wp_posts
  • cyuhqr_wp_posts
  • eudjso_wp_posts

And more, what happened and why these were created?

CodePudding user response:

This is the intended behaviour of the plugin WP Reset Pro.

It creates snapshots with names as yours:

  • naming template for snapshot tables is {6_char_random_hex}{table_prefix_for_your_site}{original_table_name}

To delete snapshots, use the appropriate function:

If you do not need a specific snapshot on your WordPress site, you can quickly delete it:

  • Open Tools -> WP Reset -> Snapshots
  • Scroll down to the "User Created Snapshots" card
  • Select a snapshot & open the "Action" menu
  • Click "Delete snapshot"
  • Confirm that you want to delete it by clicking the red button
  • Related