backing up and restoring certain users

  • schwende

    (@schwende)


    6 years, 1 month ago

    Ok, I tried to search this, but I may not have used accurate terminology.
    I have latest wp installed on a red hat 6.10 server. I have the mysql database for wp installed on a separate server, also rhel 6.10, running mysql 5.5.
    I know I should update, but any time I make a mysql change, such as in the my.cnf, mysql will restart, but wp can’t establish a connection to the database.

    So, i figure the mysql db is the issue and I’d like to check and repair it.
    However, I’d like to get rid of a number of users and their sites, first.

    So, my question is this.
    Can I backup certain sites, and the data, and then restore them if needed? Obviously I could do the whole thing, but that would overwrite data changes from active users.

    I just want to backup certain users and their sites, so I can delete them, and restore just those one, if necessary. Is that possible?

Viewing 9 replies - 1 through 9 (of 9 total)
  • a2hostingrj

    (@a2hostingrj)

    6 years, 1 month ago

    I’d like to get rid of a number of users and their sites, first.

    I just want to backup certain users and their sites, so I can delete them, and restore just those one, if necessary. Is that possible?

    Are you talking about individual sites or users inside your site?

    Thread Starter schwende

    (@schwende)

    6 years, 1 month ago

    It would be individual sites.

    a2hostingrj

    (@a2hostingrj)

    6 years, 1 month ago

    Ok.

    There are several ways you can approach this:

    1. Adjust your server to make a snapshot of the user server/site. This way, if you keep the snapshot, you can easily restore it.

    2. Do usual backup routines in the server

    Thread Starter schwende

    (@schwende)

    6 years, 1 month ago

    Ok, would either of these methods allow me to cherry pick the sites I want to back up? If so, do you have a link that I could read up on this? I’ve been looking, but I haven’t found anything for doing backups or restoring only certain sites. I don’t want to just restore everything, as that would wipe out changes active user have made.

    Thank you for your time!

    a2hostingrj

    (@a2hostingrj)

    6 years, 1 month ago

    Ok, would either of these methods allow me to cherry pick the sites I want to back up?

    If you are in charge of the server (you are the one providing hosting services) yes. However, you keep mentioning users, so may be you want to expand of what is that you want to back up/remove?

    Thread Starter schwende

    (@schwende)

    6 years, 1 month ago

    Ok, I’ll try it this way, I’m not always up on terminology sometimes.
    I have a primary site, blog.com, lets say. Under that would be sub-sites I guess they would be called. So, blog.com/user1, blog.com/user2, ect.
    I have a large number that are old, and I want to delete just those. That part shouldn’t be much of an issue. But I’d like to back up just those ones I am deleting, in case I need to restore one of them. While NOT touching current sites.

    I probably should have led with something like this.

    a2hostingrj

    (@a2hostingrj)

    6 years, 1 month ago

    If each subsite is independent of each other, you will be able to just backup and keep the ones you want.

    If you are using multisite, you will have to follow another approach

    Thread Starter schwende

    (@schwende)

    6 years, 1 month ago

    Do you know the guide I could look at for this? I haven’t seem to have found it yet.

    a2hostingrj

    (@a2hostingrj)

    6 years, 1 month ago

    That’s beyond the scope of WordPress and it has more to do with Server Administration. There are plenty of guides on how to perform automated backups for sites.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘backing up and restoring certain users’ is closed to new replies.