accidentally deleted a bunch of users – got backup but

  • Resolved opentoesock

    (@opentoesock)


    8 years, 5 months ago

    I thought I was on a demo site and started deleting users from the main user page…only to discover that I was on the live site.

    That was today.

    I have a backup before I started doing anything. But there have been some updates, posts, and purchases today also, so if I use the backup, I’ll not have this stuff.

    How do I combine the two backups so that I can get my users back and keep the other current stuff current?

    Thanks.

Viewing 10 replies - 1 through 10 (of 10 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    you can restore just the two tables wp_users and wp_usermeta and that will get your users back.

    Thread Starter opentoesock

    (@opentoesock)

    Oh that’s great news. But I’ve only done full restores.

    How do I take out just the two tables from the overall backup?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    check your back up to see if it broke out the database dump by tables. If not, you’ll have to make a copy of the database dump and delete the other tables from it. (Not fun.)

    Once you have those two tables, you can use phpmyadmin to import theme.

    Thread Starter opentoesock

    (@opentoesock)

    If I import each table, will it over-write the existing same named tables?

    Hello opentoesock,

    Just create an other database and import your backup in that databse. And then take backup for those two tables “wp_users” and “wp_usermeta”
    by exporting those tables indidually. And then import them into your original databse.
    Hope this will help you.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    It depends; so drop the tables first. (Make a backup before you start)

    hey, cedcommerce, that’s a very good idea!

    Thread Starter opentoesock

    (@opentoesock)

    I’ve taken out the 2 tables from the backup database and have named them wp_users.sql and wp_usermeta.sql.

    I’d like to import each one in the existing database but don’t know if the existing tables will be written over. I’m inclined to deleting/dropping each table first and then importing the new / replacement tables, but I’m nervous about this .. even though I’ve got backups for days.

    What’s the best way?

    To import these tables first take the new backup of tables from original database.
    And then make tables empty by truncating them and then import your backup tables.

    Thread Starter opentoesock

    (@opentoesock)

    Great – got it. Thanks much!

    Thread Starter opentoesock

    (@opentoesock)

    resolved

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘accidentally deleted a bunch of users – got backup but’ is closed to new replies.

Tags