Ultimate Member User Meta rows excessive?

  • Resolved greywolfron

    (@greywolfron)


    6 months ago

    I am trying to migrate to another server and on restoring the site, I have over 4838845 meta rows in the database.

    The table name is tmp41fc0e_usermeta in the database and this is what it looks like.

    Is this normal?

    • This topic was modified 6 months ago by Yui. Reason: link removed
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support andrewshu

    (@andrewshu)

    Hello @greywolfron

    Sorry, I dont see how look s your tmp41fc0e_usermeta table.

    Regards.

    Moderator Yui

    (@fierevere)

    永子

    please do not post authorized access links in public places, your site can be hacked, damaged and your data stolen

    Thread Starter greywolfron

    (@greywolfron)

    I did not drop an access link.

    Anyway, the tmp was what I was seeing in the new vps site. The table in the online site is “wp-usermeta”. It had over 6 million rows in it. I deleted the rows that did not match my active users of 149 by identifying the “user_id” for each user and deleting all others in the table.

    I now have only 4299 rows in the online file.

    I was having hackers that were registering by the thousands until I install a spam plugin a couple of years ago. Even though I had removed all of the invalid registrations over a few days, the meta records were not deleted. Is this normal?

    Plugin Support andrewshu

    (@andrewshu)

    Hello @greywolfron

    Sorry, I can’t understand your question.

    Regards.

    Plugin Support andrewshu

    (@andrewshu)

    Hi @greywolfron

    This thread has been inactive for a while so we’re going to go ahead and mark it Resolved.

    Please feel free to re-open this thread if any other questions come up and we’d be happy to help. ??

    Regards

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.