I hope you are doing well and that you can help me with this issue. My community site swirlonthru.com is fast approaching 10,000 users. I know for a fact that at least 3,000 of those users were auto generated from a mailing list and have never logged in. I would like to go back a year and delete all users that show up as never having logged in. What is the best way to do this. Is there a msql query that could acheive this without tearing the site in two. As it stands the site is impossible to move. I tried exporting one of my backups and only half of the database made it.
This brings me to step 2 of my goal. We'd like to upgrade the theme, Is there a way we could reset wordpress except for the users, images, and buddypress. Wipe the slate clean and install the completed theme on a fresh install?
I dont know the best way to proceed. The other thought I had was take advatage of the new buddypress restful api and get someone to programatically get all the data. But whatever I do I feel like it will be out of our budget, or out of my skillset.
:slight_frown: Thanks in advance.